Re: Questions on logical replication

On 6/5/24 14:54, Koen De Groote wrote: https://www.postgresql.org/docs/current/wal-configuration.html "Checkpoints are points in the sequence of transactions at which it is guaranteed that the heap and index data fi

Re: Questions on logical replication

> > https://www.postgresql.org/docs/current/wal-configuration.html > > "Checkpoints are points in the sequence of transactions at which it is > guaranteed that the heap and index data files have been updated with all > information written before that checkpoint. At checkpoint time, all > dirty data

Re: how to tell if a pg version supports a linux distribution

On 6/5/24 1:24 PM, bruno vieira da silva wrote: Hello, if a pg version has been tested on the buildfarm but the pg yum repository doesn't have packages for a linux distribution that means that distribution isn't supported by pg? how can I find if linux distributions for a pg version have reg

Re: how to tell if a pg version supports a linux distribution

On 6/5/24 1:24 PM, bruno vieira da silva wrote: Hello, if a pg version has been tested on the buildfarm but the pg yum repository doesn't have packages for a linux distribution that means that distribution isn't supported by pg? how can I find if linux distributions for a pg version have reg

how to tell if a pg version supports a linux distribution

Hello, if a pg version has been tested on the buildfarm but the pg yum repository doesn't have packages for a linux distribution that means that distribution isn't supported by pg? how can I find if linux distributions for a pg version have regression tests executed against. e.g. : postgresql 16 d

Re: Long running query causing XID limit breach

On Wed, Jun 5, 2024 at 3:52 PM Laurenz Albe wrote: > > There should never be a restart unless you perform one or the standby > crashes. > If you mean that you want to avoid a crash caused by a full disk on the > standby, > the answer is probably "no". Make sure that you have enough disk space an

Re: Length returns NULL ?

On 2024-06-05 19:50 +0200, Marcos Pegoraro wrote: > There are some functions called ...length, but only array_length returns > NULL on empty array, why ? Because the empty array has zero dimensions[1]. But now I'm wondering why array_ndims returns NULL instead of zero for empty arrays. [1] http

Length returns NULL ?

There are some functions called ...length, but only array_length returns NULL on empty array, why ? select array_length('{}'::text[],1), -->NULL jsonb_array_length('[]'), -->0 bit_length(''), -->0 octet_length(''), -->0 length(''), -->0 char_length(''), -->0

Re: Variant (Untyped) parameter for function/procedure

On 6/5/24 01:34, Durumdara wrote: Dear Members! As I experienced, the functions/procedures extremely depend on parameters (very typed). So if I have to restructure the input parameters, I can't modify the function, because I have to recreate the dependents too. For example: I have a type. If

Re: Purpose of pg_dump tar archive format?

On Tue, Jun 4, 2024 at 7:36 PM Ron Johnson wrote: > On Tue, Jun 4, 2024 at 3:47 PM Gavin Roy wrote: > >> >> On Tue, Jun 4, 2024 at 3:15 PM Ron Johnson >> wrote: >> >>> >>> But why tar instead of custom? That was part of my original question. >>> >> >> I've found it pretty useful for programmati

Re: Poor performance after restoring database from snapshot on AWS RDS

On Wed, Jun 5, 2024 at 4:23 AM Sam Kidman wrote: > We get very poor performance in the staging environment after this > restore takes place - after some usage it seems to get better perhaps > because of caching. > This is due to the way that RDS restores snapshots. >From the docs >(https://doc

Re: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

On Wed, 2024-06-05 at 06:36 +, Meera Nair wrote: > 2024-06-05 11:41:32.369 IST [54369] LOG:  restored log file > "00050001006A" from archive > 2024-06-05 11:41:33.112 IST [54369] LOG:  restored log file > "00050001006B" from archive > cp: cannot stat ‘/home/pgsql/wmast

Re: Long running query causing XID limit breach

On Wed, 2024-06-05 at 13:09 +0530, sud wrote: > > > One follow up question i have , as we are setting one of the > > > standby/replica > > > with value idle_in_transaction_session_timeout=-1 which can cause the > > > WAL's > > > to be heavily backlogged in a scenario where we have a query running

Re: Unable to connect to any data source for foreign server

Hi, Getting back to this after a bit.  I am still having no luck.  I checked the settings for the postgres windows user between the new and old servers, and ensure they are matching.  The user has full control over the directory the file I want to connect to is located in. Here are the resul

Variant (Untyped) parameter for function/procedure

Dear Members! As I experienced, the functions/procedures extremely depend on parameters (very typed). So if I have to restructure the input parameters, I can't modify the function, because I have to recreate the dependents too. For example: I have a type. If I pass this type to a function, I can't

Re: Poor performance after restoring database from snapshot on AWS RDS

Sam Kidman schrieb am 03.06.2024 um 10:06: > We get very poor performance in the staging environment after this > restore takes place - after some usage it seems to get better perhaps > because of caching. > > The staging RDS instance is a smaller size than production (it has > 32GB ram and 8 vCP

Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir

Hi team, With wal_level = 'logical', backup was taken using non-exclusive backup method. Following procedure here for restore and recovery - PostgreSQL: Documentation: 16: 26.3. Continuous Archiving and Point-in-Time Recovery (PITR)

Poor performance after restoring database from snapshot on AWS RDS

We keep the staging environment of our application up to date with respect to production data by creating a new RDS instance for the staging environment and restoring the most recent production snapshot into it. We get very poor performance in the staging environment after this restore takes place

Re: Postgresql 16.3 Out Of Memory

It looks like I did not copy the list. I did run VACUUM ANALYZE after the upgrade. I've even run it now > before getting a new explain plan that is very similar (just the costs > differ): > Gather Merge (cost=12336145.92..16111570.23 rows=31531596 width=66) >Workers Planned: 4 >-> Sort

Re: Long running query causing XID limit breach

On Wed, 5 Jun, 2024, 12:39 pm Simon Elbaz, wrote: > Hi, > > I am following this very interesting thread. > > From the documentation > https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT, > the 0 value will disable the timeout (not -1). > > >

Re: Long running query causing XID limit breach

Hi, I am following this very interesting thread. >From the documentation https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT, the 0 value will disable the timeout (not -1). On Wed, Jun 5, 2024 at 8:25 AM sud wrote: > Hello Laurenz, > > T