Re: FSM versus GIN pending list bloat

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: FSM versus GIN pending list bloat
Дата
Msg-id CAD21AoAdvv=1M4fba9_TuJ4LqN-Or44E+fuqo7-7=AAGF7Lgmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: FSM versus GIN pending list bloat  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Potential GIN vacuum bug
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fwd: Core dump with nested CREATE TEMP TABLE