615 reputation
415
bio website francs3.blog.163.com
location China
age 30
visits member for 3 years, 4 months
seen 2 days ago

Translator of PostgreSQL 9 Admin Cookbook , PostgreSQL DBA

6 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/


Sep
22
comment Can we pass a varchar/text datatype in to a variable in pgbench?
It's of no use , also get the same result "invalid input syntax for integer: "'user_'""
Sep
22
revised Can we pass a varchar/text datatype in to a variable in pgbench?
added 62 characters in body
Sep
22
revised Can we pass a varchar/text datatype in to a variable in pgbench?
deleted 4 characters in body
Sep
22
asked Can we pass a varchar/text datatype in to a variable in pgbench?
Jul
30
comment Replicate single table from Postgres 9.3 replica
I suggest use Londiste3 replicate a single table from primary db.
Jul
25
accepted Custom personal monitor sql by writing the .psqlrc file
Jul
25
comment Why is my composite index not used for this table?
How many data in your table ? and how many data you your sql get ?
Jul
25
comment Custom personal monitor sql by writing the .psqlrc file
@dezso : I test your advice , it works fine, thanks!
Jul
24
revised Custom personal monitor sql by writing the .psqlrc file
added 69 characters in body
Jul
24
asked Custom personal monitor sql by writing the .psqlrc file
Jul
8
awarded  Yearling
Jul
2
awarded  Curious
Jul
1
comment PostgreSQL partition pruning?
A very good answer.
Jun
16
comment In Postgresql, after pg_dump the access privileges on the database itself are not restored
try use a superuser instead when pg_dump.
Jun
3
comment What is the meaning of WAL file name?
@CraigRinger: thanks a lot!
Jun
3
accepted What is the meaning of WAL file name?
May
28
comment What is the meaning of WAL file name?
Does the wal composite of Timeline ID, Block ID, segment ID? I see this from the blog michael.otacoo.com/postgresql-2/…
May
28
comment What is the meaning of WAL file name?
Thanks for replying, I just want to know the exact meaning of wal filename.
May
28
revised What is the meaning of WAL file name?
added 4 characters in body
May
27
asked What is the meaning of WAL file name?