Re: shared_buffers 8GB maximum

From: Vitaliy Garnashevich <vgarnashevich(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: shared_buffers 8GB maximum
Date: 2018-02-19 12:46:36
Message-ID: 606988bd-9ec1-d15f-4bed-e50fa6053cc5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> When we did calculation of some analytic tasks, then increasing
> shared_buffers had negative impact on speed. Probably hit ration was
> too low after change, but the maintenance of shared buffers (searching
> free blocks) was slower.

What was the size of shared buffers when slowdown happened (approximately)?

Regards,
Vitaliy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Steele 2018-02-19 14:18:59 Re: pgBackRest backup from standby
Previous Message Vitaliy Garnashevich 2018-02-19 12:37:43 Re: shared_buffers 8GB maximum