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.

BTW, it's worse with btree indexes; they end up non-sequential inside the file 
anyway, so even if the file is contiguous index access may not be.
Jim C. Nasby, Database Architect                   j...@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

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

Reply via email to