Best way to handle "read only" paritions

Поиск
Список
Период
Сортировка
От Dave Johansen
Тема Best way to handle "read only" paritions
Дата
Msg-id CAAcYxUcZRzfq3RPXEkuRFgqduiRaFA2RgTaHkPBTizZZhmZRwA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Best way to handle "read only" paritions  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-admin
We're using a time-based partitioning scheme for our data and so partitions become "read only" once the time covered by it has passed. We've been CLUSTERing those partitions but here's some questions I have:
Should we set the fill factor of the indexes from the default of 90 to 100?
Should we do anything with xids and freeze age?
Anything else?
Thanks,
Dave

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

Предыдущее
От: Dave Johansen
Дата:
Сообщение: Re: Deadlock when inserting from multiple processes
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Best way to handle "read only" paritions