| From: | "Maria L(dot) Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | Szymon Guz <mabewlun(at)gmail(dot)com>, "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS AND APPLICATIONS, INC]" <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:37:28 |
| Message-ID: | 4D9C88B8.6000205@nasa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2011-04-06 18:13:19 | Re: help speeding up a query in postgres 8.4.5 |
| Previous Message | Kevin Grittner | 2011-04-06 15:33:38 | Re: help speeding up a query in postgres 8.4.5 |