Re: database speed - Mailing list pgsql-general

From Chris Stokes
Subject Re: database speed
Date
Msg-id 743ADEB2EC690A448790A8A9E5E16721065E46@confucius.melb.basssoftware.com
Whole thread Raw
In response to database speed  ("Chris Stokes" <ChrisS@BassSoftware.com>)
Responses Re: database speed  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
>You should periodically be doing:

>a) VACUUM (at least once a day, probably) and
>b) REINDEX

>Are you doing both of these?  See the docs if you're not familiar with
>them.

>The REINDEX is needed because VACUUM doesn't free up index space in
>some circumstances.  7.4 (currently in late beta) will fix this.

Sorry Doug,

Yes I am doing a vacuum regularly - in fact, when the speed of the DB becomes slower, the vacuum takes longer and
longertoo. 

I have never used the REINDEX

I wondered if it might be a row chaining issue of some sort ?!?

Chris

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: database speed
Next
From: "David Busby"
Date:
Subject: Best Perl Option?