Identify transactions causing highest wal generation

2024-03-08 Thread Gayatri Singh
Hello Team, Can you help me with steps to identify transactions which caused wal generation to surge ? Regards, Gayatri.

Backup and Restore of Partitioned Table in PG-15

2024-06-15 Thread Gayatri Singh
Hi Team, Greetings of the day!! We are planning to partition tables using pg_partman. Like we are planning for their backup and restoration process. Got a few URLs where pg_dump had issues while restoring some data that was lost. kindly guide me the process or steps I need to follow for backing

DB Restarting daily at midnight

2025-02-19 Thread Gayatri Singh
Hi All, We are using postgresql ver 15 , some Talend jobs to load data when we start to do this , DB server goes into kernel panic and reboot . Any idea how to troubleshoot this? DBA says there is some binary data usage . Regards, Gayatri.