pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: gnari <gnari@simnet.is>
To: pgsql-performance@postgresql.org
Subject: Re: Insert are going slower ...
Date: Wed, 14 Jul 2004 10:06:05 -0000
Message-ID: <003901c4698a$2cfb5a50$0100000a@wp2000> (raw)
References: <200407131850.52095.herve@elma.fr>
	<200407131010.30790.josh@agliodbs.com>
	<200407140142.11720.footcow@noos.fr>


From: "Hervé Piedvache" <footcow@noos.fr>
Sent: Tuesday, July 13, 2004 11:42 PM


> effective_cache_size = 5000000

looks like madness to me.
my (modest) understanding of this, is that
you are telling postgres to assume a 40Gb disk
cache (correct me if I am wrong).

btw, how much effect does this setting have on the planner?

is there a recommended procedure to estimate
the best value for effective_cache_size on a
dedicated DB server ?

gnari








view thread (17+ messages)  latest in thread

Message-ID: <003901c4698a$2cfb5a50$0100000a@wp2000>
Permalink:  ../003901c4698a$2cfb5a50$0100000a@wp2000/
Also on:    postgresql.org/message-id/003901c4698a$2cfb5a50$0100000a@wp2000

 · 

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: gnari@simnet.is
  Subject: Re: Insert are going slower ...
  In-Reply-To: <003901c4698a$2cfb5a50$0100000a@wp2000>

* 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