PostgreSQL: performance descrease due to index bloatper
- by Henry-Nicolas Tourneur
I'm running a PgSQL 8.1 on a CentOS 4.4 system (not upgradable unfortunately).
There's a Java app running on top of the PgSQL daemon and we got to reindex the database every 2 months or so. Also important: the database isn't growing.
It looks like the bloat is now coming faster than before and this tends to increase.
My config is available here, autovacuum daemon is enabled and running quite often:
pastebin.com/RytNj7dK
You can also find the output of this query wiki.postgresql.org/wiki/Show_database_bloat
3 hours after running reindex: http://pastebin.com/raw.php?i=75fybKyd
72 hours after running reindex: http://pastebin.com/raw.php?i=89VKd7PC
Does anyone have any idea what should I tweak to get rid of that growing bloat?
Thanks for your help
PS: due to antispam prevention system, I had to remove the first 2 http:// prefixes for my two first links.