On Fri, 14 Aug 2009, Scott Carey wrote:
The memory used by postgres for shared memory is the largest of all SHR
columns for postgres columns. Or, about 7.9GB. So, postgres is using
about 7.9GB for shared memory, and very little for anything else.
It's a good idea to check this result agains
On 8/17/09 4:43 PM, "Scott Carey" wrote:
>
>
> On 8/17/09 10:24 AM, "Jeremy Carroll"
> wrote:
>
>> I believe this is exactly what is happening. I see that the TOP output lists
>> a
>> large amount ov VIRT & RES size being used, but the kernel does not report
>> this memory as being reserved
On 8/17/09 10:24 AM, "Jeremy Carroll"
wrote:
> I believe this is exactly what is happening. I see that the TOP output lists a
> large amount ov VIRT & RES size being used, but the kernel does not report
> this memory as being reserved and instead lists it as free memory or cached.
Oh! I reca
I believe this is exactly what is happening. I see that the TOP output lists a
large amount ov VIRT & RES size being used, but the kernel does not report this
memory as being reserved and instead lists it as free memory or cached.
If this is indeed the case, how does one determine if a PostgreSQ
On Sat, 15 Aug 2009, Mark Mielke wrote:
I vote for screwed up reporting over some PostgreSQL-specific explanation. My
understanding of RSS is the same as you suggested earlier - if 50% RAM is
listed as resident, then there should not be 90%+ RAM free. I cannot think of
anything PostgreSQL might
On Fri, Aug 14, 2009 at 3:43 PM, Reid Thompson wrote:
> On Fri, 2009-08-14 at 14:00 -0400, Jeremy Carroll wrote:
>> I am confused about what the OS is reporting for memory usage on
>> CentOS 5.3 Linux. Looking at the resident memory size of the
>> processes. Looking at the resident size of all post
nd it showed a large RSS, but it did NOT show free memory.
Cheers,
mark
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Saturday, August 15, 2009 10:25 AM
To: Jeremy Carroll
Cc: Scott Carey; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Memory reporting on
org
Subject: Re: [PERFORM] Memory reporting on CentOS Linux
Jeremy Carroll writes:
> I am thoroughly confused that TOP is reporting that I have 99% of my
> physical RAM free, while the process list suggests that some are
> taking ~8Gb of Resident (Physical) Memory. Any explanation as to why
&g
Jeremy Carroll writes:
> I am thoroughly confused that TOP is reporting that I have 99% of my
> physical RAM free, while the process list suggests that some are
> taking ~8Gb of Resident (Physical) Memory. Any explanation as to why
> TOP is reporting this? I have a PostgreSQL 8.3 server with 48Gb
[mailto:sc...@richrelevance.com]
Sent: Friday, August 14, 2009 3:38 PM
To: Jeremy Carroll; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Memory reporting on CentOS Linux
On 8/14/09 11:00 AM, "Jeremy Carroll"
wrote:
> I am confused about what the OS is reporting for memory usag
On 8/14/09 11:00 AM, "Jeremy Carroll"
wrote:
> I am confused about what the OS is reporting for memory usage on CentOS 5.3
> Linux. Looking at the resident memory size of the processes. Looking at the
> resident size of all postgres processes, the system should be using around
> 30Gb of physical
I'm betting it's shared_buffers that have been swapped out (2G swapped
out on his machine) for kernel cache.The RES and SHR being the
same says the actual processes are using hardly any ram, just hitting
shared_buffers.
On Fri, Aug 14, 2009 at 2:20 PM, Jeremy
Carroll wrote:
> But the kernel ca
On Fri, Aug 14, 2009 at 12:00 PM, Jeremy
Carroll wrote:
> I am confused about what the OS is reporting for memory usage on CentOS 5.3
> Linux. Looking at the resident memory size of the processes. Looking at the
> resident size of all postgres processes, the system should be using around
> 30Gb of
But the kernel can take back any of the cache memory if it wants to. Therefore
it is free memory.
This still does not explain why the top command is reporting ~9GB of resident
memory, yet the top command does not suggest that any physical memory is being
used.
On 8/14/09 2:43 PM, "Reid Thomps
On Fri, 2009-08-14 at 14:00 -0400, Jeremy Carroll wrote:
> I am confused about what the OS is reporting for memory usage on
> CentOS 5.3 Linux. Looking at the resident memory size of the
> processes. Looking at the resident size of all postgres processes, the
> system should be using around 30Gb of
I am confused about what the OS is reporting for memory usage on CentOS 5.3
Linux. Looking at the resident memory size of the processes. Looking at the
resident size of all postgres processes, the system should be using around 30Gb
of physical ram. I know that it states that it is using a lot of
16 matches
Mail list logo
