Postgres Pro
Downloads
Home   >   mailing lists

Re: GIN non-intrusive vacuum of posting tree - Mailing list pgsql-hackers

From Vladimir Borodin
Subject Re: GIN non-intrusive vacuum of posting tree
Date
Msg-id 7B44397E-5E0A-462F-8148-1C444640FA0B@simply.name
Whole thread Raw
In response to GIN non-intrusive vacuum of posting tree  (Andrew Borodin <borodin@octonica.com>)
Responses Re: GIN non-intrusive vacuum of posting tree
List pgsql-hackers
Tree view

28 нояб. 2016 г., в 20:31, Andrew Borodin <borodin@octonica.com> написал(а):

This patch solved a problem encountered by Evgeniy Efimkin and
Vladimir Borodin from Yandex.Mail.

and eventually deleting some of data. This testbed showed VACUUM
holding inserts for up to tenths of seconds. They claim that proposed
patch made vacuum invisible in this test.

Evgeniy, Vladimir, if I missed something or you have something to add,
please join discussion.

Yep, in our load environment the table is not so big (~ 50 GB), GIN index size is ~ 1 GB. And under our load profile we have seen 90 seconds of impossibility to do an insert into the table because of vacuuming this index. I confirm that with this patch we now don’t see any spikes of errors as it was previously.

--
May the force be with you…

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Tackling JsonPath support
Next
From: Fabien COELHO
Date:
Subject: Re: PSQL commands: \quit_if, \quit_unless