way?
Kind regards,
Leif Harald Karlsen
Senior Lecturer
Department of Informatics
University of Oslo
From: Andrey Lepikhov
Sent: 24 June 2022 19:27:50
To: Leif Harald Karlsen; pgsql-hackers@lists.postgresql.org
Subject: Re: Implement hook for self-join simplification
t a path-level?
If not, does anyone have a an idea on how this can be done in a different way?
Thanks!
Kind regards,
Leif Harald Karlsen
Senior Lecturer
Department of Informatics
University of Oslo
Great job with the patch Peter, it has been even cleaner than before after you
moved the check.
> "Peter Eisentraut" skrev 27. januar 2020
> kl. 12:16:
> "Peter Eisentraut" skrev 14. januar 2020
> kl. 21:13:
>
> On 2019-12-11 12:40, Leif Gunnar Erlandsen wrote:
>> Adding patch written for 13dev from git
>> "Michael Paquier" skrev 1. desember 2019 kl. 03:08:
>> On Fri, Nov 22, 2019 at 11:26:59
Adding patch written for 13dev from git
"Michael Paquier" skrev 1. desember 2019 kl. 03:08:
> On Fri, Nov 22, 2019 at 11:26:59AM +, Leif Gunnar Erlandsen wrote:
>
>> No it does not. It works well to demonstrate its purpose though.
>> And it might be to stop with
"Peter Eisentraut" skrev 22. november 2019
kl. 11:50:
> On 2019-11-21 13:50, Leif Gunnar Erlandsen wrote:
>
>> Pausing was choosen in the patch as pause was the expected behaivior if
>> target was reached.
>
> Pausing is the expect behavior when the tar
"Kyotaro Horiguchi" skrev 22. november 2019 kl. 05:26:
> Hello, Lief, Peter.
>
> At Thu, 21 Nov 2019 12:50:18 +, "Leif Gunnar Erlandsen"
> wrote in
>
>> Adding another patch which is not only for recovery_target_time but also for
>> xid,
expected behaivior if target
was reached.
And the patch does not interfere with any other functionality as far as I know.
--
Leif Gunnar Erlandsen
0002-pause-recovery-if-pitr-target-not-reached.patch
Description: Binary data
ARGET_XID, RECOVERY_TARGET_NAME, RECOVERY_TARGET_LSN as well as
RECOVERY_TARGET_TIME.
---
Leif Gunnar Erlandsen
ry': No such file
or directory
[21943] LOG: selected new timeline ID: 2
[21943] LOG: archive recovery complete
cp: cannot stat '/var/lib/pgsql/12m/archivedwal/0001.history': No such file
or directory
[21941] LOG: database system is ready to accept connections
Leif Gunnar Erlandsen
0001-pause-recovery-if-pitr-target-not-reached.patch
Description: Binary data
se system.
AFAIK the doc does not specify what happens if recovery_target_time is
specified but not reached. But as default recovery_target_action is set to
"pause" I would have assumed "pause" to be the action.
regards
Leif Gunnar Erlandsen
rt.
>> With large databases and a lot of wal-files it is time consuming to repeat
>> parts of the process.
>
> I understand your concern.
>
> regards.
>
> --
> Kyotaro Horiguchi
> NTT Open Source Software Center
regards
Leif Gunnar Erlandsen
-files and restart postgresql to continue with recover.
With large databases and a lot of wal-files it is time consuming to repeat
parts of the process.
Best regards
Leif Gunnar Erlandsen
Hi
I have reported a bug via PostgreSQL bug report form, but havent got any
response so far.
This might not be a bug, but a feature not implemented yet.
I have created an suggestion to make a small addition to StartupXLOG.c to solve
the issue.
Any suggestions?
--
Leif Gunnar Erlandsen
14 matches
Mail list logo