Subject: Re: Index bloat? Try pgindexrebuild, a production friendly
 index debloater
To: pgsql-admin@postgresql.org
References: <nqlqfn$f78$1@blaine.gmane.org>
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>
Message-ID: <26693db4-aa1a-4f68-54aa-0401becca334@pro-open.de>
Date: Sun, 11 Sep 2016 21:58:52 +0200
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101
 Thunderbird/45.3.0
MIME-Version: 1.0
In-Reply-To: <nqlqfn$f78$1@blaine.gmane.org>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="MihqewSI8jTpJaxIIKjG08Rs36FA1HRUJ"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--MihqewSI8jTpJaxIIKjG08Rs36FA1HRUJ
Content-Type: multipart/mixed; boundary="NOqjf7D49HH6cM4MR84KHS428LDd0tswK";
 protected-headers="v1"
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>
To: pgsql-admin@postgresql.org
Message-ID: <26693db4-aa1a-4f68-54aa-0401becca334@pro-open.de>
Subject: Re: [ADMIN] Index bloat? Try pgindexrebuild, a production friendly
 index debloater
References: <nqlqfn$f78$1@blaine.gmane.org>
In-Reply-To: <nqlqfn$f78$1@blaine.gmane.org>

--NOqjf7D49HH6cM4MR84KHS428LDd0tswK
Content-Type: multipart/mixed;
 boundary="------------100631D4FEA38F5681A153A4"

This is a multi-part message in MIME format.
--------------100631D4FEA38F5681A153A4
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Am 06.09.2016 um 09:16 schrieb Rory McCann:
> Hello all,

Hi Rory,

>=20
> 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/
>=20
> 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:
>=20
>     https://github.com/rory/pgindexrebuild

Sounds promising.
You might want to post that to -announce as well?

Cheers,
--=20
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


--------------100631D4FEA38F5681A153A4
Content-Type: application/pgp-keys;
 name="0x3289338C.asc"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
 filename="0x3289338C.asc"

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v2

mQENBFOuo7ABCADU3rFM4gBv4l/Xjfry27pfdYgvWrcR1RA/vLfOgjqivSbMQEHH
bTWprJRjB2EbzmTS+faSa/V+mH/jIKBytCc5+hprBd/m5if3/v2PKA7+MHsy1H9T
7FqTKRccNl7RIcKFOaonIbY4qMyH6cFafZOgqaGlc3ibfX7PiCL+mdl1mPoyWeVR
sKoddSobI40noE+se/FrnKZRDRWqqx7zvTRRK9vKUVDFM+Y3Kg3EDL3Qmt3MocM7
FtBZDaeyFZiKdf7bNaWM977aGwiA1gQQp+/TmB1qqSyOTzbPhxfr7G9vWdbVS2ph
80RSrxI/sF3LUNeJtTjB/jtKiG49arBqC1eDABEBAAG0Lkd1bm5hciAiTmljayIg
Qmx1dGggPGd1bm5hci5ibHV0aEBwcm8tb3Blbi5kZT6JAT8EEwECACkFAlOuo7AC
GyMFCQlmAYAHCwkIBwMCAQYVCAIJCgsEFgIDAQIeAQIXgAAKCRAQEK5rMokzjLin
CACaTXqjA7Qc6lpljpz3/5SpmPlvEDdX5mR76jN8326qkSQw7i8WBGW/5NO669OY
4ITlLbu/XL11x6hzCh7ZxMJo3fSYN+fh1tfEnNGw0NjUoy1JdBB+2B3beY+0LEBG
ZMm56HZC1u4qZq2drLM+sZIi6f8ML0NCh41s01SeX6hGQ609zCcFRNNk98pXOBER
a2kDi9wn1UvK1tECxCXuiO6HhPzhme/nFAxoBdBdATCl5EEnnLD+JfhSr2LShgXu
LQxJA6odvggfDVlS913rb0zDtV6s+6bfR+qmD4igBgC6Xl8ceDJpbS4ER7Uvw78n
Sa2i3Yub28FAGr+RvpFLi9PruQENBFOuo7ABCAC6E2x7GZ1LrIQMlNr2XYvCG9DB
p181PJJ95w4BwuaKmFBDHc5tE7p5S2sNfNfYNUjDzpr47lU5+85Ffqtf27gV8Ftd
rqv/d2lbH9+w6wShB9QOy11gPPdkB62o9CKwk+XInN2DJITWsgI8hk6NNzbotD27
x7x4fxQxBUE6YkHnJMziqwZ5emLFP0A2XPIDK6tw87UZNOnEaJ9kP3WOKihNOtMq
mr7+4BQQCyfj13k32219UZglnHtYaGuNmXOc0KHoFEIA2pkgeXRQShrwz4gdCaSN
FUZPAVeeWmdqAmnKKb+Sk7czft/wdtmBD0BykYRoZxQ3JlkHG7oH7wGXmi1TABEB
AAGJASUEGAECAA8FAlOuo7ACGwwFCQlmAYAACgkQEBCuazKJM4xN1wf+MPLXrQ10
LBRtYjD16LsvxDyEcSMoWGc26DO/TDsGwme2NVfL0JufExgdpvkk/x4wzBwdkYfF
dNKU3CyA+3T4FuKGL7RPrICJa+VdCvwMk8dzLqF0UgdfVHtCnUQoQmNnDD7gODw/
GTIKpWw+iEE2/EANAONXj7EC+VsW895/C5aQEZx++cSonrHFSSIUp1OGJoVlmFnJ
MFCTTElmayTcmfOwGHrn97Et5YePMOsyqWZas+URuJveoTdGhDToOIufECGb3WJa
J8rFL+ni3NKoiZhZMYVQ+XC8f64Mi5kXlfsylVu6kgCoFqnq7FTpwqOiRml4APeX
GBC6uZW6fUGNDQ=3D=3D
=3D//tm
-----END PGP PUBLIC KEY BLOCK-----

--------------100631D4FEA38F5681A153A4--

--NOqjf7D49HH6cM4MR84KHS428LDd0tswK--

--MihqewSI8jTpJaxIIKjG08Rs36FA1HRUJ
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQEcBAEBCAAGBQJX1beDAAoJEBAQrmsyiTOMhhAH/1GUTmSUAAxTFrZML19dX2nf
U9RjG/rdVwBXLSUNivCjajMkDaxvLBz8yzkO7DOv1lzTkwrjVm+HsAsSEV+nXV5l
8kSyh7IhpB72de7udME5xso/FaKn1RWRtcZLpKELPMkuy+dlvNbV97X7ADVd/9qy
hUJ+1U7eJf04Wi+PzTZXev+1xypwgZN5EDIvcrSAyYxJskH65X3ysSoinqJnb1m2
gUIJO8F0V6NGy7JtGcBj9Io+dk2+7e2zC6ebJ/eVOqLvyK+NQFlQ5P8AInRqrleN
hytxxhS95BShr2FrSnZ8oFbWFnqXa66Wu+EjjbltlUO1lXcFMLc1csC6Sqra/Ho=
=mWvG
-----END PGP SIGNATURE-----

--MihqewSI8jTpJaxIIKjG08Rs36FA1HRUJ--