Skip site navigation (1) Skip section navigation (2)

Re: BUG #6186: out of memory while analyze

From: Lampa <lampacz(at)gmail(dot)com>
To: Valentine Gogichashvili <valgog(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6186: out of memory while analyze
Date: 2011-09-01 09:59:02
Message-ID: CAG_XuNVMk6Z3DVSY964sxSAjgVRXvFTozvTgLqPJ8Utsv7xfYA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello,

/proc/sys/vm/swappiness = 60
/proc/sys/vm/overcommit_memory = 0
/proc/sys/vm/overcommit_ratio = 50

             total       used       free     shared    buffers     cached
Mem:          4038       3146        892          0         30       3067
-/+ buffers/cache:         49       3989
Swap:         8581          0       8581



2011/9/1 Valentine Gogichashvili <valgog(at)gmail(dot)com>:
>>
>> ssl = false
>> shared_buffers = 900MB                  # min 128kB
>> work_mem = 100MB                                # min 64kB
>> maintenance_work_mem = 524MB            # min 1MB
>> fsync = off                             # turns forced synchronization on
>> or off
>> synchronous_commit = off                # immediate fsync at commit
>> full_page_writes = off                  # recover from partial page writes
>> effective_cache_size = 1GB
>> default_statistics_target = 8000        # range 1-10000
>>
>>
>> Also tried change maintenance_work_mem to 2G and same result.
>> Imposible to set over 2GB (FATAL:  3145728 is outside the valid range
>> for parameter "maintenance_work_mem" (1024 .. 2097151))
>>
>
> Actually, it also can be, that your commit limit is reached. Can you also
> look in the /proc/meminfo -> CommitLimit and Commit_AS. These values should
> not be too close to each other.
> What are the values
> for /proc/sys/vm/swappiness, /proc/sys/vm/overcommit_memory
> and /proc/sys/vm/overcommit_ratio? What is your swap size. They all
> influence CommitLimit and the amount of memory, you can get.
> -- Valentin
>
>



-- 
Lampa

In response to

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2011-09-01 11:27:07
Subject: ECPGdo fails to restore LC_NUMERIC
Previous:From: Valentine GogichashviliDate: 2011-09-01 09:48:18
Subject: Re: BUG #6186: out of memory while analyze

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group