Re: db grows and grows

Поиск
Список
Период
Сортировка
От Fran Fabrizio
Тема Re: db grows and grows
Дата
Msg-id 3D11D4CC.7070601@mmrd.com
обсуждение исходный текст
Ответ на Re: db grows and grows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
>
>
>A while ago I did post a script that did this, only it did the create first,
>then the drop and then renamed the new index to the old one. All within a
>transaction so other queries wouldn't be left without an index.
>
>It used pg_dump to get the CREATE INDEX command.
>
>Should be in the archive somewhere...
>
>
Any hints?  I'm not having much luck searching the archives for this
script.

Thanks,
Fran



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how to evaluate a function only once for a query?
Следующее
От: Fran Fabrizio
Дата:
Сообщение: Re: db grows and grows