Re: [HACKERS] Problems with autovacuum and vacuum

2011-01-03 Thread JotaComm
Hello, Filip 2011/1/1 Filip Rembiałkowski > > 2010/12/30 JotaComm > >> Hello, >> >> Last week I had a serious problem with my PostgreSQL database. My >> autovacuum is OFF, but in September it started to prevent the transaction >> wraparoud; however last week the following message appeared conti

Re: [HACKERS] Problems with autovacuum and vacuum

2011-01-01 Thread Filip Rembiałkowski
2010/12/30 JotaComm > Hello, > > Last week I had a serious problem with my PostgreSQL database. My > autovacuum is OFF, but in September it started to prevent the transaction > wraparoud; however last week the following message appeared continuously in > my log: > > WARNING: database "production"

Re: [HACKERS] Problems with autovacuum and vacuum

2010-12-30 Thread Robert Haas
On Thu, Dec 30, 2010 at 12:56 PM, JotaComm wrote: > Last week I had a serious problem with my PostgreSQL database. My autovacuum > is OFF, but in September it started to prevent the transaction wraparoud; > however last week the following message appeared continuously in my log: > > WARNING: datab

[HACKERS] Problems with autovacuum and vacuum

2010-12-30 Thread JotaComm
Hello, Last week I had a serious problem with my PostgreSQL database. My autovacuum is OFF, but in September it started to prevent the transaction wraparoud; however last week the following message appeared continuously in my log: WARNING: database "production" must be vacuumed within 4827083 tra