Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-27 Thread Alexander Korotkov
On Thu, Dec 27, 2018 at 7:58 PM Andrew Dunstan wrote: > On 12/24/18 5:47 PM, Andrew Dunstan wrote: > > On 12/24/18 5:25 PM, Alexander Korotkov wrote: > >> BTW, patch for reducing isolation testing for gin predicate locking is > >> attached. Could anybody check its execution time with valgrind (an

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-27 Thread Andrew Dunstan
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 >> wrote: >>> чт, 20 дек. 2018 г., 2:22 Andres Freund and...@anarazel.de: On 2018-12-03 16:07:40 -0800, Andres Freund wrote: > As far as I ca

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-26 Thread Alexander Korotkov
On Tue, Dec 25, 2018 at 1:25 AM Alexander Korotkov wrote: > On Fri, Dec 21, 2018 at 1:50 AM Alexander Korotkov > wrote: > > чт, 20 дек. 2018 г., 2:22 Andres Freund and...@anarazel.de: > >> On 2018-12-03 16:07:40 -0800, Andres Freund wrote: > >> > As far as I can tell that increase comes laregely

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-25 Thread Alexander Korotkov
On Tue, Dec 25, 2018 at 4:32 AM Alexander Korotkov wrote: > On Tue, Dec 25, 2018 at 12:19 AM Alexander Korotkov > wrote: > > So, we're checking for conflict on tree root for every entry insert. > > That's right for posting tree, but completely unneeded for entry tree. > > I'm intended to change t

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-24 Thread Alexander Korotkov
On Tue, Dec 25, 2018 at 12:19 AM Alexander Korotkov wrote: > So, we're checking for conflict on tree root for every entry insert. > That's right for posting tree, but completely unneeded for entry tree. > I'm intended to change that to lock root of only posting tree if > nobody explains me why I'm

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-24 Thread Alexander Korotkov
On Tue, Dec 25, 2018 at 1:48 AM Andrew Dunstan wrote: > On 12/24/18 5:25 PM, Alexander Korotkov wrote: > > On Fri, Dec 21, 2018 at 1:50 AM Alexander Korotkov > > wrote: > >> чт, 20 дек. 2018 г., 2:22 Andres Freund and...@anarazel.de: > >>> On 2018-12-03 16:07:40 -0800, Andres Freund wrote: >

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-24 Thread Andrew Dunstan
On 12/24/18 5:25 PM, Alexander Korotkov wrote: > On Fri, Dec 21, 2018 at 1:50 AM Alexander Korotkov > wrote: >> чт, 20 дек. 2018 г., 2:22 Andres Freund and...@anarazel.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 G

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-24 Thread Alexander Korotkov
On Fri, Dec 21, 2018 at 1:50 AM Alexander Korotkov wrote: > чт, 20 дек. 2018 г., 2:22 Andres Freund and...@anarazel.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

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-24 Thread Alexander Korotkov
On Fri, Dec 21, 2018 at 1:50 AM Alexander Korotkov wrote: > чт, 20 дек. 2018 г., 2:22 Andres Freund and...@anarazel.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

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-20 Thread Alexander Korotkov
чт, 20 дек. 2018 г., 2:22 Andres Freund and...@anarazel.de: > On 2018-12-03 16:07:40 -0800, Andres Freund wrote: > > Hi, > > > > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=skink&dt=2018-03-31%2014%3A40%3A02 > > isolation-check (02:19:36) > > > > > https://buildfarm.postgresql.org/cg

Re: GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-19 Thread Andres Freund
On 2018-12-03 16:07:40 -0800, Andres Freund wrote: > Hi, > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=skink&dt=2018-03-31%2014%3A40%3A02 > isolation-check (02:19:36) > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=skink&dt=2018-03-28%2010%3A40%3A02 > isolation-check (00

GIN predicate locking slows down valgrind isolationtests tremendously

2018-12-03 Thread Andres Freund
Hi, https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=skink&dt=2018-03-31%2014%3A40%3A02 isolation-check (02:19:36) https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=skink&dt=2018-03-28%2010%3A40%3A02 isolation-check (00:18:44) As far as I can tell that increase comes laregely from t