| From: | Emmanuel Lacour <elacour(at)easter-eggs(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Query planner issue |
| Date: | 2006-01-31 00:27:25 |
| Message-ID: | 20060131002725.GF1320@easter-eggs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Jan 30, 2006 at 03:26:23PM -0800, Mark Lewis wrote:
> You have lots of dead rows. Do a vacuum full to get it under control,
> then run VACUUM more frequently and/or increase your FSM settings to
> keep dead rows in check. In 7.2 vacuum is pretty intrusive; it will be
> much better behaved once you can upgrade to a more recent version.
>
> You really, really want to upgrade as soon as possible, and refer to the
> on-line docs about what to do with your FSM settings.
>
Thanks! Vacuum full did it. I will now play with fsm settings to avoid
running a full vacuum daily...
--
Emmanuel Lacour ------------------------------------ Easter-eggs
44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 41 35 00 76
mailto:elacour(at)easter-eggs(dot)com - http://www.easter-eggs.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-01-31 01:55:53 | Re: Query planner issue |
| Previous Message | Jim Buttafuoco | 2006-01-30 23:37:22 | Re: Query planner issue |