From: Gunnar \"Nick\" Bluth <gunnar.bluth@pro-open.de>
To: pgsql-admin@postgresql.org
Subject: Re: Index bloat? Try pgindexrebuild, a production friendly index debloater
Date: Sun, 11 Sep 2016 21:58:52 +0200
Message-ID: <26693db4-aa1a-4f68-54aa-0401becca334@pro-open.de> (raw)
In-Reply-To: <nqlqfn$f78$1@blaine.gmane.org>
References: <nqlqfn$f78$1@blaine.gmane.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Am 06.09.2016 um 09:16 schrieb Rory McCann:
> Hello all,
Hi Rory,
>
> If you use/update a PostgreSQL server for a long time,
> one problem you may come across is index bloat. Your database will grow
> in size on your disk, your indexes getting larger on disk. It's no fun
> when your database fills up the disk and won't start anymore. I've had
> this problem when using Nominatim, an open source address geocoder for
> OpenStreetMap/
>
> There are several solutions to this, but I wanted a way to fix index
> bloat while still being able to use the database as a production
> database, so I wrote pgindexrebuild:
>
> https://github.com/rory/pgindexrebuild
Sounds promising.
You might want to post that to -announce as well?
Cheers,
--
Gunnar "Nick" Bluth
RHCE/SCLA
Mobil +49 172 8853339
Email: gunnar.bluth@pro-open.de
_____________________________________________________________
In 1984 mainstream users were choosing VMS over UNIX.
Ten years later they are choosing Windows over UNIX.
What part of that message aren't you getting? - Tom Payne
Attachments:
0x3289338C.asc (application/pgp-keys, 1.7K) download
signature.asc (application/pgp-signature, 472B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gunnar.bluth@pro-open.de
Subject: Re: Index bloat? Try pgindexrebuild, a production friendly index debloater
In-Reply-To: <26693db4-aa1a-4f68-54aa-0401becca334@pro-open.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox