On 11/16/2012 02:00 PM, Chris Tyler wrote: > 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?) Thanks! That's just the kind of stuff I think we wanted to know about, and yea, I've never been a huge postgres fan :) Jon. _______________________________________________ arm mailing list arm@xxxxxxxxxxxxxxxxxxxxxxx https://admin.fedoraproject.org/mailman/listinfo/arm
