Re: Urgent need of (paid) PostgreSQL support in New - Mailing list pgsql-general

    Hi,

On Wed, 11 Dec 2002, Nicolai Tufar wrote:

> > We have 8GB RAM. I've allocated about 700 megs to shared memory. The rest
> > is buffer cached by the O/S. I can't afford a 32 gig server as 2 gig RAM
> > modules are exorbitantly expensive. The database won't fit into RAM
> anyway.

> OS caching is generally considered a waste of resource in databases.
> Try to allocate as much as possible to shared buffers and set OS caching
> to minimum.

    Hmm, in a lower priority level, It's also nice to see how much
sort_mem you have, mainly if you sort selects returning large number of
tuples. However, his problem seems to be more tricky than these details.
:)

    []'s
    Ricardo.