From: Kevin Grittner <kgrittn@ymail.com>
To: Dhruv Shukla <dhruvshukla82@gmail.com>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: jayknowsunix@gmail.com <jayknowsunix@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Problems with PG 9.3
Date: Mon, 25 Aug 2014 08:51:07 -0700
Message-ID: <1408981867.41595.YahooMailNeo@web122303.mail.ne1.yahoo.com> (raw)
In-Reply-To: <CAFiWeJDUk4Ja4CRy3Qy+g5fDZYMLM7G_Lmcnq_uVz6zf8to-YA@mail.gmail.com>
References: <CAFiWeJB30=ncjt3gHuYh61ke4x--HA_2xkA9vxxU6puLZTNmCw@mail.gmail.com>
<15C963C4-539B-4A88-9C21-54C3221FD1D7@gmail.com>
<CAFiWeJBWYueKF=BDyMeJAECJA39zr_YvSgf6F+Pf2=_FhKrdsg@mail.gmail.com>
<A737B7A37273E048B164557ADEF4A58B17D2CB2C@ntex2010i.host.magwien.gv.at>
<CAFiWeJBppWiDKBgN49WpFgGrRYw3tG9W=gsjNkZTNwmEafX1=g@mail.gmail.com>
<CAFiWeJDUk4Ja4CRy3Qy+g5fDZYMLM7G_Lmcnq_uVz6zf8to-YA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Dhruv Shukla <dhruvshukla82@gmail.com> wrote:
> Other informational details about configurations are:
> shared_buffers = 80GB
> temp_buffers = 2GB
> work_mem = 2GB
> maintenance_work_mem = 16GB
Well, at the default max_connections of 100 that could easily
result in the server trying to allocate about 567GB of RAM. If
your number of connections is more than 100, adjust proportionally
higher. If the server doesn't have that, you could see extreme
swapping or various other problems as the OS tries to survive.
> effective_cache_size = 130GB
And the planner will be generating plans based on the assumption
that the combination of shared_buffers and the OS cache will have
this much RAM available for caching, so if you have max_connections
= 100 this configuration would only make sense on a machine with
RAM of 617GB or more, plus whatever is needed for the OS and
anything besides PostgreSQL that you want to run on the machine.
How much RAM is on the machine (or VM)?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kgrittn@ymail.com, dhruvshukla82@gmail.com, laurenz.albe@wien.gv.at, jayknowsunix@gmail.com
Subject: Re: Problems with PG 9.3
In-Reply-To: <1408981867.41595.YahooMailNeo@web122303.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox