Re: Replication lag in Postgres

2024-07-13 Thread Muhammad Imtiaz
Hi, I recommend the following configurations/options in this case: • wal_sender_timeout: This setting determines how long the primary server waits for the standby server to acknowledge receipt of WAL data. Adjusting this can help ensure timely data transfer. • wal_keep_size: Ensures that enough

pg_rewind Issue: Trying to read Incorrect WAL file for checkpoint record

2024-07-13 Thread azeem subhani
Hi, I have a 1 primary, 2 standby streaming replication cluster. The primary node (`pgsql/16-b/data`) shut down to trigger a failover. One standby (`psql/16-a/data`) was promoted to primary, and write operations were performed on the new primary and replicated to the other standby. I attempted to

Re: Dropping column from big table

2024-07-13 Thread Peter J. Holzer
On 2024-07-11 10:06:47 +0200, Laurenz Albe wrote: > On Thu, 2024-07-11 at 13:10 +0530, sud wrote: > > Dropping will take it's own time for post vacuum however as you > > rightly said, it won't be blocking which should be fine.  > > I am not certain if you understood this correctly. > > Dropping a