Re: [GENERAL] bloat indexes - opinion

2017-02-24 Thread Patrick B
2017-02-25 17:53 GMT+13:00 Patrick B : > > > 2017-02-23 11:46 GMT+13:00 Jeff Janes : > >> On Tue, Feb 21, 2017 at 1:44 PM, Patrick B >> wrote: >> >>> Hi guys, >>> >>> I've got a lot of bloat indexes on my 4TB database. >>> >>> Let's take this example: >>> >>> Table: seg >>> Index: ix_filter_by_tr

Re: [GENERAL] bloat indexes - opinion

2017-02-24 Thread Patrick B
2017-02-23 11:46 GMT+13:00 Jeff Janes : > On Tue, Feb 21, 2017 at 1:44 PM, Patrick B > wrote: > >> Hi guys, >> >> I've got a lot of bloat indexes on my 4TB database. >> >> Let's take this example: >> >> Table: seg >> Index: ix_filter_by_tree >> Times_used: 1018082183 >> Table_size: 18 GB -- wrong

Re: [GENERAL] bloat indexes - opinion

2017-02-24 Thread Patrick B
2017-02-22 13:10 GMT+13:00 Adrian Klaver : > On 02/21/2017 03:41 PM, Patrick B wrote: > > 2017-02-22 11:11 GMT+13:00 Patrick B > >: > > > > 2017-02-22 10:59 GMT+13:00 Adrian Klaver > >: > > > > On 02/21/2017 01:44

Re: [GENERAL] bloat indexes - opinion

2017-02-22 Thread Jeff Janes
On Tue, Feb 21, 2017 at 1:44 PM, Patrick B wrote: > Hi guys, > > I've got a lot of bloat indexes on my 4TB database. > > Let's take this example: > > Table: seg > Index: ix_filter_by_tree > Times_used: 1018082183 > Table_size: 18 GB -- wrong. The table is mostly on pg_toast table. Its > real size

Re: [GENERAL] bloat indexes - opinion

2017-02-21 Thread Adrian Klaver
On 02/21/2017 03:41 PM, Patrick B wrote: > 2017-02-22 11:11 GMT+13:00 Patrick B >: > > 2017-02-22 10:59 GMT+13:00 Adrian Klaver >: > > On 02/21/2017 01:44 PM, Patrick B wrote: > > Hi guys, > > >

Re: [GENERAL] bloat indexes - opinion

2017-02-21 Thread Patrick B
2017-02-22 11:11 GMT+13:00 Patrick B : > 2017-02-22 10:59 GMT+13:00 Adrian Klaver : > >> On 02/21/2017 01:44 PM, Patrick B wrote: >> > Hi guys, >> > >> > I've got a lot of bloat indexes on my 4TB database. >> > >> > Let's take this example: >> > >> > Table: seg >> > Index: ix_filter_by_tre

Re: [GENERAL] bloat indexes - opinion

2017-02-21 Thread Patrick B
2017-02-22 10:59 GMT+13:00 Adrian Klaver : > On 02/21/2017 01:44 PM, Patrick B wrote: > > Hi guys, > > > > I've got a lot of bloat indexes on my 4TB database. > > > > Let's take this example: > > > > Table: seg > > Index: ix_filter_by_tree > > Times_used: 1018082183 > > Table_size:

Re: [GENERAL] bloat indexes - opinion

2017-02-21 Thread Adrian Klaver
On 02/21/2017 01:44 PM, Patrick B wrote: > Hi guys, > > I've got a lot of bloat indexes on my 4TB database. > > Let's take this example: > > Table: seg > Index: ix_filter_by_tree > Times_used: 1018082183 > Table_size: 18 GB -- wrong. The table is mostly on pg_toast table. > I

[GENERAL] bloat indexes - opinion

2017-02-21 Thread Patrick B
Hi guys, I've got a lot of bloat indexes on my 4TB database. Let's take this example: Table: seg Index: ix_filter_by_tree Times_used: 1018082183 Table_size: 18 GB -- wrong. The table is mostly on pg_toast table. Its real size is 2TB Index_size: 17 GB Num_writes 16245023 Index definition: CREATE