Re: pg_upgrade problem with invalid indexes

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pg_upgrade problem with invalid indexes
Дата
Msg-id 20121207040226.GF4299@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: pg_upgrade problem with invalid indexes  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: pg_upgrade problem with invalid indexes
Список pgsql-hackers
Andrew Dunstan wrote:
>
> On 12/06/2012 09:23 PM, Bruce Momjian wrote:

> >As soon as pg_dump stopped dumping the CREATE INDEX, pg_upgrade would
> >stop creating creating it in the new cluster, and not transfer the index
> >files.
>
> So we'll lose the index definition and leave some files behind? This
> sounds a bit messy to say the least.

I find it hard to get excited about this being a real problem.  If the
index has been kept invalid, how come the definition is so valuable?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Phil Sorber
Дата:
Сообщение: Re: [WIP] pg_ping utility
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: Setting visibility map in VACUUM's second phase