Re: Index bloat? Try pgindexrebuild, a production friendly index debloater

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(dot)bluth(at)pro-open(dot)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