581 reputation
313
bio website francs3.blog.163.com
location China
age 29
visits member for 2 years, 10 months
seen 22 hours ago

Translator of PostgreSQL 9 Admin Cookbook , PostgreSQL DBA

5 years working experience as a DBA,Good Knowledge on PostgreSQL, Oracle, MongoDB, Greenplumn and Linux.

Email: francs.tf@gmail.com

Blog: http://francs3.blog.163.com/

github: https://github.com/francs/


22h
comment Unable to Start PostgreSQL. kernel's SHMMAX parameter exceeded you limit
A very good answer!
2d
comment Why write ahead logs in PostgreSQL are generated every second
what's your archive_command say ?
2d
comment Why write ahead logs in PostgreSQL are generated every second
No, --with-wal-segsize can only be configured when you building your PostgreSQL.
Apr
10
comment How to Configure PostgreSQL Hotstandby Automatic Failover
Thank you very much!
Apr
10
comment How to Configure PostgreSQL Hotstandby Automatic Failover
Thanks for replying, If using pgbouncer + repmgr, do we need any script to manager the failover? May be should write a script to modify pgbouncer configuration file? do you have a blog about it? thanks !
Apr
10
comment How to Configure PostgreSQL Hotstandby Automatic Failover
Hi, which common automatic failover solutions do you use in production environment ? PgPool ? or pgbouncer+ repmgr?
Apr
10
comment How to Configure PostgreSQL Hotstandby Automatic Failover
I'm confused that I can edit someone else's post. Who can tell me why?
Apr
10
suggested suggested edit on How to Configure PostgreSQL Hotstandby Automatic Failover
Apr
8
awarded  Popular Question
Apr
8
comment Organizing a couple tables in postgresql
Use text datatype,and resolve the data in your program, but why not use MongoDB?
Apr
8
comment Why does my table hold duplicate primary keys?
@NielsKristian: you mean your master db version is 9.3.4, and slave version is 9.3.3?
Apr
8
comment How do I validate all my constraints in postgresql?
What's your postgresql version? And what did you do before ?
Apr
2
comment What are the disadvantages of PostgreSQL compared to other DBMS?
a very good answer!
Feb
27
comment Postgresql query slowed with table growth
In a session "set enable_bitmapscan=off;" and try the query again , and see the query plan.
Feb
27
comment PostgreSQL - VACUUM FULL does not free space back to the OS
After VACUUM FULL ,did the table size become smaller?
Feb
25
comment Can listen_addresses really be set to a list?
@CraigRinger: a very good answer!
Dec
25
answered How to efficiently copy millions of rows from one table to another in Postgresql?
Dec
24
comment Postgres cannot rename table because of AccessExcusiveLock
just try later and rename the table.
Nov
18
comment How can I force the optimizer to use hash join in PostgreSQL?
I am afraid no way! Just as bma said , You could try disabling all of the enable_* settings except for enable_hashjoin = on
Nov
12
answered Postgres log files not rotating