pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-performance@postgresql.org
Subject: Re: Sun vs. Mac - best Postgres platform?
Date: Tue, 14 Jan 2003 14:18:53 -0500
Message-ID: <20030114141853.V5335@mail.libertyrms.com> (raw)
In-Reply-To: <20030114190149.7293.qmail@web21104.mail.yahoo.com>
References: <20030114133046.T5335@mail.libertyrms.com>
	<20030114190149.7293.qmail@web21104.mail.yahoo.com>

On Tue, Jan 14, 2003 at 11:01:49AM -0800, CaptainX0r wrote:

> I changed back to the default 1024, and down to the minimum, 64
> - no change.  I think that was changed simultaneously with some
> other parameter (bad, I know) that actually had an affect.  I
> guess I can remove it.

Very bad to change two things at once.  You think it's saving you
time, but now . . . well, you already know what happens ;-)  Anyway,
you _still_ shouldn't have it that high.

> > > effective_cache_size = 65536    # typically 8KB each
> 
> I read somewhere that this should be set to half the system RAM
> size, 64k*8k=512m = 1/2 of the 1 Gig RAM.  I guess this is way
> off since you're saying that it's disk cache.  This agrees with
> the documentation.  I can't really rely on the (precious little
> Solaris postgres) info I find on the net....  ;)

I think you should rely on the Postgres documentation, which has way
fewer errors than just about any other technical documentation I've
ever seen.  Yes, it's disk cache.

I wouldn't set _anything_ to half the system RAM.  It'd be real nice
if your disk cache was half your RAM, but I'd be amazed if anyone's
system were that efficient.

It sounds like you need to follow Tom Lane's advice, though, and do
some profiling.

A
-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110




view thread (7+ messages)  latest in thread

Message-ID: <20030114141853.V5335@mail.libertyrms.com>
Permalink:  ../20030114141853.V5335@mail.libertyrms.com/
Also on:    postgresql.org/message-id/20030114141853.V5335@mail.libertyrms.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: andrew@libertyrms.info
  Subject: Re: Sun vs. Mac - best Postgres platform?
  In-Reply-To: <20030114141853.V5335@mail.libertyrms.com>
  References: <20030114133046.T5335@mail.libertyrms.com> <20030114190149.7293.qmail@web21104.mail.yahoo.com> <20030114141853.V5335@mail.libertyrms.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