摘要：
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
阅读(251)
评论(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
阅读(1369)
评论(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
阅读(626)
评论(0)
推荐(0)
摘要：
http://docs.oracle.com/cd/E19253-01/819-6951/index.htmlhttp://lovesoo.org/linux-sar-command-detailed.htmlhttp://www.live-in.org/archives/922.htmlfree：... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(310)
评论(0)
推荐(0)
摘要：
http://blog.163.com/digoal@126/blog/static/16387704020131410250983/http://www.cnblogs.com/gaojian/archive/2013/08/07/3243045.htmlPITR有三种方式：1：recovery_... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(503)
评论(0)
推荐(0)
摘要：
http://my.oschina.net/Kenyon/blog/108850update tuple时会新增一个tuple然后将其隐藏。delete tuple时会隐藏tuple。postgres=# truncate table mmpostgres-# ;TRUNCATE TABLEpost... 阅读全文
posted @ 2014-05-30 10:33
bielidefeng
阅读(204)
评论(0)
推荐(0)
摘要：
bgwriter:http://book.51cto.com/art/201201/313208.htmautovacuum:http://book.51cto.com/art/201201/313211.htmhttp://www.postgresql.org/docs/9.2/static/ro... 阅读全文
posted @ 2014-05-30 10:33
bielidefeng
阅读(86)
评论(0)
推荐(0)
摘要：
http://blog.163.com/digoal@126/blog/static/1638770402013527920474/create extension pgstattuple;create extension pg_freespacemap;查看表文件路径 select * from ... 阅读全文
posted @ 2014-05-30 10:33
bielidefeng
阅读(114)
评论(0)
推荐(0)
摘要：
page:是对block的描述，该如何存储8K数据。以下是Page的结构：http://blog.chinaunix.net/uid-24774106-id-3764606.html查看page:http://www.postgresql.org/docs/9.2/static/pageinspec... 阅读全文
posted @ 2014-05-30 10:33
bielidefeng
阅读(86)
评论(0)
推荐(0)
摘要：
checkpoint参数描述：checkpoint的时候会将所有的脏数据都flush到磁盘上checkpoint_timeout：两次checkpoint间隔时长checkpoint_segments:两次checkpoint间隔最大的xlog日志文件数量(指的是pg_xlog下的文件：000000... 阅读全文
posted @ 2014-05-30 10:33
bielidefeng
阅读(602)
评论(0)
推荐(0)
浙公网安备 33010602011771号