| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | <michael(dot)mattox(at)verideon(dot)com> |
| Cc: | "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Version 7 question |
| Date: | 2003-07-01 18:01:54 |
| Message-ID: | pfi3gv4ka660h1g8nnbrd19mir21m7lv3v@4ax.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 1 Jul 2003 15:02:21 +0200, "Michael Mattox"
<michael(dot)mattox(at)verideon(dot)com> wrote:
>I have 1.5 gigs of RAM on my
>server but I'm also running a few other java programs that take up probably
>500 megs total of memory, leaving me 1gig for Postgres. Should I set my
>shared buffers to be 25% of 1gig? That would be 32768. Then what should my
>effective cache be? Right now I have it set to 64000 which would be
>512megs. Between the buffers and cache that'd be a total of 768megs,
>leaving approximately 768 for my other java apps & the OS.
Michael, by setting effective_cache_size you do not allocate anything.
This configuration variable is just a *hint* to the planner how much
RAM is used for caching on your system (as shown by top or free).
Servus
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-07-01 18:22:13 | Re: Effective Cache Size |
| Previous Message | scott.marlowe | 2003-07-01 14:22:28 | Re: Version 7 question |