When I ment memory allocation, I look with htop to see the process list, CPU
load, memory, swap. So I didn't ment the a postgre process uses that amount
of memory.
I read some tuning things, I made the things that are written there, but I
think that there improvements can be made.
regards,
Andy.
----- Original Message -----
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Andy" <[EMAIL PROTECTED]>
Cc: <pgsql-performance@postgresql.org>
Sent: Monday, October 10, 2005 5:18 PM
Subject: Re: [PERFORM] Server misconfiguration???
"Andy" <[EMAIL PROTECTED]> writes:
I get the feeling the server is somehow missconfigured or it does not
work at full parameter. If I look at memory allocation, it never goes
over 250MB whatever I do with the database.
That is not wrong. Postgres expects the kernel to be doing disk
caching, so the amount of memory that's effectively being used for
database work includes not only what is shown as belonging to the
PG processes, but some portion of the kernel disk buffers as well.
You don't really *want* the processes eating all of available RAM.
I concur with Chris K-L's comments that you should reduce rather
than increase your settings.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
