Re: routine reindexing in 7.4.6/8.0?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: routine reindexing in 7.4.6/8.0?
Date: 2004-11-02 02:55:14
Message-ID: 4186F712.8000108@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ed L. wrote:

>What is the conventional wisdom about routine reindexing with 7.4.6 and 8.0?
>Is it still considered an important maintenance task? If so, how
>frequently is it needed?
>
>

7.4 at least handles a lot of the reindex issues at vacuum time.
I assume 8 does the same.

Sincerely,

Joshua D. Drake

>Ed
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 285 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jks 2004-11-02 03:24:48 Re: deadlock with vacuum full on 7.4.5
Previous Message Ed L. 2004-11-02 02:18:21 routine reindexing in 7.4.6/8.0?