Postgres Pro
Downloads
Home   >   mailing lists

Re: help speeding up a query in postgres 8.4.5 - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: help speeding up a query in postgres 8.4.5
Date
Msg-id 4D9C4182020000250003C3AB@gw.wicourts.gov
Whole thread Raw
In response to Re: help speeding up a query in postgres 8.4.5  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Responses Re: help speeding up a query in postgres 8.4.5
Re: help speeding up a query in postgres 8.4.5
List pgsql-performance
Tree view 
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.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

pgsql-performance by date:

Previous
From: "Maria L. Wilson"
Date:
Subject: Re: help speeding up a query in postgres 8.4.5
Next
From: Tomas Vondra
Date:
Subject: Re: help speeding up a query in postgres 8.4.5