Hello, Peter.
> Can you reliably crash the server by running "select count(*) from
pg_buffercache where isdirty" from psql?
No.
I run from psql and get answer:
# select count(*) from
pg_buffercache where isdirty;
count
-------
71
(1 row)
> What work_mem setting does Postgres have when Zabbix runs this query?
work_mem=64MB
16.04.2018, 21:35, "Peter Geoghegan" <pg@bowt.ie>:
> On Mon, Apr 16, 2018 at 11:05 AM, Vitaly V. Voronov <wizard_1024@tut.by> wrote:
>> Hello, Peter.
>>
>> Pgpool used only from App side at another server.
>>
>> Zabbix running its queries directly at database server.
>
> Can you reliably crash the server by running "select count(*) from
> pg_buffercache where isdirty" from psql?
>
> What work_mem setting does Postgres have when Zabbix runs this query?
>
> --
> Peter Geoghegan
