Skip site navigation (1) Skip section navigation (2)

Re: query performance

From: Brian Cox <brian(dot)cox(at)ca(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: query performance
Date: 2008-04-24 23:59:24
Message-ID: 48111EDC.9070900@ca.com (view raw or flat)
Thread:
Lists: pgsql-general
Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)us] wrote:
> I suspect that your FSM settings are too low, causing free space found
> by VACUUM to be forgotten about.

I read in another thread that vacuum verbose would tell me how much FSM 
is needed, but I ran it and didn't see any output about this. What is 
the way to determine how much FSM is needed (other than wait for hints 
in the log).

   You might also need to consider
> vacuuming more than once a day (there's a tradeoff between how often
> you vacuum and how much FSM space you need).

What is the trade-off? Anyway to predict how much more (presumably) FSM 
is needed if you vacuum more often?

Thanks,
Brian

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2008-04-25 00:12:36
Subject: Re: query performance
Previous:From: Scott MarloweDate: 2008-04-24 22:43:11
Subject: Re: query question really cant give a summary here so read the body ;-)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group