Re: Implement waiting for wal lsn replay: reloaded

2025-04-29 Thread Alexander Korotkov
Hi, Tomas. Thank you so much for your review! Please find the revised patchset. On Thu, Mar 13, 2025 at 4:15 PM Tomas Vondra wrote: > I did a quick look at this patch. I haven't found any correctness > issues, but I have some general review comments and questions about the > grammar / syntax. >

Re: Implement waiting for wal lsn replay: reloaded

2025-03-16 Thread vignesh C
On Wed, 12 Mar 2025 at 20:14, Yura Sokolov wrote: > > Otherwise v6 is just rebased v5. I noticed that Tomas's comments from [1] are not yet addressed, I have changed the commitfest status to Waiting on Author, please address them and update it to Needs review. [1] - https://www.postgresql.org/me

Re: Implement waiting for wal lsn replay: reloaded

2025-03-13 Thread Tomas Vondra
Hi, I did a quick look at this patch. I haven't found any correctness issues, but I have some general review comments and questions about the grammar / syntax. 1) The sgml docs don't really show the syntax very nicely, it only shows this at the beginning of wait_for.sgml: WAIT FOR ( parameter

Re: Implement waiting for wal lsn replay: reloaded

2025-03-12 Thread Yura Sokolov
10.03.2025 14:30, Alexander Korotkov пишет: > On Fri, Feb 28, 2025 at 3:55 PM Yura Sokolov wrote: >> 28.02.2025 16:03, Yura Sokolov пишет: >>> 17.02.2025 00:27, Alexander Korotkov wrote: On Thu, Feb 6, 2025 at 10:31 AM Yura Sokolov wrote: > I briefly looked into patch and have coup

Re: Implement waiting for wal lsn replay: reloaded

2025-03-10 Thread Alexander Korotkov
On Fri, Feb 28, 2025 at 3:55 PM Yura Sokolov wrote: > 28.02.2025 16:03, Yura Sokolov пишет: > > 17.02.2025 00:27, Alexander Korotkov wrote: > >> On Thu, Feb 6, 2025 at 10:31 AM Yura Sokolov > >> wrote: > >>> I briefly looked into patch and have couple of minor remarks: > >>> > >>> 1. I don't lik

Re: Implement waiting for wal lsn replay: reloaded

2025-02-28 Thread Yura Sokolov
28.02.2025 16:03, Yura Sokolov пишет: > 17.02.2025 00:27, Alexander Korotkov wrote: >> On Thu, Feb 6, 2025 at 10:31 AM Yura Sokolov >> wrote: >>> I briefly looked into patch and have couple of minor remarks: >>> >>> 1. I don't like `palloc` in the `WaitLSNWakeup`. I believe it wont issue >>> prob

Re: Implement waiting for wal lsn replay: reloaded

2025-02-28 Thread Yura Sokolov
17.02.2025 00:27, Alexander Korotkov wrote: > On Thu, Feb 6, 2025 at 10:31 AM Yura Sokolov wrote: >> I briefly looked into patch and have couple of minor remarks: >> >> 1. I don't like `palloc` in the `WaitLSNWakeup`. I believe it wont issue >> problems, but still don't like it. I'd prefer to see

Re: Implement waiting for wal lsn replay: reloaded

2025-02-16 Thread Alexander Korotkov
Hi, Yura! On Thu, Feb 6, 2025 at 10:31 AM Yura Sokolov wrote: > I briefly looked into patch and have couple of minor remarks: > > 1. I don't like `palloc` in the `WaitLSNWakeup`. I believe it wont issue > problems, but still don't like it. I'd prefer to see local fixed array, say > of 16 element

Re: Implement waiting for wal lsn replay: reloaded

2025-02-06 Thread Yura Sokolov
27.11.2024 07:08, Alexander Korotkov wrote: > Present solution > > The present patch implements a new utility command WAIT FOR LSN > 'target_lsn' [, TIMEOUT 'timeout'][, THROW 'throw']. Unlike previous > attempts to implement custom syntax, it uses only one extra unreserved > keyword. The parame

Re: Implement waiting for wal lsn replay: reloaded

2025-02-05 Thread Andrei Lepikhov
On 12/4/24 18:12, Kirill Reshke wrote: On Wed, 27 Nov 2024 at 09:09, Alexander Korotkov wrote: Any comments? What's the current status of https://commitfest.postgresql.org/50/5167/ ? Should we close it or reattach to this thread? To push this feature further I rebased the patch onto current m

Re: Implement waiting for wal lsn replay: reloaded

2024-12-04 Thread Kirill Reshke
On Wed, 27 Nov 2024 at 09:09, Alexander Korotkov wrote: > > Hi! > > Introduction > > The simple way to wait for a given lsn to replay on standby appears to > be useful because it provides a way to achieve read-your-writes > consistency while working with both replication leader and standby. > And