From: | Cedric Dufour (Cogito Ergo Soft) <cedric(dot)dufour(at)cogito-ergo-soft(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Upgrade to dual processor machine? |
Date: | 2002-11-15 13:37:01 |
Message-ID: | NDBBIFNBODNADCAOFDOAMEEPCEAA.cedric.dufour@cogito-ergo-soft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org]On Behalf Of Andrew
> Sullivan
> Sent: Friday, November 15, 2002 13:59
> To: pgsql-performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] [GENERAL] Upgrade to dual processor machine?
>
>
> On Fri, Nov 15, 2002 at 09:47:23AM +0100, Cedric Dufour (Cogito
> Ergo Soft) wrote:
> > Is there any setting in the conf file that is related to this VACUUM and
> > dead tuples issue ? Could the "free-space map" settings be
> related (I never
> > understood what were these settings) ?
>
> Yes. That's what those settings are.
>
The 'Runtime configuration / General operation' part of the doc is quite
short on the subject.
Is there any other places to look for more details on this FSM ? What policy
should drive changes to the FSM settings ?
I guess allowing larger FSM values might improve UPDATE performance (require
VACUUM less often) but consume RAM that may be more useful elsewhere. Am I
right ?
Has any one made experience on that matter and what conclusion were drawn ?
In other words, shall we try to alter this FSM settings for better
perfomance or is it better to stick to a regular (shortly timed) VACUUM
scenario ?
Cedric
From | Date | Subject | |
---|---|---|---|
Next Message | John Campbell | 2002-11-15 13:48:27 | problems with postgresql passwords on webmin/kylix |
Previous Message | Andrew Sullivan | 2002-11-15 12:59:17 | Re: [GENERAL] Upgrade to dual processor machine? |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2002-11-15 13:37:25 | Re: for/loop performance in plpgsql ? |
Previous Message | Andrew Sullivan | 2002-11-15 12:59:17 | Re: [GENERAL] Upgrade to dual processor machine? |