| From: | "Ricardo Ryoiti S(dot) Junior" <suga(at)netbsd(dot)com(dot)br> |
|---|---|
| To: | Nicolai Tufar <ntufar(at)apb(dot)com(dot)tr> |
| Cc: | Doug Fields <dfields-pg-general(at)pexicom(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Urgent need of (paid) PostgreSQL support in New |
| Date: | 2002-12-11 11:02:22 |
| Message-ID: | Pine.NEB.4.44.0212110857080.27069-100000@unix-svr01.interno |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ricardo Ryoiti S. Junior | 2002-12-11 11:08:41 | Re: Urgent need of (paid) PostgreSQL support in New |
| Previous Message | Shridhar Daithankar | 2002-12-11 11:00:23 | Re: Urgent need of (paid) PostgreSQL support in New |