Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)

From: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
To: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Shubham Barai <shubhambaraiss(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Andrew Borodin <amborodin86(at)gmail(dot)com>, Kevin Grittner <kgrittn(at)gmail(dot)com>
Subject: Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)
Date: 2018-03-15 22:26:17
Message-ID: CAPpHfdtpK=VxPGcdtHLh-btj6FycK8eTY1JdoKdVqv7iNs5+7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

On Tue, Mar 13, 2018 at 3:26 PM, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
wrote:

> > 13 марта 2018 г., в 17:02, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
> написал(а):
> >
> > BTW to BTW. I think we should check pending list size with
> GinGetPendingListCleanupSize() here
> > +
> > + /*
> > + * If fast update is enabled, we acquire a predicate lock on the
> entire
> > + * relation as fast update postpones the insertion of tuples
> into index
> > + * structure due to which we can't detect rw conflicts.
> > + */
> > + if (GinGetUseFastUpdate(ginstate->index))
> > + PredicateLockRelation(ginstate->index, snapshot);
> >
> > Because we can alter alter index set (fastupdate = off), but there still
> will be pending list.
> >
> > And what happen if somebody concurrently set (fastupdate = on)?
> > Can we miss conflicts because of that?
> No, AccessExclusiveLock will prevent this kind of problems with enabling
> fastupdate.
>

True. I didn't notice that ALTER INDEX SET locks index in so high mode.
Thus, everything is fine from this perspective.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2018-03-15 22:27:32 Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)
Previous Message Alexander Korotkov 2018-03-15 21:49:42 Re: SET TRANSACTION in PL/pgSQL

Browse pgsql-www by date

  From Date Subject
Next Message Alexander Korotkov 2018-03-15 22:27:32 Re: [HACKERS] GSoC 2017: weekly progress reports (week 6)
Previous Message Tom Lane 2018-03-15 16:00:32 Re: Bogus reports from coverage.postgresql.org