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

From: Nicolas Grilly <nicolas(at)gardentechno(dot)com>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: Vick Khera <vivek(at)khera(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Clustered index to preserve data locality in a multitenant application?
Date: 2016-08-31 16:06:54
Message-ID: CAG3yVS60S+hcap2CT-oCYtH2JYvU_+rrk88DRz=Bar_62LN3bA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 31, 2016 at 6:05 PM, Kenneth Marshall <ktm(at)rice(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Marshall 2016-08-31 16:22:15 Re: Clustered index to preserve data locality in a multitenant application?
Previous Message Kenneth Marshall 2016-08-31 16:05:20 Re: Clustered index to preserve data locality in a multitenant application?