Archive for the 'PostgreSQL' Category

Make sure you get an appropriate alert when a drive goes dead in your HP/Compaq RAID array

Wordpress inches closer to PostgreSQL support with a third-party plugin that maps MySQL calls to Postgres.

A SQL tip for inserting large numbers of database rows at a time. Improve performance by grouping inserts into fewer commits.

Working replication between two Postgres or MySQL database servers in under 5 minutes with few limitations – it’s true!

What I took home from cf.objective() 2009 and the slides from my two presentations on PostgreSQL and migrating to a framework.

CFPAYMENT announces 0.9 beta release including production-tested, documented gateways for payment processing on Braintree, Skipjack, Authorize.net and iTransact. More gateways coming!

A 2008 retrospective. A good way to feel accomplished and get excited about 2009.

Using the SQL EXISTS feature to more rapidly determine subquery results. Works in most databases like PostgreSQL, MS SQL, Oracle and so forth.

I enjoyed this piece by Jochem on a test conversion of his company’s database from MS SQL to open source Postgres. Performance was similar, disk space was 75% less and licensing costs? Well… those would go to $0.

Here’s how to do serious scaling with PostgreSQL for pennies:

Use pgpool for replication, load-balancing and failover
Run the whole thing on Amazon Web Services like Soocial

Done. There were some examples in AWS’ docs suggesting an “average web database of 100gb” with 100 I/Os per second would cost around $36/month to run. I’m pretty sure [...]