Re: Btree Index on PostgreSQL and Wiredtiger (MongoDB3.2)

From: Lukas Fittl <lukas(at)fittl(dot)com>
To: kskim(at)bitnine(dot)net
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Btree Index on PostgreSQL and Wiredtiger (MongoDB3.2)
Date: 2016-08-11 01:47:39
Message-ID: CAP53Pky-a5i1yB6QZ=so6zi1d=anPMeeO3mF1UCm5NShm-cWDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Aug 10, 2016 at 4:24 PM, Kisung Kim <kskim(at)bitnine(dot)net> wrote:
>
> When I used the index bloating estimation script in
> https://github.com/ioguix/pgsql-bloat-estimation,
> the result is as follows:
>

Regardless of the issue at hand, it might make sense to verify these
statistics using pgstattuple - those bloat estimation queries can be wildly
off at times.

See also https://www.postgresql.org/docs/9.5/static/pgstattuple.html as
well as https://www.keithf4.com/checking-for-postgresql-bloat/

Best,
Lukas

--
Lukas Fittl

Skype: lfittl
Phone: +1 415 321 0630

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-08-11 02:19:51 Re: new pgindent run before branch?
Previous Message Peter Eisentraut 2016-08-11 01:36:55 Re: Set log_line_prefix and application name in test drivers