On Fri, 27 Oct 2023 21:21:18 -0700 Adrian Klaver wrote:
>On 10/27/23 16:46, p...@pfortin.com wrote:
>> Peter,
>>
>> Thanks for your patience; I've been feeling pressure to get this
>> resolved; so have been lax in providing info here.. Hope the following
>> helps...
>>
>
>
>> Something I hadn
On Fri, Oct 27, 2023 at 7:46 PM wrote:
> Memory: 125.5 GiB of RAM
>
It looks like you have a large amount of memory allocated to the server
But your plans are doing reads instead of pulling things from shared
buffers
>explain (analyze, buffers) select count(*) from ncvhis_2016_12_03;
> Finalize
On 2023-10-27 23:37:24 +0200, Paul Förster wrote:
> But unfortunately still, my questions c) and d) are unanswered. I'd
> especially be interested in an answer to c), i.e. is it *safe* to
> "pg_checksum -e" the replica instance in a patroni cluster, switch
> over, and then do the other one?
I don'