Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum for large periodic deletes - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: autovacuum for large periodic deletes
Date
Msg-id 20060517222445.GJ42612@pervasive.com
Whole thread Raw
In response to Re: autovacuum for large periodic deletes  ("Sriram Dandapani" <sdandapani@counterpane.com>)
List pgsql-admin
Tree view 
On Wed, May 17, 2006 at 03:18:45PM -0700, Sriram Dandapani wrote:
> Looks like partitioning may seem the way to go. I have been hesitant
> about using partitioning as the feature is very new. How do I manage the
> free space map if I do not use partitioning?

Make it very large. Or read the detailed description at
http://lnk.nu/pervasivepostgres.com/9hg.aspx
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-admin by date:

Previous
From: "Sriram Dandapani"
Date:
Subject: Re: autovacuum for large periodic deletes
Next
From: Tom Lane
Date:
Subject: Re: does wal archiving block the current client connection?