On Fri, Nov 16, 2012 at 7:00 PM, Chris Tyler <ch...@tylers.info> 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@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/arm

Reply via email to