Hi:
Our postgres database has tables with several million rows in a server
running Red Hat 8.0 with 1GB of memory. Recently we are experiencing a
low performance in the access to the server via HTTP, after rebooting
the server the speed is the same.
I have noticed that available memory is aparently too low, according to top:
12:58pm up 1:28, 3 users, load average: 0,00, 0,01, 0,09
94 processes: 91 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: 0,0% user, 0,0% system, 0,0% nice, 100,0% idle
Mem: 1031012K av, 1021440K used, 9572K free, 0K shrd, 62864K
buff
Swap: 2040244K av, 14960K used, 2025284K free 876808K
cached
Is it normal for Postgres to allocate almost all the memory in the computer?
Thanks in advance.
Ruben.
---------------------------(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 3 4859
On Sep 16, 2004, at 8:58 AM, ru*****@superguai.com wrote: I have noticed that available memory is aparently too low, according to top:
12:58pm up 1:28, 3 users, load average: 0,00, 0,01, 0,09 94 processes: 91 sleeping, 3 running, 0 zombie, 0 stopped CPU states: 0,0% user, 0,0% system, 0,0% nice, 100,0% idle Mem: 1031012K av, 1021440K used, 9572K free, 0K shrd, 62864K buff Swap: 2040244K av, 14960K used, 2025284K free 876808K cached
in the unix world, "free" memory is mostly useless because the OS will
give up various buffers it is using for caching if an app needs memory.
It is usually best to look at the output of free which will show you
how much of the memory is used by buffers & caches.
If that number is also low you should look to see how much memory your
applications are using.
Also, what are your shared_buffer and sort_mem settings set to in
postgresql.conf?
Remember in Linux top will include how much shared memory an app has
touched in its SIZE. (But you can also look at the shared column to see
how much of hte size is shared)
..
--
Jeff Trout <je**@jefftrout.com> http://www.jefftrout.com/ http://www.stuarthamm.net/
---------------------------(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
Thanks Jeff:
This is the output of free:
total used free shared buffers cached
Mem: 1031012 1018608 12404 0 64984 848160
-/+ buffers/cache: 105464 925548
Swap: 2040244 0 2040244
shared_buffers and sort_mem are both commented in postgresql.conf:
-bash-2.05b$ grep shared_buf data/postgresql.conf
#shared_buffers = 64 # 2*max_connections, min 16
-bash-2.05b$ grep sort_m data/postgresql.conf
#sort_mem = 512 # min 32
I have verified that postgres is not the responsible for the low
performance of the system, but I just wanted to be sure that memory
usage is reasonable in a postgres installation.
Ruben.
Jeff wrote: On Sep 16, 2004, at 8:58 AM, ru*****@superguai.com wrote:
I have noticed that available memory is aparently too low, according to top:
12:58pm up 1:28, 3 users, load average: 0,00, 0,01, 0,09 94 processes: 91 sleeping, 3 running, 0 zombie, 0 stopped CPU states: 0,0% user, 0,0% system, 0,0% nice, 100,0% idle Mem: 1031012K av, 1021440K used, 9572K free, 0K shrd, 62864K buff Swap: 2040244K av, 14960K used, 2025284K free 876808K cached
in the unix world, "free" memory is mostly useless because the OS will give up various buffers it is using for caching if an app needs memory. It is usually best to look at the output of free which will show you how much of the memory is used by buffers & caches.
If that number is also low you should look to see how much memory your applications are using.
Also, what are your shared_buffer and sort_mem settings set to in postgresql.conf? Remember in Linux top will include how much shared memory an app has touched in its SIZE. (But you can also look at the shared column to see how much of hte size is shared) .
-- Jeff Trout <je**@jefftrout.com> http://www.jefftrout.com/ http://www.stuarthamm.net/
---------------------------(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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
On Sep 16, 2004, at 11:26 AM, ruben wrote: Thanks Jeff:
This is the output of free:
total used free shared buffers cached Mem: 1031012 1018608 12404 0 64984 848160 -/+ buffers/cache: 105464 925548 Swap: 2040244 0 2040244
a vast majority of your ram is all in cache.
thats is good. It means the memory isn't being wasted.
shared_buffers and sort_mem are both commented in postgresql.conf:
-bash-2.05b$ grep shared_buf data/postgresql.conf #shared_buffers = 64 # 2*max_connections, min 16 -bash-2.05b$ grep sort_m data/postgresql.conf #sort_mem = 512 # min 32
that is an extremely small value of shared buffers.
you should set it to at least 1000, maybe even 10000.
You'll likely get a nice performance boost by increasing it.
I have verified that postgres is not the responsible for the low performance of the system, but I just wanted to be sure that memory usage is reasonable in a postgres installation.
Yes. It is fine, except I'd increase shared_buffers
--
Jeff Trout <je**@jefftrout.com> http://www.jefftrout.com/ http://www.stuarthamm.net/
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: N.K. |
last post by:
Hi, I've just installed postgres on the Linux server. It is supposed
to start automatically which I think it does since I can run an sql
stmt right away. When I'm trying to connect from a remote...
|
by: Gellert, Andre |
last post by:
Hello,
we installed a new Postgres 7.4.0 on a Suse 9 system.
This is used as a part of an extranet , based on Apache+PHP and has besides
a ldap
server no services running. The system has dual...
|
by: warwick.poole |
last post by:
I am interested in finding out about Enterprise scale Postgres
installations and clustering, especially on Linux.
Essentially I would like to know the possibility that Postgres can store
the...
|
by: Anony Mous |
last post by:
Hi,
We've got some clients that are concerned about running Postgresql 7.3.4 on
a Win2k Server box, alongside MS SQL Server. I've been running pg on my XP
machines for a long time now (with...
|
by: Prabu Subroto |
last post by:
Dear my friends...
Usually I use MySQL. Now I have to migrate my database
from MySQL to Postgres.
I have created a database successfully with "creatdb"
and a user account successfully.
But...
|
by: Joe Lester |
last post by:
This thread was renamed. It used to be: "shared_buffers Question". The
old thread kind of died out. I'm hoping to get some more direction by
rephrasing the problem, along with some extra...
|
by: Josh Close |
last post by:
I know this is kinda a debate, but how much ram do I give postgres?
I've seen many places say around 10-15% or some say 25%....... If all
this server is doing is running postgres, why can't I give...
|
by: micofarmer |
last post by:
We are running a PHP web-based frontend with a Postgres 7.2 backend on a Windows 2000 Server box with automated backups of the server being handled by Legato. We are experiencing several problems...
|
by: Jean-Paul Calderone |
last post by:
On Tue, 22 Apr 2008 14:54:37 -0700 (PDT), yzghan@gmail.com wrote:
The test doesn't demonstrate any leaks. It does demonstrate that memory
usage can remain at or near peak memory usage even after...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |