Reputation
8,797
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 15 18
Newest
 Yearling
Impact
~1.1m people reached

Jan
11
awarded  Yearling
Oct
15
awarded  Necromancer
Jul
14
comment how do you prevent dead rows from hanging around in postgresql?
Could you show us the configuration for auto vacuum? And do you use a specific auto vacuum configuration for this table?
May
27
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