> 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
