Search Postgresql Archives
Re: Partitioned tables and locks
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Partitioned tables and locks
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Thu, 19 Dec 2019 15:38:25 -0700
Cc
: Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to
: <
CAANVwEvXZ40q2yYYKmz1eXNKybK6s2yhOzhid4DbGma4HeEvkw@mail.gmail.com
>
References
: <
CAANVwEuOb+B9y2P7h0NruC-dAmf2p1xLJSjm5UMXwTBPAxtjvg@mail.gmail.com
> <
6714.1576762716@sss.pgh.pa.us
> <
CAANVwEvXZ40q2yYYKmz1eXNKybK6s2yhOzhid4DbGma4HeEvkw@mail.gmail.com
>
I don't recall the details, but I know v12 included significant enhancements to lock relations later in the process such that when targeting relatively few of the partitions, it can be a major performance boost.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
Partitioned tables and locks
From:
James Sewell
Re: Partitioned tables and locks
From:
Tom Lane
Re: Partitioned tables and locks
From:
James Sewell
Prev by Date:
Re: Max locks
Next by Date:
install postgres
Previous by thread:
Re: Partitioned tables and locks
Next by thread:
Commit to primary with unavailable sync standby
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
