Re: Trouble Upgrading Postgres - Mailing list pgsql-general

From Charles Martin
Subject Re: Trouble Upgrading Postgres
Date
Msg-id CAFw6=U2uEr-6DQBcYqgQrBfjU9=jo7EqPOBm_WM_Ppw8fGr1Vw@mail.gmail.com
Whole thread Raw
In response to Re: Trouble Upgrading Postgres  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Trouble Upgrading Postgres
Re: Trouble Upgrading Postgres
List pgsql-general
Adrian said:

>Tom was referring to this from your previous post:
>(postmaster) total-vm:3068900kB,
>where vm(VM) is Virtual Memory:
>https://stackoverflow.com/questions/18845857/what-does-anon-rss-and-total-vm-mean#22326766
>So what is your shared_buffers:
>https://www.postgresql.org/docs/10/static/runtime-config-resource.html
>set to?

Ok, thanks for explaining this. Here is the current value:
"shared_buffers" "131072" "8kB"
                                     


On Mon, Nov 5, 2018 at 9:06 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 11/5/18 5:56 AM, Charles Martin wrote:
> Tom said:
>
>  >That's kind of odd: a COPY shouldn't really consume very much working
>  >memory.  I suspect that much of the process's apparent VM consumption may
>  >be shared buffers ... what have you got shared_buffers set to on the old
>  >server?  If it's more than half a GB or so, maybe reducing it would help.
>
> This is not a VM, but hardware.

Tom was referring to this from your previous post:

(postmaster) total-vm:3068900kB,

where vm(VM) is Virtual Memory:

https://stackoverflow.com/questions/18845857/what-does-anon-rss-and-total-vm-mean#22326766

So what is your shared_buffers:

https://www.postgresql.org/docs/10/static/runtime-config-resource.html

set to?

>
> Adrian said:
>
>  >In addition to the other suggestions, what is the exact pg_dump command
>  >you are using?
>
> The last time:
>
> [postgres@mandj tmp]$ pg_dump martinandjones >
> /mnt/4tbB/pgbackup/2018-11-02/mandj.bak
>
>
>
>
> On Sun, Nov 4, 2018 at 8:16 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 11/4/18 2:55 PM, Charles Martin wrote:
>      > Yep, you called it:
>      >
>      > Nov  2 20:30:45 localhost kernel: Out of memory: Kill process 30438
>      > (postmaster) score 709 or sacrifice child
>      > Nov  2 20:30:45 localhost kernel: Killed process 30438, UID 26,
>      > (postmaster) total-vm:3068900kB, anon-rss:1695392kB,
>     file-rss:1074692kB
>      >
>      > So it's running out of memory when trying to dump this table. The
>     "old"
>      > server has 4GB of ram, the "new" server 20GB.
>      >
>
>     In addition to the other suggestions, what is the exact pg_dump command
>     you are using?
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Trouble Upgrading Postgres
Next
From: Adrian Klaver
Date:
Subject: Re: Trouble Upgrading Postgres