Обсуждение: Erro in vaccum

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?