From: | Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> |
---|---|
To: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Shubham Barai <shubhambaraiss(at)gmail(dot)com>, Dmitry Ivanov <d(dot)ivanov(at)postgrespro(dot)ru> |
Subject: | Re: GIN predicate locking slows down valgrind isolationtests tremendously |
Date: | 2018-12-27 16:58:30 |
Message-ID: | 8b7d8d40-a341-7364-f293-28ba0fb5f291@2ndQuadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 12/24/18 5:47 PM, Andrew Dunstan wrote:
> On 12/24/18 5:25 PM, Alexander Korotkov wrote:
>> On Fri, Dec 21, 2018 at 1:50 AM Alexander Korotkov
>> <a(dot)korotkov(at)postgrespro(dot)ru> wrote:
>>> чт, 20 дек. 2018 г., 2:22 Andres Freund andres(at)anarazel(dot)de:
>>>> On 2018-12-03 16:07:40 -0800, Andres Freund wrote:
>>>>> As far as I can tell that increase comes laregely from the new GIN
>>>>> tests. Could one of you please look at keeping the test time increase
>>>>> to something more reasonable?
>>>> Ping?
>>>>
>>>> It's also one of the slowest tests outside of valgrind...
>>> I'm going to take a look on that.
>> BTW, patch for reducing isolation testing for gin predicate locking is
>> attached. Could anybody check its execution time with valgrind (and
>> compare with execution time of previous test suite)?
>
>
> Will try if I get some time to spare in the next 72 hours or so
>
>
The latest test on lousyjack ran with this applied. The isolation tests
went from 285 minutes to 65 minutes.
So +1 for applying this.
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | David Steele | 2018-12-27 17:03:31 | Re: Remove Deprecated Exclusive Backup Mode |
Previous Message | Fabien COELHO | 2018-12-27 16:57:33 | Re: Alternative to \copy in psql modelled after \g |