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 | 20030214205141.GA10493@heat обсуждение исходный текст |
Ответ на | In 7.3.1, will I be able to reindex toast? (Jeffrey Baker <jwbaker@acm.org>) |
Ответы |
Re: In 7.3.1, will I be able to reindex toast?
Re: In 7.3.1, will I be able to reindex toast? |
Список | pgsql-general |
On Fri, Feb 14, 2003 at 09:36:44AM -0800, 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. In partial resposne to my own question, I've found that 7.3.2 will not reindex TOAST tables explicitly: rupert=> reindex table pg_toast_12550267; ERROR: Relation "pg_toast_12550267" does not exist But does it reindex the TOAST tables if I reindex the related table? -jwb
В списке pgsql-general по дате отправления: