Re: Clearing rows periodically

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   |
+------------------------------+---------------------------------------------+