Monthly Archives: September 2008

Clean a PostgreSQL database directory

After building a database using an ill-judged algorithm, I ended up with junk in the database that consumed 600MB of space in the Postgres data directory. Deleting the bad data did not free this space immediately, and I was too … Continue reading

Posted in Tips | 1 Comment

Code samples for new SimpleDB feature: QueryWithAttributes

A couple of weeks ago, a new API operation was added to Amazon’s SimpleDB service: QueryWithAttributes. This operation makes it possible to retrieve all the attribute data for SimpleDB items that match a query. Previously, to retrieve item attributes it … Continue reading

Posted in AWS, Coding | Leave a comment