Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions

2014-07-07 Thread Alvaro Herrera
Prabhjot Sheena wrote: > While the vacuumdb --analyze command is running i m getting these messages > for these tables which might require full vacuum. > > WARNING: relation "public.result" contains more than "max_fsm_pages" pages > with useful free space > HINT: Consider using VACUUM FULL on th

Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions

2014-07-07 Thread Prabhjot Sheena
While the vacuumdb --analyze command is running i m getting these messages for these tables which might require full vacuum. WARNING: relation "public.result" contains more than "max_fsm_pages" pages with useful free space HINT: Consider using VACUUM FULL on this relation or increasing the confi

Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions

2014-07-07 Thread Alvaro Herrera
Prabhjot Sheena wrote: > Hello >We are using postgresql 8.3 database for last 5 yrs for this > production database and its running fine. This is our critical database > which runs 24*7. This weekend we started getting these messages > > HINT: To avoid a database shutdown, execute a full-d

Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions

2014-07-07 Thread Mike Christensen
Sounds like you just have to wait until it finishes.. On Mon, Jul 7, 2014 at 12:56 PM, Prabhjot Sheena < prabhjot.she...@rivalwatch.com> wrote: > Hello >We are using postgresql 8.3 database for last 5 yrs for this > production database and its running fine. This is our critical database