Re: Need help

On 12/29/23 21:21, ankit.si...@nest-is2.com wrote: Needs  a lot more information: 1) Postgres version being restored to.--- *14.10* 2)The complete pg_restore command. --- */home/zulip/deployments/current/scripts/setup/restore-backup /path/to/backup* 3) The complete error message*.    

Re: Increased storage size of jsonb in pg15

On Fri, Dec 29, 2023 at 4:47 AM Adrian Klaver wrote: > > On 12/28/23 12:41, Sean Flaherty wrote: > > I'm rather new to the mailing list, are there any additional steps I > > should take (i.e. posting to pgsql-hackers, etc.)? > > > > For what purpose? You are seeing differences in compression

Re: Need help

writes: > In Ubuntu 22.04LTS when we try to restore the database it's giving the error > - pg restore unsupported 1.15 You need a version of pg_restore that's at least as new as the pg_dump that made the archive file. File version 1.15 I believe requires PG 16. regards,

Re: Increased storage size of jsonb in pg15

I have included your suggestion to document any changes to the default Postgres settings to the Amazon RDS for PostgreSQL updates page in our ticket with AWS. On Fri, Dec 29, 2023 at 9:43 AM Adrian

Re: Need help

On 12/29/23 6:02 AM, ankit.si...@nest-is2.com wrote: In Ubuntu 22.04LTS when we try to restore the database it's giving the error – pg restore unsupported 1.15 Needs  a lot more information: 1) Postgres version being restored to. 2) The complete pg_restore command. 3) The complete error

Re: Intermittent Issue with WAL Segment Removal in Logical Replication

On 12/27/23 16:31, Kaushik Iska wrote: > Hi all, > > I'm including additional details, as I am able to reproduce this issue a > little more reliably. > > Postgres Version: POSTGRES_14_9.R20230830.01_07 > Vendor: Google Cloud SQL > Logical Replication Protocol version 1 > I don't know much

Need help

In Ubuntu 22.04LTS when we try to restore the database it's giving the error - pg restore unsupported 1.15

Re: Increased storage size of jsonb in pg15

On 12/29/23 07:21, Sean Flaherty wrote: What we found is that using lz4 compression on JSONB data is 20-25% larger on disk than pglz.  We are running a production workload that is storing jsonb data with a focus read performance.  The documented increase in write speed wasn't a large benefit,

Re: Increased storage size of jsonb in pg15

Junwang Zhao writes: > On Fri, Dec 29, 2023 at 4:47 AM Adrian Klaver > wrote: >> For what purpose? You are seeing differences in compression strategies >> between lz4 and pglz. The 'fix' would be to go back to pglz. > Agreed, lz4 is known for its high compression speed, but lower > compression

Re: Increased storage size of jsonb in pg15

What we found is that using lz4 compression on JSONB data is 20-25% larger on disk than pglz. We are running a production workload that is storing jsonb data with a focus read performance. The documented increase in write speed wasn't a large benefit, however, the increase in storage size moved

Re: Intermittent Issue with WAL Segment Removal in Logical Replication

On 12/29/23 22:28, Kaushik Iska wrote: > I am unfortunately not really familiar with Google Cloud SQL internals > as well. But we have seen this happen on Amazon RDS as well. > Do you have a reproducer for regular Postgres? > Could it be possible that we are requesting a future WAL segment, say