Re: [bug fix] Suppress "autovacuum: found orphan temp table" message

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: MauMau <maumau307(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [bug fix] Suppress "autovacuum: found orphan temp table" message
Date: 2014-07-22 09:36:04
Message-ID: 20140722093604.GG4629@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2014-07-22 17:05:22 +0900, MauMau wrote:
> From: "Andres Freund" <andres(at)2ndquadrant(dot)com>
> >On 2014-07-22 10:09:04 +0900, MauMau wrote:
> >>Is there any problem if we don't output the message?
> >
> >Yes. The user won't know that possibly gigabytes worth of diskspace
> >aren't freed.
>
> RemovePgTempFiles() frees the disk space by removing temp relation files at
> server start.

But it's not called during a crash restart.

> In addition, the temp relation files are not replicated to
> the standby server of streaming replication (this is the customer's
> case).

So?

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2014-07-22 09:38:12 Re: WAL replay bugs
Previous Message Kyotaro HORIGUCHI 2014-07-22 09:19:34 Re: Use unique index for longer pathkeys.