Re: Improving REINDEX for system indexes (long)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Improving REINDEX for system indexes (long)
Дата
Msg-id 200309280018.h8S0I7U26535@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Improving REINDEX for system indexes (long)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Improving REINDEX for system indexes (long)  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-hackers
Tom Lane wrote:
> > What about creating a separate filenode anyway and renaming the files
> > afterwards?  It would not be an atomic operation anyway, but it would be
> > better than the current setup IMHO.
> 
> I think it would be difficult to persuade the buffer manager and storage
> manager to work with this; from their point of view you'd be moving a
> relation underneath them.  I doubt it's really worth the trouble; how
> often do you need to reindex a shared catalog?

The point I missed originally is that he is talking about shared
catalogs, not system catalogs, which work fine in CVS.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Improving REINDEX for system indexes (long)
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: old pgindent change