From: Alexandre Leclerc <aleclerc@ipso.ca>
Cc: pgsql-admin@postgresql.org
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
Date: Fri, 16 Apr 2010 16:57:34 -0400
Message-ID: <4BC8CF3E.7000205@ipso.ca> (raw)
In-Reply-To: <14487.1271448871@sss.pgh.pa.us>
References: <4BC8639C.4010202@ipso.ca>
<9048.1271429162@sss.pgh.pa.us>
<4BC8A623.8090201@ipso.ca>
<4BC8638E0200002500030A01@gw.wicourts.gov>
<4BC8B0CE.2010401@ipso.ca>
<1271444725.21263.80.camel@jd-desktop.unknown.charter.com>
<4BC871F90200002500030A0D@gw.wicourts.gov>
<13971.1271447063@sss.pgh.pa.us>
<4BC8C0D3.70406@ipso.ca>
<14487.1271448871@sss.pgh.pa.us>
Le 2010-04-16 16:14, Tom Lane a écrit :
> Alexandre Leclerc<aleclerc@ipso.ca> writes:
>
>> The vacuum raised a "max_fsm_pages" of 142000 not enought and stopped.
>>
> That's just a warning that gets put out at the end of the run. Go on
> with vacuuming your other databases. Right now is no time to be
> worrying about FSM too small --- you need to get back to a running DB.
>
> regards, tom lane
>
>
Robin, Tom, Kevin,
Thank you guys. I wanted to rush and vacuum the other tables and try,
but I decided to make a copy. This is actually running. (Enough mistakes
in one day to not take the time to do it.)
After that we try to launch the DB and hopefully it will be working good
enough before the next maintenance. Else, a big week-end is coming.
As for restoring the old DB, if we must go there, we will keep a copy
for sure (the copy we are making right now).
Guys, thank you very much! Your help is invaluable.
Best regards,
--
Alexandre Leclerc
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aleclerc@ipso.ca
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
In-Reply-To: <4BC8CF3E.7000205@ipso.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox