Re: GIN predicate locking slows down valgrind isolationtests tremendously

From: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
To: 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-24 22:25:57
Message-ID: CAPpHfdu71eiDzHctaA0vNMJ6L+roStSNRkegGfGcD=ApeAqRyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)?

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
reduce-gin-predicate-locking-isolation-testing-1.patch application/octet-stream 50.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2018-12-24 22:47:57 Re: GIN predicate locking slows down valgrind isolationtests tremendously
Previous Message David Fetter 2018-12-24 22:20:19 Re: Feature: triggers on materialized views