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?