Re: [HACKERS] bgwriter holds onto file handles of deleted files

2012-01-08 Thread Simon Riggs
On Sat, Jan 7, 2012 at 7:19 PM, Jeff Janes wrote: > I don't know if this is a bug exactly, but it seems pretty unfortunate. I'll call it a bug and I think it's mine. I've added it to the list of open items for 9.2 Thanks for testing. --  Simon Riggs   http://www.2ndQuadrant.co

Re: [HACKERS] bgwriter holds onto file handles of deleted files

2012-01-08 Thread Jeff Janes
On 1/8/12, Alex Shulgin wrote: > > Jeff Janes writes: > >> It looks like it hold the file handles until either is it is killed >> and restarted, or until they get flushed out of vfd cache (which holds >> ~1000 files on my machine, so that can be a long time and lot of disk >> space). >> >> I don'

[HACKERS] bgwriter holds onto file handles of deleted files

2012-01-07 Thread Jeff Janes
On an overnight test run, I ran into an unexpected "out of space" condition. The writer process was holding on to dozens of file descriptors for long-ago deleted files from dropped tables and indexes, preventing their disk space from being freed for reuse. I think the checkpoint writer process le