Re: Best practice when reindexing in production - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: Best practice when reindexing in production
Date
Msg-id 1514687.3ZLd7LDGHi@skynet.simkin.ca
Whole thread Raw
In response to Re: Best practice when reindexing in production  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Responses Re: Best practice when reindexing in production  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
List 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.


pgsql-performance by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: Best practice when reindexing in production
Next
From: Daniele Varrazzo
Date:
Subject: Re: Best practice when reindexing in production