Re: Trouble Upgrading Postgres

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Trouble Upgrading Postgres
Date: 2018-11-05 17:19:52
Message-ID: ce4e1078-adc8-6a53-55e1-5ee7b0369586@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/05/2018 11:06 AM, Charles Martin wrote:
> Ron said:
>
> >We were expecting the output of the "SHOW SHARED_BUFFERS;" command.
>
> Ok, the result from that command is:
>
> 1GB
>> >The system has only 4GB of RAM. I read that a reasonable swap size is 1/4 of
>> RAM, so I've created a swap file of 1GB.
> >Times have changed...  (I'd have made a 4GB swap file.)
>
> I have a spare drive that is 230G, so I have enough space. I suppose I can
> set swapoff, delete the swapfile, create a new 4G one, and set swapon. Or
> is there a better way?

Linux already knows about the 1GB file; just add a 3GB swap file on the
230GB drive.

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2018-11-05 17:54:21 Re: Trouble Upgrading Postgres
Previous Message Charles Martin 2018-11-05 17:06:10 Re: Trouble Upgrading Postgres