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

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

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

摘要：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... 阅读全文

摘要：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 ... 阅读全文

摘要：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... 阅读全文

摘要：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... 阅读全文

摘要：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... 阅读全文

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

摘要：要安装 readline , readline-dev 开发包，要么使用 --without-readline 选项关闭 readline 功能。#yum install readline;#yum install readline-dev;readline 也就是命令行编辑，关闭的话，你直接用ps... 阅读全文

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