Postgres Pro
Downloads
Home   >   mailing lists

Re: Large table performance and vacuum - Mailing list pgsql-general

From Tom Lane
Subject Re: Large table performance and vacuum
Date
Msg-id 12133.1078527981@sss.pgh.pa.us
Whole thread Raw
In response to Re: Large table performance and vacuum  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
Tree view 
Mike Mascari <mascarm@mascari.com> writes:
> Assuming a "normal" usage pattern, regular VACUUMing, and no
> instances of corrupted indexes, are there any scenarios in which one
> would need to REINDEX either user or system tables post 7.4?

Ideally not, but we'll have to wait for more field experience before we
really know whether the existing fix covers all "normal" usage patterns.

            regards, tom lane

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: Large table performance and vacuum
Next
From: David Garamond
Date:
Subject: Re: relocatable binary distribution