On Mon, Dec 22, 2008 at 10:22 AM, paulo matadr <[email protected]> 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? -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
