Re: Nasty VACUUM/bgwriter/segmentation bug - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Nasty VACUUM/bgwriter/segmentation bug
Date
Msg-id 200611191128.14845.josh@agliodbs.com
Whole thread Raw
In response to Re: Nasty VACUUM/bgwriter/segmentation bug  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: Nasty VACUUM/bgwriter/segmentation bug  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: Nasty VACUUM/bgwriter/segmentation bug
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Nasty VACUUM/bgwriter/segmentation bug