Re: BUG #6186: out of memory while analyze

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