Re: Best practice when reindexing in production

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Best practice when reindexing in production
Date: 2013-05-29 17:47:04
Message-ID: 1514687.3ZLd7LDGHi@skynet.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wednesday, May 29, 2013 06:25:21 PM Daniele Varrazzo wrote:
> My solution has been to become pg_repack maintainer. YMMV. Just don't
> expect vacuum to reduce the indexes size: it doesn't.

It's not supposed to. It is supposed to keep them from indefinitely growing,
though, which it does reasonably well at.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniele Varrazzo 2013-05-29 19:22:13 Re: Best practice when reindexing in production
Previous Message Daniele Varrazzo 2013-05-29 17:25:21 Re: Best practice when reindexing in production