Re: infinite loop in an update statement

On Tue, Sep 10, 2024 at 4:49 PM Fabrice Chapuis wrote: > no lock, in view pg_stat_activity > > status = active > wait event = NULL > wait event type = NULL > > On Mon, Sep 9, 2024 at 5:00 PM Tom Lane wrote: > >> Fabrice Chapuis writes: >> > wh

infinite loop in an update statement

Hi, table a and b are empty, this query does not return. It seems we enter in infinite loop. why this update does not return instantly? UPDATE table_a a SET col1 = (SELECT MIN(b.col1) FROM table_b b WHERE b.col2 = a.col2) Regards, Fabrice

Problem managing slots in Patroni

Hi, I use patroni version 3.2.1. There is a point that I do not understand in the slots management with Patroni. Patroni creates a slot automatically on primary node when there is a standby attached, although this slot does not belong to the patroni configuration. How to prevent the automatic crea

Re:

at 5:25 AM Kirk Wolak wrote: > On Mon, May 15, 2023 at 11:42 AM Fabrice Chapuis > wrote: > >> I am using postgres v.14 on rhel8 >> I enabled the track_commit_timestamp parameter. >> >> postgres [379418]=# show track_commit_timestamp ; >> ┌

[no subject]

ment types. You might need to add explicit type casts. What is the xid type and how can I cast integer value to make pg_xact_commit_timestamp to work? Regards Fabrice Chapuis

pg_basebackup / recovery

During recovery process of a self contained backup, how postgres know to stop reading wal when consistency is reached?

Re: pg_restore remap schema

his way I don't want to go against the advice of experts who have been working on the postgres code for years. Thank you for your comments Regards, Fabrice On Wed, Nov 16, 2022 at 3:42 PM Tom Lane wrote: > Guillaume Lelarge writes: > > Le mer. 16 nov. 2022 à 13:08, Fabrice C

Re: pg_restore remap schema

further? Regards, Fabrice On Mon, Aug 8, 2022 at 8:22 PM Tom Lane wrote: > Guillaume Lelarge writes: > > Le lun. 8 août 2022 à 18:28, Fabrice Chapuis a > >> Is a development in progress to add this option > > > Nope, never heard of someone working on this. > > P

Re: pg_restore remap schema

Thank you for your reply. sed is a solution for making substitutions on plain text. But if we work with directory mode to use parallelism, I don't see how to proceed to make a schema remap. Editing the toc file in text mode does not work neither. Regards, Fabrice On Mon, Aug 8, 2022 at 9:27 PM M

pg_restore remap schema

Hello, I can't find an option with pg_restore to rename an exported schema schema1 -> schema2 Is a development in progress to add this option Regards, Fabrice