Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: FSM versus GIN pending list bloat
Date
Msg-id CA+TgmoY6DP1T580zG3ytAt=MVPBz7OC0e0oS5oJ7gfB9Kj3+Rw@mail.gmail.com
Whole thread Raw
In response to Re: FSM versus GIN pending list bloat  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: FSM versus GIN pending list bloat  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
Tree view 
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.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PATCH] SQL function to report log message
Next
From: Robert Haas
Date:
Subject: Re: Proposal: Implement failover on libpq connect level.