On Tue, Nov 08, 2005 at 03:36:40PM -0500, Tom Lane wrote:
> Marc Cousin <[EMAIL PROTECTED]> writes:
> > If a cluster is restarted, is the fsm forgotten ?
>
> Given a normal postmaster shutdown, no. In a crash-restart situation,
> yes.
Does that include restarts due to things like failed asserts
Marc Cousin <[EMAIL PROTECTED]> writes:
> If a cluster is restarted, is the fsm forgotten ?
Given a normal postmaster shutdown, no. In a crash-restart situation,
yes.
regards, tom lane
---(end of broadcast)---
TIP 1: if pos
As we're talking about fsm, I've got a question I've been asking myself for
some time :
If a cluster is restarted, is the fsm forgotten ? (so does it mean one should
run a vacuum as soon as the database is restarted ?)
Le Dimanche 06 Novembre 2005 03:44, Carlos Oliva a écrit :
> Should I set the
t: Monday, November 07, 2005 2:38 PM
> To: Carlos Oliva
> Cc: 'Tom Lane'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Setting max_fsm_pages
>
> On Sun, Nov 06, 2005 at 08:05:29PM -0500, Carlos Oliva wrote:
> > Thank you for your response Tom.
> >
&
)?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby
Sent: Monday, November 07, 2005 2:38 PM
To: Carlos Oliva
Cc: 'Tom Lane'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting max_fsm_pages
On Sun, Nov 06, 2005 at 08:05:29PM -0500, Ca
On Sun, Nov 06, 2005 at 08:05:29PM -0500, Carlos Oliva wrote:
> Thank you for your response Tom.
>
> Should I set the max_fsm_pages to the "total pages needed" obtained from a
> full vacuum or from a analize vacuum? When I run a vacuum analyze (vacuumdb
> -z -v), I get a smaller number of pages n
b -f -z -v)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Saturday, November 05, 2005 10:23 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setting max_fsm_pages
"Carlos Oliva" <[EMAIL PROTECTED]>
"Carlos Oliva" <[EMAIL PROTECTED]> writes:
> Should I set the max_fsm_pages to the value reported (vacuum verbose) as
> pages stored or the value reported as total pages needed?
Total pages needed ... if not more.
regards, tom lane
---(end of broad
Should I set the max_fsm_pages to the value reported (vacuum
verbose) as pages stored or the value reported as total pages needed? I
ran full + analyze vacuums in my database (vacuumdb –f –z –v ) a couple of times and I got the following reports:
INFO: free space map: 454 relations,
2227
