3,627 reputation
11115
bio website
location Amsterdam, The Netherlands
age
visits member for 3 years, 6 months
seen Jul 22 at 4:27

alt text

CTO


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 with pgadmin
Check the system table pg_constraint
Mar
18
comment SOLVED: Postgres 8.4.5: Bad query plan vs Good query plan when changing date range on large data table
Several bugs in the queryplanner were fixed, that's why it's so important to get the patches in. It takes just a few seconds/minutes downtime.