Postgres Pro
Downloads
Home   >   mailing lists

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

From Nicolai Tufar
Subject Re: Urgent need of (paid) PostgreSQL support in New
Date
Msg-id 028901c2a103$69998dc0$8016a8c0@apb.com.tr
Whole thread Raw
In response to Urgent need of (paid) PostgreSQL support in New York City area  (Doug Fields <dfields-pg-general@pexicom.com>)
Responses Re: Urgent need of (paid) PostgreSQL support in New  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: Urgent need of (paid) PostgreSQL support in New  ("Ricardo Ryoiti S. Junior" <suga@netbsd.com.br>)
List pgsql-general
Tree view 
----- Original Message -----
From: "Doug Fields" <dfields-pg-general@pexicom.com>
>
> 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.

Regards,
Nic

pgsql-general by date:

Previous
From: Han Holl
Date:
Subject: Re: Postgresql and Ruby - any opensource software done with these two ?
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Urgent need of (paid) PostgreSQL support in New