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

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

2015-05-30 Thread Maxim Boguk
Hi, 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). Graph of one index size history attached (other indexes have an similar time/size graphs). The table have 5 indexes and they all have