Re: Clearing rows periodically - Mailing list pgsql-performance

From Paul Thomas
Subject Re: Clearing rows periodically
Date
Msg-id 20030718084215.A14240@bacon
Whole thread Raw
In response to Clearing rows periodically  (Martin Foster <martin@ethereal-realms.org>)
List pgsql-performance
On 18/07/2003 07:55 Martin Foster wrote:
> [snip]
> A VACUUM FULL will correct the issue, but put the site out of commission
> for roughly 20 minutes as the drive crunches the information.
>
> My question is, should the purging of rows be done more often then once
> a day for both tables.   Is this why performance seems to take a hit
> specifically?  As there were too many rows purged for vacuum to
> accurately keep track of?

ISTR that there are setting in postgresql.conf which affect how many
tables/rows vacuum can reclaim. The docs say that the default setting of
max_fsm_pages is 10000. Maybe this should be increased for your situation?

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-performance by date:

Previous
From: Ang Chin Han
Date:
Subject: Re: Sanity check requested
Next
From: Ron Johnson
Date:
Subject: Re: Hardware performance