摘要：
Postgres-XC:http://blog.csdn.net/huguangshanse00/article/details/9636621http://blog.163.com/digoal@126/blog/static/1638770402013332335933/http://blog.... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(128)
评论(0)
推荐(0)
摘要：
全文检索：http://www.postgresql.org/docs/9.3/interactive/textsearch.htmlpostgres 切词:http://blog.163.com/digoal@126/blog/static/163877040201422410175698/ts_... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(215)
评论(0)
推荐(0)
摘要：
update/delete .. order by .. limit ..：update aa set b='mmmmmmmmbbbbbbbb' where a>10 order by a limit 1; 会报错：因为update 不能和order by 或limit 联合使用。如果需要使用则需要... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(216)
评论(0)
推荐(0)
摘要：
http://www.postgresql.org/docs/9.3/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICSEXECUTE format('UPDATE tbl SET %I = $1 WHERE key = $2'... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(98)
评论(0)
推荐(0)
摘要：
http://blog.163.com/digoal@126/blog/static/163877040201111694355822/http://blog.163.com/digoal@126/blog/static/1638770402012520105855757/游标使用注意点：http:... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(304)
评论(0)
推荐(0)
摘要：
btree & hash索引：http://www.kankanews.com/ICkengine/archives/127746.shtmlhttp://blog.csdn.net/tonyxf121/article/details/7976824http://www.uml.org.cn/sjj... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(172)
评论(0)
推荐(0)
摘要：
http://blog.163.com/digoal@126/blog/static/1638770402014395222222/pg_current_xlog_insert_location函数：指的是写入wal buffer的位置pg_current_xlog_location函数：指的是已经... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(246)
评论(0)
推荐(0)
摘要：
max_pool,num_init_children :通过pgpool连接进数据库的个数不能超过 num_init_children * max_pool 个connection_life_time：缓存的连接的过期时长。（超过num_init_children * max_pool后在一定空闲时... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(1360)
评论(0)
推荐(0)
摘要：
参看：http://blog.163.com/czg_e/blog/static/461045612012129105020629/http://pgpool.projects.pgfoundry.org/pgpool-II/doc/pgpool-zh_cn.html#connection_pool... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(619)
评论(0)
推荐(0)
摘要：
postgresql 流复制：http://francs3.blog.163.com/blog/static/4057672720136210240967/master(127.0.0.1:5432):数据目录：/home/pg93/test_rep/datainitdb -D $PGDATA -E... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(175)
评论(0)
推荐(0)
浙公网安备 33010602011771号