| From: | J B <mrjanbernat(at)gmail(dot)com> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org |
| Subject: | Re: WAL settings |
| Date: | 2018-02-14 15:09:37 |
| Message-ID: | CA+-SBAVBiU0vw+a8FC4cb9JZ1FRZGuM9drN-g3XuAtM5pXXBVQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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(at)a-kretschmer(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Froehlich | 2018-02-14 21:47:07 | RE: Bitmap Heap Scan taking ~60x as long for table when queried as partition |
| Previous Message | Andreas Kretschmer | 2018-02-14 12:50:23 | Re: WAL settings |