[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: Re: [PERFORM] [GENERAL] Memory issues
From: Shiran Kleiderman <shirank1 () gmail ! com>
Date: 2012-09-26 22:01:19
Message-ID: CAGYUkGUYnwMU3aY2_uaszRZ_SEFm0ZYhic-+VdLu20-pL-VDsA () mail ! gmail ! com
[Download RAW message or body]
Hi
Another thing that may help,
When I restart the postgres db, then I have a little bit of "grace" time
(the memory free field is also lifted a bit).
I can run the crons and then after an hour or two the status returns to
regular... "out of memory" errors.
Thanks!
On Wed, Sep 26, 2012 at 11:36 PM, Shiran Kleiderman <shirank1@gmail.com>wrote:
> Hi
> I contact amazon with this issue.
> What can I check for the fragmented memory issue?
>
> Thanks (:
>
>
> On Wed, Sep 26, 2012 at 11:11 PM, Scott Marlowe <scott.marlowe@gmail.com>wrote:
>
>> OK then I'm lost. It's got to either be a bug in how amazon ec2
>> instances work or severely fragmented memory because you've got a TON
>> of kernel cache available.
>>
>> On Wed, Sep 26, 2012 at 3:00 PM, Shiran Kleiderman <shirank1@gmail.com>
>> wrote:
>> > Hi
>> > Yes, same machine.
>> >
>> > Thanks for your help.
>> >
>> >
>> > On Wed, Sep 26, 2012 at 10:55 PM, Scott Marlowe <
>> scott.marlowe@gmail.com>
>> > wrote:
>> >>
>> >> On Wed, Sep 26, 2012 at 10:41 AM, Shiran Kleiderman <
>> shirank1@gmail.com>
>> >> wrote:
>> >> > Hi
>> >> > Thanks again.
>> >> > Right now, this is free -m and ps aux and non of the crons can run -
>> >> > can't
>> >> > allocate memory.
>> >>
>> >> OK, so is the machine you're running free -m on the same as the one
>> >> running postgresql and the same one you're running cron jobs on and
>> >> the same one you're running apache on?
>> >>
>> >> Also please don't remove the cc for the list, others might have an
>> >> insight I'd miss.
>> >>
>> >> > cif@domU-12-31-39-08-06-20:~$ free -m
>> >> > total used free shared buffers
>> >> > cached
>> >> > Mem: 17079 12051 5028 0 270
>> >> > 9578
>> >> > -/+ buffers/cache: 2202 14877
>> >> > Swap: 511 0 511
>> >> >
>> >
>> >
>> >
>> >
>> > --
>> > Best,
>> > Shiran Kleiderman
>> > +972 - 542380838
>> > Skype - shirank1
>> >
>>
>>
>>
>> --
>> To understand recursion, one must first understand recursion.
>>
>
>
>
> --
> Best,
> Shiran Kleiderman
> +972 - 542380838
> Skype - shirank1
>
>
--
Best,
Shiran Kleiderman
+972 - 542380838
Skype - shirank1
[Attachment #3 (text/html)]
<div dir="ltr">Hi<div>Another thing that may help,</div><div>When I restart the \
postgres db, then I have a little bit of "grace" time (the memory free \
field is also lifted a bit).</div><div>I can run the crons and then after an hour or \
two the status returns to regular... "out of memory" errors.</div> \
<div><br></div><div>Thanks!</div><div><br><br><div class="gmail_quote">On Wed, Sep \
26, 2012 at 11:36 PM, Shiran Kleiderman <span dir="ltr"><<a \
href="mailto:shirank1@gmail.com" target="_blank">shirank1@gmail.com</a>></span> \
wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div dir="ltr">Hi<div>I contact amazon with this \
issue.</div><div>What can I check for the fragmented memory issue?</div> \
<div><br></div><div>Thanks (:<div><div class="h5"><br><br><div class="gmail_quote">On \
Wed, Sep 26, 2012 at 11:11 PM, Scott Marlowe <span dir="ltr"><<a \
href="mailto:scott.marlowe@gmail.com" \
target="_blank">scott.marlowe@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">OK then I'm lost. It's got to either be a bug in how \
amazon ec2<br> instances work or severely fragmented memory because you've got a \
TON<br> of kernel cache available.<br>
<div><div><br>
On Wed, Sep 26, 2012 at 3:00 PM, Shiran Kleiderman <<a \
href="mailto:shirank1@gmail.com" target="_blank">shirank1@gmail.com</a>> \
wrote:<br> > Hi<br>
> Yes, same machine.<br>
><br>
> Thanks for your help.<br>
><br>
><br>
> On Wed, Sep 26, 2012 at 10:55 PM, Scott Marlowe <<a \
href="mailto:scott.marlowe@gmail.com" \
target="_blank">scott.marlowe@gmail.com</a>><br> > wrote:<br>
>><br>
>> On Wed, Sep 26, 2012 at 10:41 AM, Shiran Kleiderman <<a \
href="mailto:shirank1@gmail.com" target="_blank">shirank1@gmail.com</a>><br> \
>> wrote:<br> >> > Hi<br>
>> > Thanks again.<br>
>> > Right now, this is free -m and ps aux and non of the crons can run \
-<br> >> > can't<br>
>> > allocate memory.<br>
>><br>
>> OK, so is the machine you're running free -m on the same as the one<br>
>> running postgresql and the same one you're running cron jobs on and<br>
>> the same one you're running apache on?<br>
>><br>
>> Also please don't remove the cc for the list, others might have an<br>
>> insight I'd miss.<br>
>><br>
>> > cif@domU-12-31-39-08-06-20:~$ free -m<br>
>> > total used free shared buffers<br>
>> > cached<br>
>> > Mem: 17079 12051 5028 0 270<br>
>> > 9578<br>
>> > -/+ buffers/cache: 2202 14877<br>
>> > Swap: 511 0 511<br>
>> ><br>
><br>
><br>
><br>
><br>
> --<br>
> Best,<br>
> Shiran Kleiderman<br>
> <a href="tel:%2B972%20%C2%A0-%20542380838" value="+972542380838" \
target="_blank">+972 - 542380838</a><br> > Skype - shirank1<br>
><br>
<br>
<br>
<br>
</div></div><span><font color="#888888">--<br>
To understand recursion, one must first understand recursion.<br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div \
dir="ltr"><font face="'courier new', monospace"><div><font face="'courier \
new', monospace">Best,</font></div>Shiran Kleiderman</font><div dir="ltr">
<font face="'courier new', monospace"><a \
href="tel:%2B972%20%C2%A0-%20542380838" value="+972542380838" target="_blank">+972 - \
542380838</a></font></div><div dir="ltr"><div><font face="'courier new', \
monospace">Skype - shirank1</font></div> </div><div></div></div><br>
</div></div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><font \
face="'courier new', monospace"><div><font face="'courier new', \
monospace">Best,</font></div>Shiran Kleiderman</font><div dir="ltr"> <font \
face="'courier new', monospace">+972 - 542380838</font></div><div \
dir="ltr"><div><font face="'courier new', monospace">Skype - \
shirank1</font></div></div><div></div></div><br> </div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic