pinker wrote:
> Laurenz Albe wrote
> > Yes, you should set vm.dirty_background_bytes and vm.dirty_bytes
> > and not use the *_ratio settings.
> >
> > 2 GB for vm.dirty_background_bytes and 1 GB for vm.dirty_bytes sounds
> > fine.
To repeat (for the archive): it should be the other way round.
>
On 2018-03-06 18:59:01 -0700, pinker wrote:
> Andres Freund wrote
> > With a halfway modern PG I'd suggest to rather tune postgres settings
> > that control flushing. That leaves files like temp sorting in memory for
> > longer, while flushing things controlledly for other sources of
> > writes.
Laurenz Albe wrote
> Yes, you should set vm.dirty_background_bytes and vm.dirty_bytes
> and not use the *_ratio settings.
>
> 2 GB for vm.dirty_background_bytes and 1 GB for vm.dirty_bytes sounds
> fine.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
Thank you
Andres Freund wrote
> With a halfway modern PG I'd suggest to rather tune postgres settings
> that control flushing. That leaves files like temp sorting in memory for
> longer, while flushing things controlledly for other sources of
> writes. See *_flush_after settings.
>
> Greetings,
>
> Andres
On 2018-03-06 03:23:29 -0700, pinker wrote:
> Hi,
> I've got cutomer with really huge RAM, now it's:
> total used free sharedbuffers cached
> Mem: 31021113052596 49515 2088019922961185
> -/+ buffers/cache: 904183011693
>
Tomas Vondra wrote:
> >
> > 2 GB for vm.dirty_background_bytes and 1 GB for vm.dirty_bytes sounds fine.
> >
>
> It should be the other way around: dirty_background_bytes < dirty_bytes
Of course, thanks for the correction.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
On 03/06/2018 01:16 PM, Laurenz Albe wrote:
> pinker wrote:
>> I've got cutomer with really huge RAM, now it's:
>> total used free sharedbuffers cached
>> Mem: 31021113052596 49515 2088019922961185
>> -/+ buffers/cache:
pinker wrote:
> I've got cutomer with really huge RAM, now it's:
> total used free sharedbuffers cached
> Mem: 31021113052596 49515 2088019922961185
> -/+ buffers/cache: 904183011693
> Swap: 8191 1
Hi,
I've got cutomer with really huge RAM, now it's:
total used free sharedbuffers cached
Mem: 31021113052596 49515 2088019922961185
-/+ buffers/cache: 904183011693
Swap: 8191 1 8190
(free -m)
and