Re: Does PGDG apt repository support ARM64?

2022-03-31 Thread Adrian Klaver
On 3/31/22 18:22, Daniele Varrazzo wrote: Hello, Psycopg binary files are built on Debian Stretch images. I have noticed that, on arm64 platforms, even if the pgdg apt repository is configured, apt-get will install libpq 9.6 (from the Debian repository), not the 14 available in pgdg. As a

Does PGDG apt repository support ARM64?

2022-03-31 Thread Daniele Varrazzo
Hello, Psycopg binary files are built on Debian Stretch images. I have noticed that, on arm64 platforms, even if the pgdg apt repository is configured, apt-get will install libpq 9.6 (from the Debian repository), not the 14 available in pgdg. As a result, certain features are not available on

Locking a table read-only temporarilty

2022-03-31 Thread Digimer
Hi all,   I've been looking up locking, and perhaps I'm being dense, but I'm struggling to figure out how to create a lock to make a table read-only for a short period of time.   I want to set a table to be read-only, so that any other clients that try to

Re: PG12: Any drawback of increasing wal_keep_segments

2022-03-31 Thread Stephen Frost
Greetings, On Thu, Mar 31, 2022 at 12:58 Marc wrote: > On 29 Mar 2022, at 17:17, Stephen Frost wrote: > > Greetings, > >- Alvaro Herrera (alvhe...@alvh.no-ip.org) wrote: > > On 2022-Mar-22, Shukla, Pranjal wrote: > > Are there any disadvantages of increasing the “wal_keep_segments” to a >

Re: PG12: Any drawback of increasing wal_keep_segments

2022-03-31 Thread Marc
On 29 Mar 2022, at 17:17, Stephen Frost wrote: Greetings, * Alvaro Herrera (alvhe...@alvh.no-ip.org) wrote: On 2022-Mar-22, Shukla, Pranjal wrote: Are there any disadvantages of increasing the “wal_keep_segments” to a higher number say, 500? Will it have any impact on performance of