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@xxxxxxxxxxx _____________________________________________________________ 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
Attachment:
0x3289338C.asc
Description: application/pgp-keys
Attachment:
signature.asc
Description: OpenPGP digital signature
