Re: help speeding up a query in postgres 8.4.5

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Szymon Guz" <mabewlun(at)gmail(dot)com>,<Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov>
Cc: "Maria Louise (LARC-E301)[SCIENCE SYSTEMS AND APPLICATIONS INC] Wilson" <m(dot)l(dot)wilson(at)nasa(dot)gov>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: help speeding up a query in postgres 8.4.5
Date: 2011-04-06 15:33:38
Message-ID: 4D9C4182020000250003C3AB@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Maria L. Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> wrote:

> Autovacuum is not running - but regular vacuums are being done
> twice daily.

Is the ANALYZE keyword used on those VACUUM runs? What version of
PostgreSQL is this. If it's enough to need fsm settings, do you run
with the VERBOSE option and check the end of the output to make sure
they are set high enough?

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Maria L. Wilson 2011-04-06 15:37:28 Re: help speeding up a query in postgres 8.4.5
Previous Message Maria L. Wilson 2011-04-06 13:36:58 Re: help speeding up a query in postgres 8.4.5