Re: Doc: fix the note related to the GUC "synchronized_standby_slots"

2024-08-26 Thread David G. Johnston
On Monday, August 26, 2024, Amit Kapila wrote: > On Mon, Aug 26, 2024 at 6:38 PM Zhijie Hou (Fujitsu) > wrote: > > > > On Monday, August 26, 2024 5:37 PM Amit Kapila > wrote: > > > > > > On Mon, Aug 26, 2024 at 1:30 PM wrote: > > > > > > > > When I read the following documentation related to t

RE: Doc: fix the note related to the GUC "synchronized_standby_slots"

2024-08-26 Thread Masahiro.Ikeda
Thans for your responses. > I think you see such a behavior because you have disabled > 'synchronized_standby_slots' > in your script (# disable "synchronized_standby_slots"). You need to enable > that to > avoid data loss. Considering that, I don't think your proposed text is an > improvement.

Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM

2024-08-26 Thread Jeff Davis
On Mon, 2024-08-26 at 23:59 +0200, Matthias van de Meent wrote: > Specifically, I'm having trouble seeing how this could be used to > implement ```INSERT INTO ... SELECT ... RETURNING ctid``` as I see no > returning output path for the newly inserted tuples' data, which is > usually required for ou

Re: Allow logical failover slots to wait on synchronous replication

2024-08-26 Thread Amit Kapila
On Tue, Aug 27, 2024 at 12:58 AM John H wrote: > > For instance, in Shveta's suggestion of > > > > > We can perform this test with both of the below settings and say make > > > > D and E slow in sending responses: > > > > 1) synchronous_standby_names = 'ANY 3 (A,B,C,D,E)' > > > > 2) standby_slot_n

Re: proposal: schema variables

2024-08-26 Thread Laurenz Albe
On Thu, 2024-08-15 at 07:55 +0200, Pavel Stehule wrote: > út 30. 7. 2024 v 21:46 odesílatel Laurenz Albe > napsal: > > - A general reminder: single line comments should start with a lower case > >   letter and have to period in the end: > > Should it be "have not to period in the end" ? I made

Re:allowing extensions to control planner behavior

2024-08-26 Thread chungui.wcg
At 2024-08-27 00:32:53, "Robert Haas" wrote: >I'm somewhat expecting to be flamed to a well-done crisp for saying >this, but I think we need better ways for extensions to control the >behavior of PostgreSQL's query planner. I know of two major reasons >why somebody might want to

Re: proposal: schema variables

2024-08-26 Thread Pavel Stehule
Hi út 27. 8. 2024 v 8:15 odesílatel Laurenz Albe napsal: > On Thu, 2024-08-15 at 07:55 +0200, Pavel Stehule wrote: > > út 30. 7. 2024 v 21:46 odesílatel Laurenz Albe > napsal: > > > - A general reminder: single line comments should start with a lower > case > > > letter and have to period in

Re: Streaming read-ready sequential scan code

2024-08-26 Thread Thomas Munro
Here's a really simple way to see the new unfairness at the end of a parallel scan: drop table if exists t; create table t (i int); insert into t select generate_series(1, 10); alter table t set (parallel_workers = 2); set parallel_setup_cost = 0; set parallel_leader_participation = off; expla

Re: POC, WIP: OR-clause support for indexes

2024-08-26 Thread jian he
On Mon, Aug 26, 2024 at 6:41 PM Alena Rybakina wrote: > > + /* Construct the list of nested OR arguments */ > + for (j = group_start; j < i; j++) > + { > + Node *arg = list_nth(orargs, matches[j].argindex); > + > + rargs = lappend(rargs, arg); > + if (IsA(arg, RestrictInfo)) > + args = lappend(a

<    1   2