Re: Cannot use a standalone backend to VACUUM in "postgres"" - Mailing list pgsql-general

From Manuel Sugawara
Subject Re: Cannot use a standalone backend to VACUUM in "postgres""
Date
Msg-id m3ve2tgjhk.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to Re: Cannot use a standalone backend to VACUUM in "postgres""  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Cannot use a standalone backend to VACUUM in "postgres""  (Manuel Sugawara <masm@fciencias.unam.mx>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: select distinct and index usage
Next
From: "Stephen Denne"
Date:
Subject: Re: select distinct and index usage