From: | Lynn(dot)Tilby(at)asu(dot)edu |
---|---|
To: | Doug McNaught <doug(at)mcnaught(dot)org> |
Cc: | Lynn(dot)Tilby(at)asu(dot)edu, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Better Unilization of Memory |
Date: | 2003-11-18 20:54:51 |
Message-ID: | 1069188891.3fba871b40e5f@webmail.asu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Doug,
Thanks... Looks like I need to do some tuning!
Lynn
Quoting Doug McNaught <doug(at)mcnaught(dot)org>:
> Lynn(dot)Tilby(at)asu(dot)edu writes:
>
> > In looking at top, I have noticed when doing some
> > long queries that RAM memory is only being used
> > at 1-3%. While, CPU often jumps to 97, 98, even
> > 99% utilization (which is great!).
> >
> > Is this normal for RAM utilization?
>
> It depends on what you have set shared_buffers to in your
> postgresql.conf file. If you have not tuned this value yet you should
> do so as the default setting is very conservative.
>
> There is a lot of discussion on appropriate shared_buffers settings if
> you search the mailing list archives...
>
> -Doug
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Murtagh | 2003-11-18 21:00:54 | 7.4RC2 vs 7.4 |
Previous Message | Mike Mascari | 2003-11-18 20:54:09 | Re: SQL text of view |