By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,259 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

Better Unilization of Memory

P: n/a

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?

If not, how can I better utilize my RAM during
queries and or general processing?

Thanks for your help!
Lynn Tilby
lt****@asu.edu

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ly********@asu.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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #2

P: n/a

Doug,

Thanks... Looks like I need to do some tuning!
Lynn

Quoting Doug McNaught <do**@mcnaught.org>:
Ly********@asu.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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #3

P: n/a

Doug,

Thanks... Looks like I need to do some tuning!
Lynn

Quoting Doug McNaught <do**@mcnaught.org>:
Ly********@asu.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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.