643 reputation
516
bio website francs3.blog.163.com
location China
age 30
visits member for 3 years, 5 months
seen Nov 19 at 8:10

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/


Nov
20
awarded  Popular Question
Nov
12
comment EXECUTE within function not using index?
@dezso: Because I think it's may differenct between function and psql client, just try .
Nov
12
comment EXECUTE within function not using index?
Try run the query in psql ,and see if the query use the index.
Nov
7
answered Call UPSERT function multiple times to different inputs
Oct
31
awarded  Notable Question
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!