pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Euler Taveira <euler@eulerto.com>
To: houzj.fnst@fujitsu.com <houzj.fnst@fujitsu.com>
To: Amit Kapila <amit.kapila16@gmail.com>
To: Alexander Lakhin <exclusion@gmail.com>
Cc: kuroda.hayato@fujitsu.com <kuroda.hayato@fujitsu.com>
Cc: pgsql-hackers@lists.postgresql.org <pgsql-hackers@lists.postgresql.org>
Subject: Re: speed up a logical replica setup
Date: Thu, 11 Jul 2024 10:34:04 -0300
Message-ID: <9ee2d69a-62e1-4a79-91b1-d65580b53547@app.fastmail.com> (raw)
In-Reply-To: <OS0PR01MB571670F060D9BC88FB2F61B794A52@OS0PR01MB5716.jpnprd01.prod.outlook.com>
References: <9a9c7e65-c47b-4400-a63e-ac6169c0860e@app.fastmail.com>
	<CAA4eK1KPoLUUGzjw9eEQd56LUAf2QQj8BqMcsoSe6vycB5CYUQ@mail.gmail.com>
	<2e86cf53-c806-49d2-9a10-1a1257776d1f@app.fastmail.com>
	<CAA4eK1JJq_ER6Kq_H=jKHR75QPRd8y9_D=RtYw=aPYKMfqLi9A@mail.gmail.com>
	<CAA4eK1KdCb+5sjYu6qCMXXdCX1y_ihr8kFzMozq0=P=auYxgog@mail.gmail.com>
	<CANhcyEV6q1Vhd37i1axUeScLi0UAGVxta1LDa0BV0Eh--TcPMg@mail.gmail.com>
	<CAA4eK1JaQcAZ=n513-4VDW4ujE9T9f007fczNCpVDbg1smhT4g@mail.gmail.com>
	<5da4b286-e570-4341-8262-92d763f6b1a4@app.fastmail.com>
	<776c5cac-5ef5-4001-b1bc-5b698bc0c62a@app.fastmail.com>
	<3c024250-3f13-4f4d-b8e9-55f176db4abf@eisentraut.org>
	<0dffca12-bf17-4a7a-334d-225569de5e6e@gmail.com>
	<OSBPR01MB25528300C71FDD83EA1DCA12F5DD2@OSBPR01MB2552.jpnprd01.prod.outlook.com>
	<CAA4eK1+Qmc34cooSNm2=U6YsySSjZTn2_eD_deDFEAZv+aj-AA@mail.gmail.com>
	<OSBPR01MB2552440DCE1AE5EDC51BAEC6F5DD2@OSBPR01MB2552.jpnprd01.prod.outlook.com>
	<CAA4eK1J9Vn1HB7sXNx-cH4COBd_moGZtrZd82Z160mK6u0HspQ@mail.gmail.com>
	<bde6ac67-69cc-c104-5ab6-dd4f5deadf24@gmail.com>
	<CAA4eK1KG7+jUdONhsELY2poyBrmesNnkt-m5QSgPhgyyM6cFHQ@mail.gmail.com>
	<OS0PR01MB571670F060D9BC88FB2F61B794A52@OS0PR01MB5716.jpnprd01.prod.outlook.com>

On Thu, Jul 11, 2024, at 8:22 AM, Zhijie Hou (Fujitsu) wrote:
> The analysis and suggestion look reasonable to me.
> Here is a small patch which does the same.

LGTM. However, I would add a comment above the INSERT you moved around to remind
you that a transaction cannot be added there because it will break this test.


--
Euler Taveira
EDB   https://www.enterprisedb.com/

view thread (320+ messages)  latest in thread

Message-ID: <9ee2d69a-62e1-4a79-91b1-d65580b53547@app.fastmail.com>
Permalink:  ../9ee2d69a-62e1-4a79-91b1-d65580b53547@app.fastmail.com/
Also on:    postgresql.org/message-id/9ee2d69a-62e1-4a79-91b1-d65580b53547@app.fastmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: euler@eulerto.com, houzj.fnst@fujitsu.com, amit.kapila16@gmail.com, exclusion@gmail.com, kuroda.hayato@fujitsu.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: speed up a logical replica setup
  In-Reply-To: <9ee2d69a-62e1-4a79-91b1-d65580b53547@app.fastmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox