pgsql: Further simplify a bit of logic in StartupXLOG().

2021-08-02 Thread Thomas Munro
Further simplify a bit of logic in StartupXLOG(). Commit 7ff23c6d277d1d90478a51f0dd81414d343f3850 left us with two identical cases. Collapse them. Author: Robert Haas Discussion: https://postgr.es/m/CA%2BhUKGJ8NRsqgkZEnsnRc2MFROBV-jCnacbYvtpptK2A9YYp9Q%40mail.gmail.com Branch -- master De

pgsql: Allow ordered partition scans in more cases

2021-08-02 Thread David Rowley
Allow ordered partition scans in more cases 959d00e9d added the ability to make use of an Append node instead of a MergeAppend when we wanted to perform a scan of a partitioned table and the required sort order was the same as the partitioned keys and the partitioned table was defined in such a wa

pgsql: Track a Bitmapset of non-pruned partitions in RelOptInfo

2021-08-02 Thread David Rowley
Track a Bitmapset of non-pruned partitions in RelOptInfo For partitioned tables with large numbers of partitions where queries are able to prune all but a very small number of partitions, the time spent in the planner looping over RelOptInfo.part_rels checking for non-NULL RelOptInfos could become

pgsql: Doc: minor improvements for logical replication protocol documen

2021-08-02 Thread Tom Lane
Doc: minor improvements for logical replication protocol documentation. Where appropriate, annotate message field data types with the backend code's name for the data type, eg XLogRecPtr or TimestampTz. Previously we just said "Int64" which didn't provide as much info. Also clarify references to

Re: pgsql: Add support for prepared transactions to built-in logical replic

2021-08-02 Thread Amit Kapila
On Sat, Jul 31, 2021 at 10:11 AM Amit Kapila wrote: > > On Fri, Jul 30, 2021 at 6:17 PM Michael Paquier wrote: > > > > Hi Amit, > > > > On Wed, Jul 14, 2021 at 02:41:43AM +, Amit Kapila wrote: > > > Add support for prepared transactions to built-in logical replication. > > > > 021_twophase.pl