Re: Erro in vaccum - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Erro in vaccum
Date
Msg-id dcc563d10812221005k54ac3e08s626b487eeb0a4fd6@mail.gmail.com
Whole thread Raw
In response to Erro in vaccum  (paulo matadr <saddoness@yahoo.com.br>)
List pgsql-general
On Mon, Dec 22, 2008 at 10:22 AM, paulo matadr <saddoness@yahoo.com.br> wrote:
>
> My vacuum was follow error below:
> WARNING:  oldest xmin is far in the past
> HINT:  Close open transactions soon to avoid wraparound problems.
> No have   transactions in locked ,

Transactions don't have to hold locks to cause problems.  Generally
speaking you've got an old transaction being held open.  what does:

select min(xact_start) from pg_stat_activity;

say?

pgsql-general by date:

Previous
From: Sebastian Tennant
Date:
Subject: Re: Ordering returned rows according to a list
Next
From: "Shane Wright"
Date:
Subject: Using the wrong index (very suboptimal), why?