> Could you explain how postgresql can "fall victim" the filesystem hole
> mechanism? Just hoping to force actual storage allocation, or hoping
> to discourage fragmentation?
Most Unix filesystems will not allocate disk blocks until you write in
them. If you just seek out past end-of-file, the file pointer is moved
but the blocks are unallocated. This is how 'ls' can show a 1gb file
that only uses 4k of disk space.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026