Postgres Pro
Downloads
Home   >   mailing lists

Re: How to fast the REINDEX - Mailing list pgsql-performance

From Robert Haas
Subject Re: How to fast the REINDEX
Date
Msg-id k2i603c8f071004050954qa92fde62l3b4352377c6e9c61@mail.gmail.com
Whole thread Raw
In response to Re: How to fast the REINDEX  (raghavendra t <raagavendra.rao@gmail.com>)
List pgsql-performance
Tree view 
On Thu, Apr 1, 2010 at 9:47 AM, raghavendra t <raagavendra.rao@gmail.com> wrote:
> and deletes. We also has the weekly maintance of VACUUM, but still reindex
> takes lot of time.

If you only VACUUM once a week, *everything* is going to take a lot of time.

...Robert

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Huge table searching optimization
Next
From: Oliver Kindernay
Date:
Subject: Re: Huge table searching optimization