Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL settings - Mailing list pgsql-novice

From J B
Subject Re: WAL settings
Date
Msg-id CA+-SBAVBiU0vw+a8FC4cb9JZ1FRZGuM9drN-g3XuAtM5pXXBVQ@mail.gmail.com
Whole thread Raw
In response to Re: WAL settings  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses RE: WAL settings  (Stephen Froehlich <s.froehlich@cablelabs.com>)
List pgsql-novice
Tree view
Wow thank you, i checked that this was commented out in 9.4 but with setting = 0, but 10.1 has this commented with = 10 so i assume its default value.

2018-02-14 13:50 GMT+01:00 Andreas Kretschmer <andreas@a-kretschmer.de>:


Am 14.02.2018 um 13:33 schrieb J B:
Hello

I have an issue with WAL settings with postgress 10.1 used for zabbix monitoring system. When i change WAL setting to "minimal" the database goes down. We used this setting in version 9.4 to improve performance of our monitoring server so i would like to replicate this setting.



 you have to set max_wal_senders to 0.


Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: WAL settings
Next
From: Stephen Froehlich
Date:
Subject: RE: Bitmap Heap Scan taking ~60x as long for table when queried aspartition