On Fri, 2012-11-16 at 13:41 -0500, Jon Masters wrote:
So, can you perhaps provide a bit more detail? We know you've
been
looking at options around the tables, but...more info?
Long story short: db dump & reload for storage packing, with an LVM
snapshot as a safety net; should be done in about 20 minutes. Tests on a
parallel machine show a 500x performance improvement.
(Investigations into PostgreSQL being insanely brain-dead continue.
Example: query strategy for "SELECT COUNT(*) FROM FOO;" involves a
"Sequential scan over 1496312 records." Srsly?)
-Chris