Re: reindexdb - Mailing list pgsql-general

From Vick Khera
Subject Re: reindexdb
Date
Msg-id CALd+dceeJw5kxs_=MBOZ=7URdfAEM2mfogT3ZY=Og3TXm5WVSw@mail.gmail.com
Whole thread Raw
In response to reindexdb  (Steve Clark <sclark@netwolves.com>)
List pgsql-general
On Tue, Apr 29, 2014 at 10:22 AM, Steve Clark <sclark@netwolves.com> wrote:
> We have a small (2GB) 8.4.20 database. The prior maintainer ran a reindexdb
> twice a day (originally started with 7.3.x). Can anybody see a reason why we
> need to
> continue to do this?

I used to re-index regularly with earlier 6.x and 7.x releases too.
Not quite twice a day, though. I see no reason for it in any current
Pg release.


pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Planned downtime @ Rackspace - 2014-04-29 2100-2200 UTC
Next
From: Dorian Hoxha
Date:
Subject: Re: Altering array(composite-types) without breaking code when inserting them and similar questions