466 reputation
24
bio website 2ndquadrant.us
location Baltimore, MD
age 42
visits member for 2 years, 4 months
seen Oct 16 '13 at 17:44

Database consultant for 2ndQuadrant; author of High Performance PostgreSQL 9.0.


Dec
20
awarded  Yearling
Dec
20
awarded  Yearling
Nov
14
awarded  Revival
Oct
17
answered How to wait for PostgreSQL to be startable / restorable?
Oct
17
answered Proper storage size estimation technique for PostgreSQL
Oct
17
answered PostgreSQL Index Caching
Oct
17
answered High Availability for postgresql
Sep
15
comment Does PostgreSQL 9.1 Streaming Replication catch up after a lag without WAL archiving?
This answer is correct, but it highlights the problem. If you do ever pass wal_keep_segments, your replication is dead. Setting up file-based replication is not optional if you want a system that will survive a long disconnection from the master and catch back up.
Sep
15
answered Removing Archive Logs after PostgreSQL PITR online-recovery
May
10
answered How to know there is a maintenance job running on a postgresql database
May
10
answered Performance degradation while updating tables having 10s of millions of records
Feb
24
answered Fastest validation query in PostgreSQL
Feb
24
answered Database for building a realtime analytics system
Feb
24
answered Does running pg_dump on live db produce consistent backups?
Dec
20
awarded  Teacher
Dec
20
awarded  Supporter
Dec
20
comment New Job and Company uses PostgreSQL
It's possible to get the impression from what Scott wrote that the Windows version doesn't perform well because it's not being used/tuned in as many high performance installations. It's actually because there are architectural issues with how PostgreSQL runs on Windows that are at fault there.
Dec
20
answered How do I configure PostgreSQL 8.3 to log bind parameters?
Dec
20
comment PostgreSQL vs. Oracle High Availability solutions?
The reason there are so many replication choices out there is that each is suitable for a different type of application. The idea that some are "good enough" and other are not isn't true. For example, the trigger-based replication approach isn't popular for Oracle. But it is in PostgreSQL and MySQL, because it's suitable for types of applications Oracle doesn't aim at.
Dec
20
answered PostgreSQL vs. Oracle High Availability solutions?