Re: In 7.3.1, will I be able to reindex toast?
От | Jeffrey Baker |
---|---|
Тема | Re: In 7.3.1, will I be able to reindex toast? |
Дата | |
Msg-id | 20030214214704.GA12980@heat обсуждение исходный текст |
Ответ на | Re: In 7.3.1, will I be able to reindex toast? (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: