public inbox for [email protected]  

help / color / mirror / Atom feed

From: Justin Clift <[email protected]>
To: Adam Manock <[email protected]>
Cc: [email protected]
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
Date: Thu, 12 Jul 2001 06:50:52 +1000
Message-ID: <[email protected]> (raw)
References: <5146853DD571D411AC54000102070D611C7F10@MINGBGNTS02>
	<5146853DD571D411AC54000102070D611C7F10@MINGBGNTS02>
	<[email protected]>

Hi Adam,

There are a few links to benchmark-type things you might find useful at
:

http://techdocs.postgresql.org/oresources.php#benchmark

Hope they're useful.

:-)

Regards and best wishes,

Justin Clift

Adam Manock wrote:
> 
>  >This is almost certainly a lousy idea.  You do *not* want to chew up all
>  >available memory for PG shared buffers; you should leave a good deal of
>  >space for kernel-level disk buffers.
> 
> I decided to start high on buffers because of Bruce's:
>         http://www.ca.postgresql.org/docs/hw_performance/
>  From that I get the impression that operations using kernel disk buffer
> cache are considerably more expensive than if the data was in shared
> buffer cache, and that increasing PG's memory usage until the system
> is almost using swap is The Right Thing To Do.  Has anyone got real
> world test data to confirm or refute this??
>     If not, then I am going to need to find or create a benchmarking program
> to load down PG against a fake multi-gigabyte "production" database.
> Or I could wait a week to see what RedHat does to tune their
> implementation of PG :-)
> 
> Adam
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to [email protected]

view thread (14+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox