Re: Automatic free space map filling - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Automatic free space map filling
Date
Msg-id 20060304021152.GZ82012@pervasive.com
Whole thread Raw
In response to Re: Automatic free space map filling  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Automatic free space map filling
List pgsql-hackers
On Thu, Mar 02, 2006 at 03:19:46PM +0100, Martijn van Oosterhout wrote:
> Note, for this purpose you don't need to keep a bit per page. The
> OS I/O system will load 64k+ (8+ pages) in one go so one bit per 8
> pages would be sufficient.

AFAIK that's entirely dependant on the filesystem and how it's created
(and possibly the OS as well). So arbitrarily deciding each bit is 8
pages is a bad idea. I could see allowing for a setting that determins
how many pages per bit, though, but I think we're also getting ahead of
ourselves.
-- 
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-hackers by date:

Previous
From: Ned Lilly
Date:
Subject: Re: PostgreSQL Anniversary Summit, Call for
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Automatic free space map filling