pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alexey Vasiliev <leopard_ne@inbox.ru>
To: Shaun Thomas <sthomas@optionshouse.com>
Cc: 'Josh Berkus' <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject:  Re[2]: [PERFORM] pgtune + configurations with 9.3
Date: Fri, 14 Nov 2014 22:10:24 +0300
Message-ID: <1415992224.324747668@f354.i.mail.ru> (raw)
In-Reply-To: <0683F5F5A5C7FE419A752A034B4A0B9797DCD4DA@sswchi5pmbx2.peak6.net>
References: <CAEaSS0bLy8=1yVVbAH6us3m5d1tQ9obCxeHHeTU6vrqkggcN+g@mail.gmail.com>
	<1415983219.686386092@f34.i.mail.ru>
	<0683F5F5A5C7FE419A752A034B4A0B9797DCD4DA@sswchi5pmbx2.peak6.net>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>




Fri, 14 Nov 2014 17:06:54 +0000 от Shaun Thomas <sthomas@optionshouse.com>:
> Alexey,
> 
> The issue is not that 8GB is the maximum. You *can* set it higher. What I'm saying, and I'm not alone in this, is that setting it higher can actually decrease performance for various reasons. Setting it to 25% of memory on a system with 512GB of RAM for instance, would be tantamount to disaster. A checkpoint with a setting that high could overwhelm pretty much any disk controller and end up  completely ruining DB performance. And that's just *one* of the drawbacks.
> 
> 
> 
> ______________________________________________
> 
> See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
> 
> 
> -- 
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
> 

Ok. Just need to know what think another developers about this - should pgtune care about this case? Because I am not sure, what users with 512GB will use pgtune.

-- 
Alexey Vasiliev
-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


view thread (3+ messages)  latest in thread

Message-ID: <1415992224.324747668@f354.i.mail.ru>
Permalink:  ../1415992224.324747668@f354.i.mail.ru/
Also on:    postgresql.org/message-id/1415992224.324747668@f354.i.mail.ru

 · 

reply
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-performance@postgresql.org
  Cc: leopard_ne@inbox.ru, sthomas@optionshouse.com, josh@agliodbs.com
  Subject: Re:  Re[2]: [PERFORM] pgtune + configurations with 9.3
  In-Reply-To: <1415992224.324747668@f354.i.mail.ru>

* 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