Skip site navigation (1) Skip section navigation (2)

Re: vacuum full & max_fsm_pages question

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Patrick Hatcher" <pathat(at)comcast(dot)net>
Cc: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: vacuum full & max_fsm_pages question
Date: 2004-09-21 17:49:02
Message-ID: 200409211049.02018.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2004-09-21 22:52:06
Subject: 7.4 vs 7.3 ( hash join issue )
Previous:From: Patrick HatcherDate: 2004-09-21 17:45:37
Subject: Re: vacuum full & max_fsm_pages question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group