Re: Implement hook for self-join simplification

2022-06-24 Thread Leif Harald Karlsen
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

Implement hook for self-join simplification

2022-06-24 Thread Leif Harald Karlsen
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

Re: pause recovery if pitr target not reached

2020-01-28 Thread Leif Gunnar Erlandsen
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:

Re: pause recovery if pitr target not reached

2020-01-15 Thread Leif Gunnar Erlandsen
> "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

Re: pause recovery if pitr target not reached

2019-12-11 Thread Leif Gunnar Erlandsen
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

Re: pause recovery if pitr target not reached

2019-11-22 Thread Leif Gunnar Erlandsen
"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

Re: pause recovery if pitr target not reached

2019-11-22 Thread Leif Gunnar Erlandsen
"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,

Re: pause recovery if pitr target not reached

2019-11-21 Thread Leif Gunnar Erlandsen
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

Re: pause recovery if pitr target not reached

2019-11-06 Thread Leif Gunnar Erlandsen
ARGET_XID, RECOVERY_TARGET_NAME, RECOVERY_TARGET_LSN as well as RECOVERY_TARGET_TIME. --- Leif Gunnar Erlandsen

pause recovery if pitr target not reached

2019-09-17 Thread 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

Re: BUG #15589: Due to missing wal, restore ends prematurely and opens database for read/write

2019-02-27 Thread leif
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

Re: BUG #15589: Due to missing wal, restore ends prematurely and opens database for read/write

2019-02-22 Thread leif
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

Fwd: Re: BUG #15589: Due to missing wal, restore ends prematurely and opens database for read/write

2019-01-30 Thread leif
-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

Fwd: Re: BUG #15589: Due to missing wal, restore ends prematurely and opens database for read/write

2019-01-22 Thread leif
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