Hello,
/proc/sys/vm/swappiness =3D 60
/proc/sys/vm/overcommit_memory =3D 0
/proc/sys/vm/overcommit_ratio =3D 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@gmail.com>:
>>
>> ssl =3D false
>> shared_buffers =3D 900MB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0# min 128kB
>> work_mem =3D 100MB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0# min 64kB
>> maintenance_work_mem =3D 524MB =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
# min 1MB
>> fsync =3D off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 # turns forced synchronization on
>> or off
>> synchronous_commit =3D off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0# immediate fsync at commit
>> full_page_writes =3D off =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0# recover from partial page writes
>> effective_cache_size =3D 1GB
>> default_statistics_target =3D 8000 =C2=A0 =C2=A0 =C2=A0 =C2=A0# range 1-=
10000
>>
>>
>> Also tried change maintenance_work_mem to 2G and same result.
>> Imposible to set over 2GB (FATAL: =C2=A03145728 is outside the valid ran=
ge
>> 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 shou=
ld
> not be too close to each other.
> What are the values
> for=C2=A0/proc/sys/vm/swappiness,=C2=A0/proc/sys/vm/overcommit_memory
> and=C2=A0/proc/sys/vm/overcommit_ratio? What is your swap size. They all
> influence=C2=A0CommitLimit and the amount of memory, you can get.
> -- Valentin
>
>
--=20
Lampa
