Re: Performance tuning for linux, 1GB RAM, dual CPU?

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 majordomo(at)postgresql(dot)org