Re: pg 16.4, logical replication, use case = data archiving

My experience with oracle streams (upto version 12.1). there is a tag at capture, by default tag is null (if not defined). at the session level we set DBMS_STREAMS.SET_TAG ; so whatever this session does, will not replicate. Maybe this kind of "tag" is planned in the upcoming logical replication f

pg 16.4, logical replication, use case = data archiving

Hi all, I Play logical replication with row filter feature, my use case is data archiving. in lab env, it worked, my questions: - during alter subscription, what about on-going DML? Can it be lost? - any lock during alter subscription should I aware? scenario: # on source tutorial=# ALTER PUBL

Re: WAL replication and Archive command for pgbackrest on same server conf

hi, you can combine: archive_command = 'pgbackrest --stanza=Demo archive-push %p && cp %p /data/archive/%f ' You need to change your standby replica to consume the wals from pgbackrest if you want instead to use both commands. *Rúben Morais* *(+351) 965775713*

Re: use of postgres reg* datatypes in user tables?

On Sunday, August 18, 2024, plsqlvids01 plsqlvids01 wrote: > > What kind of data does these data types store - numbers or text? > > https://www.postgresql.org/docs/current/datatype-oid.html They are aliases for oid. David J.

WAL replication and Archive command for pgbackrest on same server conf

Hi List , I am trying to configure the pgbackrest on a live server ( RHEL9, EPAS16 and Pgbacrest .2.52) which is having a working WAL archive configuration to a standby server in postgresql.conf as follows 1. archive_mod =on 2. archive_level=replica 3. archive_command = 'cp %p /data/archive

Re: use of postgres reg* datatypes in user tables?

plsqlvids01 plsqlvids01 writes: > What is the use of postgres regclass datatype in user tables? When would > one want to use them when regular data types are available? If any tables > have these data types, since pg_upgrade would fail, what data types should > those be converted to? Indeed, stor

Re: Insert query performance

On Mon, 19 Aug 2024 at 19:48, sud wrote: > In a version 15.4 postgres database, Is it possible that , if we have two big > range partition tables with foreign key relationships between them, insert > into the child table can cause slowness if we don't have foreign key index > present in the chi

Re: Insert query performance

Hi Sud, Please make following change in your postgresql.conf file log_statement = 'all' Regards, Ikram On Mon, Aug 19, 2024 at 12:48 PM sud wrote: > Hello All, > > In a version 15.4 postgres database, Is it possible that , if we have two > big range partition tables with foreign key relatio

Insert query performance

Hello All, In a version 15.4 postgres database, Is it possible that , if we have two big range partition tables with foreign key relationships between them, insert into the child table can cause slowness if we don't have foreign key index present in the child table? Basically it need to make sure