On Fri, Nov 16, 2012 at 7:00 PM, Chris Tyler <chris@xxxxxxxxxxx> 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. 500x on a box without random queries coming from all over, I suspect it won't be as impressive on production. I suspect you'll get pretty decent perf improvements if you drop and recreate the indexes and vacuum the DB. > (Investigations into PostgreSQL being insanely brain-dead continue. > Example: query strategy for "SELECT COUNT(*) FROM FOO;" involves a > "Sequential scan over 1496312 records." Srsly?) Probably either a bad index or a lack of an index in the right spot. Peter _______________________________________________ arm mailing list arm@xxxxxxxxxxxxxxxxxxxxxxx https://admin.fedoraproject.org/mailman/listinfo/arm
