Postgres Pro
Downloads
Home   >   mailing lists

Re: Clustered index to preserve data locality in a multitenant application? - Mailing list pgsql-general

From Nicolas Grilly
Subject Re: Clustered index to preserve data locality in a multitenant application?
Date
Msg-id CAG3yVS60S+hcap2CT-oCYtH2JYvU_+rrk88DRz=Bar_62LN3bA@mail.gmail.com
Whole thread Raw
In response to Re: Clustered index to preserve data locality in a multitenant application?  (Kenneth Marshall <ktm@rice.edu>)
Responses Re: Clustered index to preserve data locality in a multitenant application?  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-general
Tree view
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 by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Clustered index to preserve data locality in a multitenant application?
Next
From: Kenneth Marshall
Date:
Subject: Re: Clustered index to preserve data locality in a multitenant application?