Tom,
> Let's go with the easy fix. With regular 1GB segment size, having a few
> empty files in the data directory isn't going to hurt anyone.
No, but it will confuse DBAs ("What the heck are all these 0B files?"). Maybe
we should add code to VACUUM to look for these empty file segments and unlink
them if they haven't been touched in a while (say, a day?).
--
Josh Berkus
PostgreSQL @ Sun
San Francisco