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)
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
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
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
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
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
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
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.
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%),