Tune Postgresql

Hi Mats,

> On 12 Sep 2017, at 12:00 am, omnisdev-en-request@lists.omnis-dev.com wrote:
>
> I have read tons of instructions how to tune Postgresql, but I still do not get it.
>
> Then I stumbled over this ?calculator?:
>
> pgtune.leopard.in.ua <pgtune.leopard.in.ua/>
>
> Anybody that can confirm that this is a good way to start? Or have another calculator?
>
> /Mats

I tried one similar. I compared it’s output with the default postgresql.conf file that we were using, and then researched the parameters that were changed.

In the end we went with most of the recommendations. We hit a problem in that we were using replication for a hot standby backup, and we needed to apply the same settings to the backup too, otherwise replication would drop out because the backup server wasn’t keeping up with the main server.

Regards,
Paul.

You can’t have everything; where would you put it?
bit.ly/17HOqAI
—
Paul W. Mulroney We Don’t Do Simple Pty Ltd
pmulroney@logicaldevelopments.com.au Trading as Logical Developments
www.logicaldevelopments.com.au ACN 161 009 374
Ph: +61 8 9458 3889 86 Coolgardie Street
BENTLEY WA 6102

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com