postgreSQL,遇到can't have more than 2048 different append-only tables open for writing data at the

_________ is greater than God . _________ is more evil(\u90aa\u6076\u7684) than the Devil (\u6076\u9b54). The poor have

\u7b54\u6848\u662f Nothing is greater than God. Nothing is more evil than the Devil.

\u8fd9\u662f\u5012\u88c5\u53e5
\u800c\u4e14\u662f\u534a\u5012\u88c5

\u53ea\u8981\u662f\u5426\u5b9a\u526f\u8bcdnot ,no,not untill,not only,nowhere,hardly.seldom,never...\u4f4d\u4e8e\u53e5\u5b50\u53e5\u9996\uff0c\u5c31\u8981\u7528\u534a\u5012\u88c5\uff0c\u534a\u5012\u88c5\u6307\u7684\u662f\u5c06\u52a9\u52a8\u8bcd\uff0c\u7cfb\u52a8\u8bcd\uff0c\u60c5\u6001\u52a8\u8bcd\u4f4d\u4e8e\u4e3b\u8bed\u4e4b\u524d\uff0c



\u5f53\u7136\u8fd8\u6709\u5168\u5012\u88c5\uff0c\u5728\u8fd9\u91cc\u4e0d\u5f71\u54cd\uff0c\u4e5f\u6bd4\u8f83\u591a\uff0c\u53ef\u4ee5\u52a0\u6211\u4e3a\u597d\u53cb\uff0c\u5475\u5475\uff01
\u5b66\u4e60\u8fdb\u6b65\uff01

打开 poetgresql.conf (GreenPlum里要搜搜max_appendonly_tables,看看到底在哪里), 找到 max_appendonly_tables =
这一行,删除#注释,而后改大。这个错误是同时刻打开了2048个表写入,超过了限制造成的。

ps. 如果是在单机上运行,这是很不推荐的!!因为除非使用固态硬盘(SSD),并发写入会导致频繁的磁头移动,效率奇差、损害硬盘寿命,降低稳定性。

把postgresql.conf配置文件中的max_appendonly_tables改大点,大于2048.
比喻:max_appendonly_tables=3000.

  • 甯哥敤鐨勬暟鎹簱鏈夊摢鍑犵?璇曠潃闃愯堪姣忕鏁版嵁搴撶殑鐗圭偣鍜屼娇鐢ㄨ寖鍥
    绛旓細鍏崇郴鏁版嵁搴撱侀潪鍏崇郴鍨嬫暟鎹簱銆1銆佸叧绯绘暟鎹簱 鐗圭偣锛氭暟鎹泦涓帶鍒讹紱鍑忓皯鏁版嵁鍐椾綑绛夈傞傜敤鑼冨洿锛氬浜庣粨鏋勫寲鏁版嵁鐨勫鐞嗘洿鍚堥傦紝濡傚鐢熸垚缁┿佸湴鍧绛夛紝杩欐牱鐨勬暟鎹竴鑸儏鍐典笅闇瑕佷娇鐢ㄧ粨鏋勫寲鐨勬煡璇2銆侀潪鍏崇郴鏁版嵁搴 鐗圭偣锛氭槗鎵╁睍锛涘ぇ鏁版嵁閲忥紝楂樻ц兘锛涚伒娲荤殑鏁版嵁妯″瀷绛夈備娇鐢ㄨ寖鍥达細鎹ā鍨嬫瘮杈冪畝鍗曪紱闇瑕佺伒娲绘ф洿寮...
  • 濡備綍鍦―ocker瀹瑰櫒鍐呭浜掔浉鎷疯礉鏁版嵁
    绛旓細8d418a7b6021 postgres "/docker-entrypoint. 7 hours ago Up 7 hours test1 [root@oegw1 soft]# docker exec -t -i 8d418a7b6021 /bin/bash root@oegw1:/var/lib/postgresql# pwd /var/lib/postgresql root@oegw1:/var/lib/postgresql# ls data root@oegw1:/var...
  • 鐜板湪涓绘祦鐨勬暟鎹簱杞欢闄や簡oracle,杩樻湁閭d簺?
    绛旓細Oracle锛堢敳楠ㄦ枃锛塎S SQLServer DB2 Sybase
  • 浣滀负涓涓狫AVA绋嬪簭鍛, 搴旇鎺屾彙鍝簺鐭ヨ瘑, 鐩墠, 姣旇緝娴佽鐨刯ava寮鍙戞鏋...
    绛旓細鏀 鎸佷富娴佺殑鏁版嵁搴,濡PostgreSQL,MySQL; 浣跨敤浜嗙涓夋斁鐨勫紑婧愰」鐩,濡侶ibernate, Lucene, Struts; ...EJBCA鏄竴涓叏鍔熻兘鐨CA绯荤粺杞欢,瀹冨熀浜嶫2EE鎶鏈,骞舵彁渚涗簡涓涓己澶х殑銆侀珮鎬ц兘骞跺熀浜庣粍浠剁殑CA銆侲JBCA鍏煎叿
  • 濡備綍 鍦―ocker绐楀彛涓儴缃睵HP寮鍙戠幆澧
    绛旓細PHP 寮鍙戜綔涓轰緥瀛愯瑙 Docker 濡備綍甯冪疆寮鍙戠幆澧冦備竴鑸潵璇达紝涓涓 PHP 椤圭洰浼氶渶瑕佷互涓嬪伐鍏凤細Web 鏈嶅姟鍣: Nginx/Tengine Web 绋嬪簭: PHP-FPM 鏁版嵁搴: MySQL/PostgreSQL 缂撳瓨鏈嶅姟: Redis/Memcache 杩欐槸鏈绠鍗曠殑鏋舵瀯鏂瑰紡锛屽湪 Docker 鍙戝睍鏃╂湡锛孌ocker 琚ぇ閲忕殑婊ョ敤锛屾瘮濡傦紝涓涓暅鍍忓唴鍚姩澶氭湇鍔★紝鏃ュ織鏀堕泦渚濇棫...
  • 闃块噷浜戞湁鍝簺浜у搧鍜屾妧鏈?
    绛旓細浜戞暟鎹簱RDS:瀹屽叏鍏煎MySQL,SQLServer,PostgreSQL 浜戞暟鎹簱MongoDB鐗:涓夎妭鐐瑰壇鏈泦淇濊瘉楂樺彲鐢 浜戞暟鎹簱Redis...CA璇佷功鏈嶅姟:浜戜笂绛惧彂Symantec銆丆FCA銆丟eoTrustSSL鏁板瓧璇佷功,閮ㄧ讲绠鍗,杞绘澗瀹炵幇鍏ㄧ珯HTTPS鍖,闃茬洃鍚侀槻鍔寔
  • PHP鏄粈涔?
    绛旓細PHP鍦ㄦ暟鎹簱鏂归潰鐨勪赴瀵屾敮鎸侊紝涔熸槸瀹冭繀閫熻蛋绾㈢殑鍘熷洜涔嬩竴锛屽畠鏀寔涓嬪垪鐨勬暟鎹簱鎴栨槸鏁版嵁鏂囦欢锛欰dabas 銆丏銆 DBA銆乨Base 銆乨bm 銆乫ilePro 銆両nformix 銆両nterBase銆乵SQL 銆丮icrosoft SQL Server銆伮稭ySQL銆丼olid銆丼ybase銆 Oracle 銆PostgreSQL 鑰屽湪Internet涓婂畠涔熸敮鎸佷簡鐩稿綋澶氱殑閫氳鍗忚 (protocol锛夛紝鍖呮嫭浜嗕笌...
  • 濡備綍婵娲籒avicat?濡備綍娉ㄥ唽Navicat
    绛旓細Navicat鏄竴娆炬暟鎹簱绠$悊宸ュ叿, 鐢ㄤ簬绠鍖, 寮鍙戝拰绠$悊MySQL, SQL Server, SQLite, Oracle 鍜 PostgreSQL 鐨勬暟鎹簱锛涘綋鐒跺鏋滀綘鏄疢SSQL鐨勮瘽澶у彲浠ョ敤寰蒋鑷繁鎻愪緵鐨凪SSQL绠$悊杞欢锛涗絾鏄鏋滀綘鏄娇鐢∕YSQL鐨勮瘽灏卞彲鑳介渶瑕佺敤鍒癗avicat for MySQL杞欢锛涗絾鏄敱浜嶯avicat for MySQL鏄晢涓氳蒋浠讹紱鎵浠ヤ粬浠粎浠呮彁渚涜瘯鐢紱...
  • 鍖诲鏂囩尞妫绱㈤噸鐐
    绛旓細鏂囩尞妫绱㈢殑鏂规硶涓庨斿緞闈為噸鐐 鏂囩尞妫绱㈢殑姝ラ IM EM CA涓笓鍒╃储寮 BA SCI 鐗圭鏂囩尞 涓撳埄绫诲瀷 鏈烘4...璺ㄥ钩鍙版р曗曢傜敤浜嶭inux涓嶹indows绯荤粺,鏀寔SQL Server銆丱RACLE銆丮ySql銆丼ybase銆Postgresql绛夋暟鎹簱澶
  • 鏈灏忓寲瀹夎rhel6.5鍚庡浣曡В鍐硑um涓嶈兘浣跨敤鐨
    绛旓細Support MySQL Database client MySQL Database server NFS file server Network Infrastructure Server Network Storage Server Network file system client Networking Tools Office Suite and Productivity PHP Support Performance Tools Perl Support PostgreSQL Database client PostgreSQL Data...
  • 扩展阅读:www.sony.com.cn ... burberry日本官网 ... mac蜜桃奶茶314 ... postgresql doc ... paperpass免费入口 ... pubg mobile ... postgresql level ... postgresql linux ... postgresql python ...

    本站交流只代表网友个人观点,与本站立场无关
    欢迎反馈与建议,请联系电邮
    2024© 车视网