Posted in Tips on Sep 11th, 2008
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 impatient to wait for the auto vacuuming to kick in.
Here are the steps I [...]
Read Full Post »
Posted in AWS, Coding on Sep 7th, 2008
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 was necessary to perform a Query request, then perform follow-up GetAttributes requests for each result [...]
Read Full Post »