Reputation
5,627
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 13 18
Newest
 Nice Answer
Impact
~665k people reached

1d
awarded  Nice Answer
May
25
awarded  Enlightened
May
25
awarded  Nice Answer
Jan
25
reviewed Approve How do I list all databases and tables using psql?
Jan
13
comment Optimise huge Postgres table for fast read
You can leave the extra column and create a functional index: CREATE INDEX foo ON t1((md5(c1)); Use WHERE md5(c1) = md5('content') in your select and you'll be fine. Check EXPLAIN
Jan
12
comment Ways to speed up IN queries under PostgreSQL
A CTE is better solution.
Jan
11
awarded  Yearling
Nov
26
answered PostgreSQL procedural languages overhead (plpython / plsql / pllua…)
Nov
26
comment Performance Benchmark - MySQL vs PostgreSQL
Could you show us your testcases?
Sep
24
awarded  Autobiographer
Jul
22
comment Does running pg_dump on live db produce consistent backups?
@PabloFernandez: Done!
Jul
22
revised Does running pg_dump on live db produce consistent backups?
added 84 characters in body
Jul
6
comment Very slow simple PostgreSQL query on RDS
Could you also show the results from EXPLAIN ANALYZE ? And what are the settings for work_mem ?
Jun
12
awarded  Enlightened
Jun
12
awarded  Nice Answer
Jun
9
awarded  Necromancer
May
15
awarded  Revival
Jan
11
awarded  Yearling
Nov
14
awarded  Great Answer
Oct
30
awarded  Nice Answer