On Fri, Feb 14, 2003 at 04:35:33PM -0500, Bruce Momjian wrote:
> Jeffrey Baker wrote:
> > 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.
>
> Well, I am sure whoever applied the patch, Tom, tested it:
>
> revision 1.85
> date: 2002/08/29 15:56:20; author: tgl; state: Exp; lines: +15 -17
> Cause REINDEX to regard TOAST tables as regular relations, not system
> tables that need special defenses. I believe this is okay even for
> TOAST tables that belong to system tables.
>
> If you want to be sure, install 7.3 on a different port and test it.
I have installed and tested it, and it doesn't work, which
is why I have posed my question:
jwb@heat:~$ psql rupert
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
rupert=> reindex table pg_toast_12550267;
ERROR: Relation "pg_toast_12550267" does not exist
rupert=> select relname, relkind, relfilenode, reltoastidxid from pg_class where relname = 'pg_toast_12550267';
relname | relkind | relfilenode | reltoastidxid
-------------------+---------+-------------+---------------
pg_toast_12550267 | t | 12550269 | 12550271
(1 row)
So, the TOAST exists but I can't REINDEX it, despite Changelog entries.
-jwb
