From: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Szymon Guz <mabewlun@gmail.com>
Cc: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS AND APPLICATIONS, INC] <m.l.wilson@nasa.gov>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: help speeding up a query in postgres 8.4.5
Date: Wed, 6 Apr 2011 11:37:28 -0400
Message-ID: <4D9C88B8.6000205@nasa.gov> (raw)
In-Reply-To: <4D9C4182020000250003C3AB@gw.wicourts.gov>
References: <4D9B6CBA.2050609@nasa.gov>
<BANLkTimiH7Gf-PH5g7pTk57+Cjvn-rss3w@mail.gmail.com>
<4D9C6BA6.4070305@nasa.gov>
<4D9C4182020000250003C3AB@gw.wicourts.gov>
yep - we use analyze and check the output. It's version 8.4.5 so no fsm
issues.
thanks, Maria
On 4/6/11 11:33 AM, Kevin Grittner wrote:
> "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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Maria.L.Wilson-1@nasa.gov, Kevin.Grittner@wicourts.gov, mabewlun@gmail.com, m.l.wilson@nasa.gov
Subject: Re: help speeding up a query in postgres 8.4.5
In-Reply-To: <4D9C88B8.6000205@nasa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox