Reputation
755
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
7 18
Impact
~55k people reached

  • 0 posts edited
  • 0 helpful flags
  • 187 votes cast
Jan
29
awarded  Notable Question
Oct
8
awarded  Popular Question
Sep
26
accepted write_location and flush_location of pg_stat_replication view
Sep
25
awarded  Notable Question
Sep
11
comment write_location and flush_location of pg_stat_replication view
Thanks a lot , but I'm still not understand.
Sep
7
asked write_location and flush_location of pg_stat_replication view
Apr
16
awarded  Popular Question
Feb
10
comment How can one optimize a query involving a sort and a LIKE?
I agree with dezso, may be something seriously wrong with your hardware
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 ?