Re: Reindex doesn't eliminate bloat

2018-03-13 Thread Ron Johnson
On 03/13/2018 06:10 PM, Joe Conway wrote: On 03/12/2018 09:16 PM, Ron Johnson wrote: On 03/12/2018 10:48 PM, Nikolay Samokhvalov wrote: Those queries from wiki for table and index bloat estimation are for estimation only. In many cases they show very wrong results. Better (yet not ideal)

Re: Reindex doesn't eliminate bloat

2018-03-13 Thread Joe Conway
On 03/12/2018 09:16 PM, Ron Johnson wrote: > On 03/12/2018 10:48 PM, Nikolay Samokhvalov wrote: >> Those queries from wiki for table and index bloat estimation are for >> estimation only. In many cases they show very wrong results. Better >> (yet not ideal) approach is using pgstattuple extension

Re: Reindex doesn't eliminate bloat

2018-03-12 Thread Ron Johnson
On 03/12/2018 10:48 PM, Nikolay Samokhvalov wrote: On Tue, Mar 13, 2018 at 1:28 AM, Ron Johnson > wrote: On 03/12/2018 05:20 PM, Nikolay Samokhvalov wrote: On Tue, Mar 13, 2018 at 1:05 AM, Ron Johnson

Re: Reindex doesn't eliminate bloat

2018-03-12 Thread Nikolay Samokhvalov
On Tue, Mar 13, 2018 at 1:28 AM, Ron Johnson wrote: > On 03/12/2018 05:20 PM, Nikolay Samokhvalov wrote: > > On Tue, Mar 13, 2018 at 1:05 AM, Ron Johnson > wrote: > >> v8.4.12 >> > > This is *very* old version, not supported by the community for

Re: Reindex doesn't eliminate bloat

2018-03-12 Thread Ron Johnson
On 03/12/2018 05:55 PM, Adrian Klaver wrote: On 03/12/2018 03:05 PM, Ron Johnson wrote: v8.4.12 According to this (https://pastebin.com/TJB32n5M) query, which I thought I got from https://wiki.postgresql.org/wiki/Index_Maintenance, a list of indexes and their bloat is generated. After

Re: Reindex doesn't eliminate bloat

2018-03-12 Thread Adrian Klaver
On 03/12/2018 03:05 PM, Ron Johnson wrote: v8.4.12 According to this (https://pastebin.com/TJB32n5M) query, which I thought I got from https://wiki.postgresql.org/wiki/Index_Maintenance, a list of indexes and their bloat is generated. After reindexing a table with a large amount of reported

Re: Reindex doesn't eliminate bloat

2018-03-12 Thread Ron Johnson
On 03/12/2018 05:20 PM, Nikolay Samokhvalov wrote: On Tue, Mar 13, 2018 at 1:05 AM, Ron Johnson > wrote: v8.4.12 This is *very* old version, not supported by the community for many years. Check https://www.postgresql.org/ to

Re: Reindex doesn't eliminate bloat

2018-03-12 Thread Nikolay Samokhvalov
On Tue, Mar 13, 2018 at 1:05 AM, Ron Johnson wrote: > v8.4.12 > This is *very* old version, not supported by the community for many years. Check https://www.postgresql.org/ to see currently supported versions. You need to upgrade it.

Reindex doesn't eliminate bloat

2018-03-12 Thread Ron Johnson
v8.4.12 According to this (https://pastebin.com/TJB32n5M) query, which I thought I got from https://wiki.postgresql.org/wiki/Index_Maintenance, a list of indexes and their bloat is generated. After reindexing a table with a large amount of reported bloat (column bloat_pct says 29%),