pg_basebackup is taking an unusually long time with Postgres 11.3

2019-08-23 Thread andy andy
Hi Folks, I am having trouble setting up replication with Postgres 11.3. pg_basebackup is taking an unusually long time for an small Postgres database. Anything wrong in my configuration or anything I could do to speed up pg_basebackup? I recently upgraded form Postgres 9.2.1. Using a similar p

Re: Out of Memory errors are frustrating as heck!

2019-08-23 Thread Gunther
OK, I went back through that old thread, and I noticed an early opinion by a certain Peter who said that I should provision some swap space. Since I had plenty of disk and no other option I tried that. And it did some magic. Here this is a steady state now: top - 14:07:32 up 103 days, 9:57,

Re: Out of Memory errors are frustrating as heck!

2019-08-23 Thread Tom Lane
Gunther writes: > Hi all, I am connecting to a discussion back from April this year. My > data has grown and now I am running into new out of memory situations. It doesn't look like this has much of anything to do with the hash-table discussion. The big hog is an ExprContext: > ExprContext: 1

Re: Out of Memory errors are frustrating as heck!

2019-08-23 Thread Gunther
Hi all, I am connecting to a discussion back from April this year. My data has grown and now I am running into new out of memory situations. Meanwhile the world turned from 11.2 to 11.5 which I just installed only to find the same out of memory error. Have any of the things discussed and propo