PG12: Any drawback of increasing wal_keep_segments

2022-03-24 Thread Shukla, Pranjal
Team, Are there any disadvantages of increasing the “wal_keep_segments” to a higher number say, 500? Will it have any impact on performance of streaming replication, on primary or secondary servers? Thanks & Regards Pranjal Shukla

Re: PG12: Any drawback of increasing wal_keep_segments

2022-03-24 Thread Alvaro Herrera
On 2022-Mar-22, Shukla, Pranjal wrote: > Team, > Are there any disadvantages of increasing the “wal_keep_segments” to a > higher number say, 500? Will it have any impact on performance of > streaming replication, on primary or secondary servers? No. It just means WAL will occupy more disk space.

Get primary key of a table through SPI

2022-03-24 Thread Oskar Stenberg
Hi! I need to get the primary keys of a few tables for some code that I'm writing in C. I've found out how to do this through regular SQL code and I know that I can use that SQL code through the SPI. But I was just wondering if there is a better/faster way to get information like this directly

Re: Get primary key of a table through SPI

2022-03-24 Thread Tom Lane
Oskar Stenberg writes: > I need to get the primary keys of a few tables for some code that I'm writing > in C. I've found out how to do this through regular SQL code and I know that > I can use that SQL code through the SPI. But I was just wondering if there is > a better/faster way to get info