Skip site navigation (1) Skip section navigation (2)

Re: Insert are going slower ...

From: "gnari" <gnari(at)simnet(dot)is>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Insert are going slower ...
Date: 2004-07-14 10:06:05
Message-ID: 003901c4698a$2cfb5a50$0100000a@wp2000 (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
From: "Hervé Piedvache" <footcow(at)noos(dot)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 ?


In response to


pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2004-07-14 10:13:22
Subject: Re: Insert are going slower ...
Previous:From: Hervé PiedvacheDate: 2004-07-13 23:42:11
Subject: Re: Insert are going slower ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group