摘要：
http://www.postgresql.org/docs/9.3/static/functions-admin.htmlGeneric File Access Functions：普通文件的访问方法：digoal=# select pg_ls_dir('.'); pg_ls_dir ... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(181)
评论(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
阅读(302)
评论(0)
推荐(0)
摘要：
继承：http://www.postgresql.org/docs/9.3/static/ddl-inherit.html分区表：http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html分区表需要和trigger一起使用才可。CR... 阅读全文
posted @ 2014-05-30 10:34
bielidefeng
阅读(93)
评论(0)
推荐(0)
摘要：
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
阅读(127)
评论(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
阅读(208)
评论(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
阅读(198)
评论(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
阅读(84)
评论(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
阅读(111)
评论(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
阅读(84)
评论(0)
推荐(0)
摘要：
checkpoint参数描述：checkpoint的时候会将所有的脏数据都flush到磁盘上checkpoint_timeout：两次checkpoint间隔时长checkpoint_segments:两次checkpoint间隔最大的xlog日志文件数量(指的是pg_xlog下的文件：000000... 阅读全文
posted @ 2014-05-30 10:33
bielidefeng
阅读(588)
评论(0)
推荐(0)
浙公网安备 33010602011771号