Re: Shortening time of vacuum analyze

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Shortening time of vacuum analyze
Дата
Msg-id 20020130154714.J20009@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: Shortening time of vacuum analyze  (Francisco Reyes <lists@natserv.com>)
Ответы Re: Shortening time of vacuum analyze  (Francisco Reyes <lists@natserv.com>)
Список pgsql-general
Дерево обсуждения 
On Wed, Jan 30, 2002 at 12:23:50PM -0500, Francisco Reyes wrote:

> You can put the delete/load inside a transaction so the users will never
> see an empty table. Truncate can not be placed inside a transaction.

True enough.  But why not leave the table unvacuumed, then, until a
more convenient time?  You are, of course, paying a cost in
performance during that time, but not as great as you would with
vacuum.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110

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

Предыдущее
От: "Mitch Vincent"
Дата:
Сообщение: Re: please help me build a business case for using postgresql at my company
Следующее
От: "Bjoern Metzdorf"
Дата:
Сообщение: Re: process exited with status 11 after XLogFlush: request is not satisfied