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 <val...@gmail.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
