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 CAG3yVS7jn6qhBL0iwroiqW3MPx1=nE3tL8Di=V5tt8N8qt2tsA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Clustered index to preserve data locality in a multitenant application?  (Ben Chobot <bench@silentmedia.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Sep 1, 2016 at 12:05 AM, Ben Chobot <bench@silentmedia.com> wrote:
If what they did 3 years ago is similar to what you are trying to do today, who cares what they are doing today? (Besides using pg_repack instead of pg_reorg, of course.)

I'm curious because, in the meantime, Instagram could have stopped doing this because 1) it didn't work as intended or 2) they found a better solution.
 
For what it's worth, we use pg_repack on a regular basis and it works exactly as advertised.

Thanks.

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

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