Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Thu, 20 Aug 2020 15:42:36 -0600
Cc
: Pgsql Performance <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
e97e1113-afb2-54dc-93f8-75cf8f9559c3@talentstack.to
>
References
: <
c192f8bf-a747-6ad9-c54d-1bd6febafc4f@talentstack.to
> <
CAHOFxGodYysPhKRwybWksDdxQu0EGVMtgL1dGpLrdXxj382ttg@mail.gmail.com
> <
5e5ba420-9365-265d-c62a-4586cfb7c418@talentstack.to
> <CAHOFxGq6qCkyDV3DYynxp8BKg4Q5uPQcjUSzXH=OFBnm70S6Og@mail.gmail.com> <
ccaa5c05-196a-50c4-9d9d-705e3a6bccac@talentstack.to
> <CAHOFxGo1Aq1+c++1-p1oy2J13D2+oQJ2r=_oXH2F3y-wJ3Uc9Q@mail.gmail.com> <
e97e1113-afb2-54dc-93f8-75cf8f9559c3@talentstack.to
>
Can you share an explain analyze for the query that does the select for update? I wouldn't assume that partition pruning is possible at all with hash, and it would be interesting to see how it is finding those rows.
Follow-Ups
:
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From:
Jim Jarvie
References
:
CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From:
Jim Jarvie
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From:
Michael Lewis
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From:
Jim Jarvie
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From:
Michael Lewis
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From:
Jim Jarvie
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From:
Michael Lewis
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
From:
Jim Jarvie
Prev by Date:
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
Next by Date:
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
Previous by thread:
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
Next by thread:
Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
