Re: Memory issues - Mailing list pgsql-general
| From | Shiran Kleiderman |
|---|---|
| Subject | Re: Memory issues |
| Date | |
| Msg-id | CAGYUkGVsrZ0iqXEdX5D4seYg-=bJuZGZyrOL7WZh5gL=9A5wrw@mail.gmail.com Whole thread Raw |
| In response to | Re: Memory issues (Andres Freund <andres@2ndquadrant.com>) |
| Responses |
Mapping PostgreSQL data types to DB2 Federated Server
("Alexander Gataric" <gataric@usa.net>)
Re: Memory issues (Shiran Kleiderman <shirank1@gmail.com>) |
| List | pgsql-general |
Hi
--
I've returned the memory configs to the default, erased data from my db and am testing the system again.
This is the output of cat /proc/meminfo
Thanks
root@ip-10-194-167-240:~# cat /proc/meminfo
MemTotal: 7629508 kB
MemFree: 170368 kB
Buffers: 10272 kB
Cached: 6220848 kB
SwapCached: 0 kB
Active: 3249748 kB
Inactive: 3936960 kB
Active(anon): 971336 kB
Inactive(anon): 2103844 kB
Active(file): 2278412 kB
Inactive(file): 1833116 kB
Unevictable: 0 kB
Mlocked: 0 kB
SwapTotal: 524284 kB
SwapFree: 522716 kB
Dirty: 83068 kB
Writeback: 3080 kB
AnonPages: 955856 kB
Mapped: 2132564 kB
Shmem: 2119424 kB
Slab: 157200 kB
SReclaimable: 144488 kB
SUnreclaim: 12712 kB
KernelStack: 1184 kB
PageTables: 21092 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 4339036 kB
Committed_AS: 3637424 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 26152 kB
VmallocChunk: 34359710052 kB
HardwareCorrupted: 0 kB
AnonHugePages: 0 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 7872512 kB
DirectMap2M: 0 kB
On Thu, Sep 27, 2012 at 8:59 AM, Andres Freund <andres@2ndquadrant.com> wrote:
On Monday, September 24, 2012 08:45:06 AM Shiran Kleiderman wrote:> *Ubuntu 12, High-Memory Extra Large Instance
> Hi,
> I'm using and Amazon ec2 instance with the following spec and the
> application that I'm running uses a postgres DB 9.1.
> The app has 3 main cron jobs.
>> 17.1 GB of memory> 64-bit platform*
> 6.5 EC2 Compute Units (2 virtual cores with 3.25 EC2 Compute Units each)
> 420 GB of instance storage
>
> I've changed the main default values under file *postgresql.conf* to:> shared_buffers = 4GB> total used *free* shared buffers cached
> work_mem = 16MB
> wal_buffers = 16MB
> checkpoint_segments = 32
> effective_cache_size = 8GB
>
> When I run the app, after an hour or two, free -m looks like below ans the
> crons can't run due to memory loss or similar (i'm new to postgres and db
> admin).
> Thanks!
>
> free -m, errors:
>
> total used free shared buffers cached
> Mem: 17079 13742 3337 0 64 11882
> -/+ buffers/cache: 1796 15283
> Swap: 511 0 511
>
> Mem: 17079 16833 *245 *0 42 14583> -/+ buffers/cache: 2207 14871> *DBI connect('database=---;host=localhost','postgres',...) failed: could
> Swap: 511 0 511
>
> **free above stays low even when nothing is running.
>
> **errors:
> not fork new process for connection: Cannot allocate memory*> could not fork new process for connection: Cannot allocate memorycould you show cat /proc/meminfo?
>
> and
> execute failed: ERROR: out of memory
> DETAIL: Failed on request of size 968. [for Statement "
> SELECT DISTINCT....
Greetings,
Andres
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
Best,
Shiran Kleiderman+972 - 542380838
Skype - shirank1
pgsql-general by date: