I know upgrading postgres will resolve the problem permanently . But I wanted some workaround for now before I actually upgrade. But let me know if I really need to execute `vacuum freeze` In the scenario given in my previous update or I can skip this step. For your reference I am again updating the scenario : Autovacuum is getting invoked after every 5 mins and vacuums all the database turn by turn and every database is getting its turn of autovaccum after every 20 mins as there are 4 databases (template0 , template1, postgres and abc(my database) ). Now suppose , this autovacuum problem occurs and through some script its detected immediately at the very onset of the problem and below mentioned workaround steps are executed 1. Stop postgres 2. create 256K zero filled 0C01 file in /var/lib/pgsql/data/pg_clog folder. 3. Start postgres Then still , do I need to execute 'vacuum freeze' on all databases ?? Because, my databases were already getting autovacuumed properly before the problem , the problem was resolved as soon as it occurred within let say 2 mins and after the problem is resolved by workaround steps, then autovacuum will start vacuuming all the 4 databases every 20 mins as I mentioned above. Please confirm ... -----Original Message----- From: David Fetter [mailto:david@xxxxxxxxxx] Sent: Wednesday, September 15, 2010 3:27 AM To: tamanna madaan Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: workaround steps for autovaccum problem On Wed, Sep 15, 2010 at 02:39:26AM +0530, tamanna madaan wrote: > Hi All > > > > I am using postgres-8.1.2. I am getting the following error while > autovacuum. Please upgrade your software to PostgreSQL 8.1.21 and try again. Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
