Re: Urgent need of (paid) PostgreSQL support in New

From: "Nicolai Tufar" <ntufar(at)apb(dot)com(dot)tr>
To: "Ricardo Ryoiti S(dot) Junior" <suga(at)netbsd(dot)com(dot)br>, "Doug Fields" <dfields-pg-general(at)pexicom(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Urgent need of (paid) PostgreSQL support in New
Date: 2002-12-11 10:52:34
Message-ID: 028901c2a103$69998dc0$8016a8c0@apb.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

----- Original Message -----
From: "Doug Fields" <dfields-pg-general(at)pexicom(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-12-11 11:00:23 Re: Urgent need of (paid) PostgreSQL support in New
Previous Message Han Holl 2002-12-11 10:41:27 Re: Postgresql and Ruby - any opensource software done with these two ?