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

От

Nicolas Grilly

Тема

Дата

31 августа 2016 г. в 21:56:08

Msg-id

CAG3yVS5zM97YdwMK5y7NU-vYATnrx89DAQg5kR=sPzV1CmRTog@mail.gmail.com

обсуждение

Ответ на

Re: Clustered index to preserve data locality in a multitenant application? (Kenneth Marshall)

Список

pgsql-general

Дерево обсуждения

Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@vocationcity.com> 30 августа 2016 г. в 16:53:24

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 31 августа 2016 г. в 15:41:16

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@vocationcity.com> 31 августа 2016 г. в 15:33:43

Re: Clustered index to preserve data locality in a multitenant application? Eduardo Morras <emorrasg@yahoo.es> 1 сентября 2016 г. в 20:51:06

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@vocationcity.com> 6 сентября 2016 г. в 16:21:54

Re: Clustered index to preserve data locality in a multitenant application? Jim Nasby <Jim.Nasby@BlueTreble.com> 7 сентября 2016 г. в 23:11:40

Re: Clustered index to preserve data locality in a multitenant application? Vick Khera <vivek@khera.org> 30 августа 2016 г. в 17:26:39

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 30 августа 2016 г. в 17:52:21

Re: Clustered index to preserve data locality in a multitenant application? Kenneth Marshall <ktm@rice.edu> 30 августа 2016 г. в 18:17:13

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 31 августа 2016 г. в 22:32:11

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 31 августа 2016 г. в 22:53:01

Re: Clustered index to preserve data locality in a multitenant application? Igor Neyman <ineyman@perceptron.com> 1 сентября 2016 г. в 13:08:33

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 2 сентября 2016 г. в 15:18:49

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 31 августа 2016 г. в 21:56:08

Re: Clustered index to preserve data locality in a multitenant application? Ben Chobot <bench@silentmedia.com> 31 августа 2016 г. в 22:05:29

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 31 августа 2016 г. в 22:26:04

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 31 августа 2016 г. в 15:24:12

Re: Clustered index to preserve data locality in a multitenant application? Kenneth Marshall <ktm@rice.edu> 31 августа 2016 г. в 16:05:28

Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly <nicolas@gardentechno.com> 31 августа 2016 г. в 16:07:18

Re: Clustered index to preserve data locality in a multitenant application? Kenneth Marshall <ktm@rice.edu> 31 августа 2016 г. в 16:22:28

On Tue, Aug 30, 2016 at 8:17 PM, Kenneth Marshall <ktm@rice.edu> wrote:

We have been using the extension pg_repack to keep a table groomed into
cluster order. With an appropriate FILLFACTOR to keep updates on the same
page, it works well. The issue is that it needs space to rebuild the new
index/table. If you have that, it works well.

It looks like Instagram has been using pg_reorg (the ancestor of pg_repack) to keep all likes from the same user contiguous on disk, in order to minimize disk seeks.

http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from

This is very similar to what I'm trying to achieve.

The article is 3 years old. I'd be curious to know if they still do that.

Nicolas

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

Предыдущее

От: Kenneth Marshall

Дата: 31 августа 2016 г. в 16:22:28

Сообщение: Re: Clustered index to preserve data locality in a multitenant application?

Следующее

От: Ben Chobot

Дата: 31 августа 2016 г. в 22:05:29

Сообщение: Re: Clustered index to preserve data locality in a multitenant application?