| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: optimizing CleanupTempFiles |
| Date: | 2008-09-18 07:19:02 |
| Message-ID: | 48D200E6.8000801@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Simon Riggs wrote:
> On Thu, 2008-09-18 at 09:23 +0300, Heikki Linnakangas wrote:
>> Tom Lane wrote:
>>> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>>>> BTW in testing this patch I was surprised by the fact that temp tables
>>>> files are removed at checkpoint time,
>>> [ blink... ] Doesn't look like that should happen. What is your
>>> test case?
>> Hmph, must be because of the patch from last winter to prevent
>> relfilenode reuse until next checkpoint. Looks like we didn't make an
>> exception for temporary tables. Although it's harmless...
>
> 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.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-09-18 07:48:23 | Re: optimizing CleanupTempFiles |
| Previous Message | Simon Riggs | 2008-09-18 07:01:36 | Re: optimizing CleanupTempFiles |