Re: [GENERAL] Curious case of huge simple btree indexes bloat.

2015-06-01 Thread Maxim Boguk
On Mon, Jun 1, 2015 at 3:18 AM, Tom Lane wrote: > Maxim Boguk writes: > > On the one of databases under my support I found very curious case of the > > almost endless index bloat (index size stabilises around 100x of the > > original size). > > > The table have 5 indexes and they all have the sa

Re: [GENERAL] Curious case of huge simple btree indexes bloat.

2015-05-31 Thread Tom Lane
Maxim Boguk writes: > On the one of databases under my support I found very curious case of the > almost endless index bloat (index size stabilises around 100x of the > original size). > The table have 5 indexes and they all have the same bloating behaviour > (growth to almost 100x and stabilisat