3,887 reputation
11116
bio website
location Amsterdam, The Netherlands
age
visits member for 3 years, 8 months
seen 14 hours ago

alt text

CTO


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
May
19
awarded  Caucus
May
17
comment Performance of large queries on low bandwidth connections
Did you tell your management that version 8.3 is not supported anymore?
May
17
comment Performance of database with transactional data
Check your configuration and your queries, PostgreSQL can do thousands of transactions per second. And still run autovacuum. MySQL is so much worse, I'm glad we got rid of it! (not a rant, just a fact in our situation)
Apr
5
awarded  Guru
Mar
22
awarded  Nice Answer
Mar
19
comment Retrieving all PK and FK
Check the system table pg_constraint