In 7.3.1, will I be able to reindex toast?

From: Jeffrey Baker <jwbaker(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: In 7.3.1, will I be able to reindex toast?
Date: 2003-02-14 17:36:44
Message-ID: 20030214173644.GA31135@heat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am considering moving to 7.3 from 7.2. I have the
obnoxious toast index growth problem of doom. In 7.2 I am
not allowed to reindex toast tables, because they are of
type 't'. How smug :)

The problem is I don't want to move to 7.3 unless I can be
certain this is going to work. There are many incompatible
changes in 7.3, and I will need to audit tens of thousands
of lines of queries before I can make the move. Can someone
reassure me? It says you can reindex toast tables in the
changelog, but ...

Also I assume REINDEX in 7.3 still requires exclusive
access? That could be a bummer.

-jwb

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2003-02-14 17:38:54 Re: Postgres Databases growing without much reason
Previous Message Dennis Gearon 2003-02-14 17:35:04 Re: 'Universal' schedule table defintion