Reputation
693
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 17
Impact
~42k people reached

  • 0 posts edited
  • 0 helpful flags
  • 186 votes cast
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 ?
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.