Reputation
5,327
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 12 16
Newest
 Yearling
Impact
~626k people reached

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
Oct
21
comment Why Django session table grows on PostgreSQL
"idle in transaction" results in a VACUUM that can't clean up records that might me used in these transactions. What is causing these idle transactions?
Jun
25
comment Postgres Write Performance on Intel S3700 SSD
Test a 64-core machine with at least 64 concurrent clients (behind a connection pool ) to get descent results. A Postgres proces can only run on one core.
May
20
awarded  Constituent