Re: Recommended books for admin

Hi , Here is a lately published book https://www.amazon.com/PostgreSQL-Administration-Cookbook-real-world-challenges-ebook/dp/B0CP5PPSTQ Muhammad Ikram Bitnine Global On Tue, 25 Jun 2024 at 19:09, Bill Smith wrote: > Check out the left side bar > > Documentation <https://www.po

Re: New standby_slot_names GUC in PG 17

Thanks Tom Lane. You are more insightful. Regards, Ikram On Sat, Jun 22, 2024 at 12:50 AM Tom Lane wrote: > Muhammad Ikram writes: > > A humble input, as on primary we have #primary_slot_name = '' then > should > > not it be okay to have standby_slot_names or standby_sl

Re: New standby_slot_names GUC in PG 17

Hi, A humble input, as on primary we have #primary_slot_name = '' then should not it be okay to have standby_slot_names or standby_slot_name ? It seems consistent with the Guc on primary. Another suggestion is *standby_replication_slots*. Regards, Muhammad Ikram Bitnine Global. On Fri, Jun 21

Re: Backup and Restore of Partitioned Table in PG-15

Hi Gayatri Singh, Could you try pgBackRest ? Its advantages are speed, support for incremental backups, minimal locking, and robust point in time recovery options besides several advanced features. Best suites for large-scale and critical PostgreSQL deployments. Regards, Muhammad Ikram Bitnine

Re: First draft of PG 17 release notes

t; Thanks for working on that. > > > +2023-11-02 [cac169d68] Increase DEFAULT_FDW_TUPLE_COST from 0.01 to 0.2 > > > +Double the default foreign data wrapper tuple cost (David Rowley, Umair > Shahid) > > That's 20x rather than 2x. > > David > > > -- Muhammad Ikram