摘要：The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run EXPLAIN by hand. This is 阅读全文
CPU informition
2016-05-27 11:41 by DataBases, 330 阅读, 0 推荐, 收藏,
摘要：tar jxvf util-linux-ng-2.18.bz2cd util-linux-ng-2.18/./configure --enable-arch --enable-partx --enable-write --without-ncursesmakemake install[root@lo 阅读全文
views of postgresql user password and encrypted or unencrypted
2016-05-12 11:27 by DataBases, 591 阅读, 0 推荐, 收藏,
摘要：password_encryption = onpostgres=# create user user1 with encrypted password 'user1';CREATE ROLEpostgres=# create user user2 with unencrypted password 阅读全文
configs for postgresql restart and postgresql reload
2016-05-11 17:33 by DataBases, 491 阅读, 0 推荐, 收藏,
摘要：postgres=# select name, setting, contextpostgres-# from pg_settings where context = 'postmaster'; name | setting | context + + allow_system_table_mods 阅读全文
pg_stat_statements
2016-05-05 13:41 by DataBases, 374 阅读, 0 推荐, 收藏,
摘要：Functions pg_stat_statements_reset() returns void pg_stat_statements_reset discards all statistics gathered so far by pg_stat_statements. By default, 阅读全文
PG sys function
2016-05-04 15:54 by DataBases, 614 阅读, 0 推荐, 收藏,
摘要：The System Catalogs of PostgreSQLscott=# \dS List of relations Schema | Name | Type | Owner + + + pg_catalog | pg_aggregate | table | postgres pg_cata 阅读全文
replication_slot and PostgreSQL Replication
2016-05-04 15:01 by DataBases, 1409 阅读, 0 推荐, 收藏,
摘要：主库IP：192.168.230.128 备库IP：192.168.230.129 PostgreSQL版本： 主备机PostgreSQL源码包均位于/opt/soft_bak OS:CentOS5 主备库PostgreSQL均安装在/usr/local/pg952目录下 数据目录均在/usr/lo 阅读全文
PostgreSQL wiki
2016-04-14 17:14 by DataBases, 468 阅读, 0 推荐, 收藏,
摘要：https://wiki.postgresql.org/wiki/Main_Page https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL http://www.depesz.com/ https 阅读全文
浙公网安备 33010602011771号