Re: vacuum full & max_fsm_pages question - Mailing list pgsql-performance

From Josh Berkus
Subject Re: vacuum full & max_fsm_pages question
Date
Msg-id 200409211049.02018.josh@agliodbs.com
Whole thread Raw
In response to Re: vacuum full & max_fsm_pages question  ("Patrick Hatcher" <pathat@comcast.net>)
Responses Re: vacuum full & max_fsm_pages question
Re: vacuum full & max_fsm_pages question
List pgsql-performance
Patrick,

> Sorry.  I wrote PG 7.4.2 and then I erased it to write something else and
> then forgot to add it back.

Odd.  You shouldn't be having to re-vacuum on 7.4.

> And thanks for the Page info.  I was getting frustrated and looked in the
> wrong place.
>
> So it's probably best to drop and readd the indexes then?

Well, I have to wonder if you've not run afoul of the known 7.4.2 bug
regarding indexes.   This system hasn't had an improper database shutdown or
power-out in the last few weeks, has it?

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Re: vacuum full & max_fsm_pages question
Next
From: Patrick Hatcher
Date:
Subject: Re: vacuum full & max_fsm_pages question