Re: Clustered index to preserve data locality in a multitenant application?

Поиск
Список
Период
Сортировка
От Nicolas Grilly
Тема Re: Clustered index to preserve data locality in a multitenant application?
Дата
Msg-id CAG3yVS60S+hcap2CT-oCYtH2JYvU_+rrk88DRz=Bar_62LN3bA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Clustered index to preserve data locality in a multitenant application?  (Kenneth Marshall <ktm@rice.edu>)
Ответы Re: Clustered index to preserve data locality in a multitenant application?  (Kenneth Marshall <ktm@rice.edu>)
Список pgsql-general
Дерево обсуждения
On Wed, Aug 31, 2016 at 6:05 PM, Kenneth Marshall <ktm@rice.edu> wrote:
We just run it via cron. In our case, we run it once a day, but depending on
your churn, it could be run once a week or more.

Could you provide some numbers: what is the size of the tables or tables that are repacked? how long does it take? is there a performance impact during the repack?

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

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: Clustered index to preserve data locality in a multitenant application?
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: Clustered index to preserve data locality in a multitenant application?