From: Josh Berkus <josh@agliodbs.com>
To: Matthew Nuzum <cobalt@bearfruit.org>
To: 'Pgsql-Performance' <pgsql-performance@postgresql.org>
Subject: Re: Caching (was Re: choosing the right platform)
Date: Wed, 9 Apr 2003 20:45:29 -0700
Message-ID: <200304092045.29503.josh@agliodbs.com> (raw)
In-Reply-To: <000601c2fefe$d4b07e80$6900a8c0@mattspc>
References: <000601c2fefe$d4b07e80$6900a8c0@mattspc>
Matthew,
> ** Postgres is multi-process, not multi-threaded (?)
Correct.
> ** It's better to not use huge amount of sort-mem but instead let the OS do
> the caching (?)
That's "don't use a huge amount of *shared_buffers*". Sort_mem is a different
setting. However, I have never seen a database use more than 32mb sort mem
in a single process, so I don't think the 2GB limit will hurt you much ...
> ** My needs are really not going to be as big as I think they are if I
> manage the application/environment correctly (?)
Your needs *per process*. Also, PostgreSQL is not as much of a consumer of
RAM as it is a consumer of disk I/O.
> * FreeBSD is going to provide a better file system than Linux (because
> Linux only supports large files on journaling filesystems which impose
> extra over head) (this gleaned from this conversation and previous threads
> in archives)
No, the jury is still out on this one. ReiserFS is optimized for small
files, and I've done well with it although some posters report stability
problems, though all second-hand. We hope to test this sometime in the
upcoming months.
--
Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, cobalt@bearfruit.org
Subject: Re: Caching (was Re: choosing the right platform)
In-Reply-To: <200304092045.29503.josh@agliodbs.com>
References: <000601c2fefe$d4b07e80$6900a8c0@mattspc> <200304092045.29503.josh@agliodbs.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