Re: Preventing free space from being reused

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Preventing free space from being reused
Дата
Msg-id CAHOFxGq+jDKCZHJOnDpaTOUAti15Ue5TGj6mA=d1MDGpDR6TDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Preventing free space from being reused  (Noah Bergbauer <noah@statshelix.com>)
Ответы Re: Preventing free space from being reused  (Noah Bergbauer <noah@statshelix.com>)
Список pgsql-general
If you have no updates or deletes, then I would wonder about setting fillfactor LOWER such that new rows are less likely to find a gap that is acceptable. Depending how/when you use the json, lowering toast_tuple_target may be appropriate to store (nearly?) all out of line and making the data stored in the main relation be more uniform in size. Are you seeing significant toast usage currently?

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

Предыдущее
От: Noah Bergbauer
Дата:
Сообщение: Re: Preventing free space from being reused
Следующее
От: Noah Bergbauer
Дата:
Сообщение: Re: Preventing free space from being reused