Re: optimizing CleanupTempFiles - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: optimizing CleanupTempFiles
Date
Msg-id 1221724103.3913.2303.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: optimizing CleanupTempFiles  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: optimizing CleanupTempFiles  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Thu, 2008-09-18 at 10:19 +0300, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > 
> > An unfortunate choice of words! Harmless is not how your average DBA
> > would describe it when their disk fills and they are apparently unable
> > to reduce space consumption. So there is still a problem there even if
> > we fix the temp files portion of it.
> 
> The files *are* truncated to zero bytes immediately. They're left 
> hanging as empty files until next checkpoint.

Ah, cool. So won't actually unlinking temp files be slower than just
leaving them for checkpointer to clear up offline? i.e. do we really
need the patch you just posted?

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: optimizing CleanupTempFiles
Next
From: Simon Riggs
Date:
Subject: Re: [PATCHES] Infrastructure changes for recovery