----- 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