Re: Cannot use a standalone backend to VACUUM in "postgres""

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot use a standalone backend to VACUUM in "postgres""
Date: 2008-04-08 02:37:11
Message-ID: m3ve2tgjhk.fsf@conexa.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:

> Hi Manuel,

Hi Alvaro!

> I suggest you look for temp tables that have not been reclaimed.
> We've had a couple of reports where leftover temp tables have
> stopped the frozen-xid counter from advancing. (They would have a
> very old relfrozenxid.)

Thank you very much for the suggestion. Any pointers on how to do
that? A quick serch in google didn't show anything relevant.

Regards,
Manuel.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Denne 2008-04-08 02:43:37 Re: select distinct and index usage
Previous Message Tom Lane 2008-04-08 02:30:31 Re: select distinct and index usage