Re: R: Vacuum full: alternatives?

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: R: Vacuum full: alternatives?
Дата
Msg-id CAECtzeUPuYNTzqdzhprNoOn1aY+QHdak21=p9CJouXuUnczEmQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: R: Vacuum full: alternatives?  (Scott Mead <scottm@openscg.com>)
Список pgsql-general
2016-06-20 17:03 GMT+02:00 Scott Mead <scottm@openscg.com>:


On Mon, Jun 20, 2016 at 6:13 AM, Andreas Kretschmer <andreas@a-kretschmer.de> wrote:


Am 20.06.2016 um 11:43 schrieb Job:
Hi Andreas,

I would suggest run only autovacuum, and with time you will see a not
more growing table. There is no need for vacuum full.
So new record, when will be pg_bulkloaded, will replace "marked-free" location?


exactly, that's the task for vacuum


I believe that free space is only available to UPDATE, not INSERT.


No, it's available for both.


--

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: R: Vacuum full: alternatives?
Следующее
От: Martín Marqués
Дата:
Сообщение: Re: R: Vacuum full: alternatives?