Re: reindexdb

From: Vick Khera <vivek(at)khera(dot)org>
To: Steve Clark <sclark(at)netwolves(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: reindexdb
Date: 2014-04-29 18:36:59
Message-ID: CALd+dceeJw5kxs_=MBOZ=7URdfAEM2mfogT3ZY=Og3TXm5WVSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 29, 2014 at 10:22 AM, Steve Clark <sclark(at)netwolves(dot)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.

In response to

  • reindexdb at 2014-04-29 14:22:37 from Steve Clark

Browse pgsql-general by date

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