Re: FSM versus GIN pending list bloat - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: FSM versus GIN pending list bloat
Date
Msg-id CAD21AoAdvv=1M4fba9_TuJ4LqN-Or44E+fuqo7-7=AAGF7Lgmg@mail.gmail.com
Whole thread Raw
In response to Re: FSM versus GIN pending list bloat  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, Sep 3, 2015 at 3:57 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Mon, Aug 10, 2015 at 1:16 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
>> I have a simple test case that inserts an array of 101 md5 digests into each
>> row.  With 10_000 of these rows inserted into an already indexed table, I
>> get 40MB for the table and 80MB for the index unpatched.  With the patch, I
>> get 7.3 MB for the index.
>
> Uh, wow.  Seems like we should do something about this.
>

I looked into this patch.
The patch is applied cleanly, and complied without error.
I think it works as we expected, but the patch has some unnecessary white space.
Also the today document says that pending list is cleaned up by only
vacuum, we need to document about this?

Regards,

--
Masahiko Sawada



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Potential GIN vacuum bug
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Core dump with nested CREATE TEMP TABLE