On Sun, Dec 19, 2010 at 1:10 PM, Jim Nasby <j...@nasby.net> wrote:
> On Dec 19, 2010, at 1:10 AM, flyusa2010 fly wrote:
>> Does postgres make an effort to create a file with physically continuous 
>> blocks?
> AFAIK all files are expanded as needed. I don't think there's any flags you 
> can pass to the filesystem to tell it "this file will eventually be 1GB in 
> size". So, we're basically at the mercy of the FS to try and keep things 
> contiguous.

There have been some reports that we would do better on some
filesystems if we extended the file more than a block at a time, as we
do today.  However, AFAIK, no one is pursuing this ATM.

Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to