Re: R: Vacuum full: alternatives?
| От | Scott Mead |
|---|---|
| Тема | Re: R: Vacuum full: alternatives? |
| Дата | |
| Msg-id | CAKq0gvLf7PW_YxDMK+sRfmPOk7mW_z-UpMomcpr1kTbZ7nmmRg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: R: Vacuum full: alternatives? (Andreas Kretschmer <andreas@a-kretschmer.de>) |
| Ответы |
Re: R: Vacuum full: alternatives?
Re: R: Vacuum full: alternatives? Re: R: Vacuum full: alternatives? |
| Список | pgsql-general |
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 notSo new record, when will be pg_bulkloaded, will replace "marked-free" location?
more growing table. There is no need for vacuum full.
exactly, that's the task for vacuum
I believe that free space is only available to UPDATE, not INSERT.
Andreas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: