随笔分类 -  PostgreSQL Basic

PostgreSQL主键索引膨胀的重建方法
摘要:普通的索引膨胀处理比较简单,主键的索引膨胀也不复杂,只是在新旧索引交替时有一些小处理。本试验在primary key上通过 建立第二索引来解决索引膨胀问题,适用9.3、9.4,其他版本使用前请实际测试。 创建测试表 生成测试数据 生成测试数据步骤略,这里为了清楚看到测试的情况,生成10000000条 阅读全文

posted @ 2017-02-04 17:23 Still water run deep 阅读(3427) 评论(0) 推荐(0)

PostgreSQL的权限查询
摘要:查看哪些用户对表sns_log_member_b_aciton有哪些权限: 可以看出有三个用户sns_log、sns_select和dwetl,sns_log用arwdDxt权限,sns_select和dwetl用户有r权限。权限后的sns_log名称是schema名称。 字母代表的权限的意思如下: 阅读全文

posted @ 2016-04-18 15:42 Still water run deep 阅读(13616) 评论(0) 推荐(0)

FSM, VISIBILITY MAP AND VACUUM
摘要:Update:Heikki’s slides arehere!Heikki Linnakangas gave a presentation this past Sunday atFOSDEMabout the improved free space map (FSM), which tracks u... 阅读全文

posted @ 2015-12-22 01:21 Still water run deep 阅读(330) 评论(0) 推荐(0)

understanding checkpoint_completion_target
摘要:Starting new blog series – explanation of various configuration parameters. I will of course follow no schedule or order – if I'd had to – it would... 阅读全文

posted @ 2015-11-30 23:55 Still water run deep 阅读(472) 评论(0) 推荐(0)

postgresql downgrade issue
摘要:Q:Dear Support Team,If we use ubuntu server to install postgresql9.4, how can we keep original data to downgrade postgresql from 9.4 to 9.3. Would it ... 阅读全文

posted @ 2015-11-29 09:43 Still water run deep 阅读(213) 评论(0) 推荐(0)

Using CSV-Format Log Output
摘要:Including csvlog in the log_destination list provides a convenient way to import log files into a database table. This option emits log lines in comma... 阅读全文

posted @ 2015-07-20 17:18 Still water run deep 阅读(302) 评论(0) 推荐(0)

Understanding postgresql.conf : log*
摘要:After loooong pause, adding next (well, second) post to the “series“. This time, I'd like to describe how logging works. And I don't mean binary loggi... 阅读全文

posted @ 2015-07-20 08:12 Still water run deep 阅读(1044) 评论(0) 推荐(0)

UNDERSTANDING POSTGRESQL.CONF: CHECKPOINT_SEGMENTS, CHECKPOINT_TIMEOUT, CHECKPOINT_WARNING
摘要:While there are somedocson it, I decided to write about it, in perhaps more accessible language – not as a developer, but as PostgreSQL user.Some part... 阅读全文

posted @ 2015-07-15 08:42 Still water run deep 阅读(590) 评论(0) 推荐(0)

pgbouncer配置
摘要:DESCRIPTIONpgbounceris a PostgreSQL connection pooler. Any target application can be connected topgbounceras if it were a PostgreSQL server, andpgboun... 阅读全文

posted @ 2014-11-01 16:18 Still water run deep 阅读(439) 评论(0) 推荐(0)

安装postgreSQL出现configure:error:readline library not found解决方法
摘要:要安装 readline , readline-dev 开发包,要么使用 --without-readline 选项关闭 readline 功能。#yum install readline;#yum install readline-dev;readline 也就是命令行编辑,关闭的话,你直接用ps... 阅读全文

posted @ 2014-08-03 18:23 Still water run deep 阅读(10389) 评论(0) 推荐(1)

createdb test时报global/pg_filenode.map不存在
摘要:实际上是存在的,看到说是ipv6占用了5432的端口号,看了一下的确是,将ipv6关闭重启系统即可。下面是关闭ipv6的方法:确认IPV6是否开启在Linux下确认IPv6是否已经被启用,可以从三个方面确定。1.使用ifconfig查看自己的IP地址是否含有IPv6地址。eth0 Link en... 阅读全文

posted @ 2014-07-28 11:22 Still water run deep 阅读(1275) 评论(0) 推荐(0)

导航