Postgres Pro
Downloads
Home   >   mailing lists

Page File Size Reached Critical Threshold PostgreSQL V13 - Mailing list pgsql-performance

From Haseeb Khan
Subject Page File Size Reached Critical Threshold PostgreSQL V13
Date
Msg-id A78AAC7E-75F0-4B44-ADCF-BCE522228ABA@gmail.com
Whole thread Raw
Responses Re: Page File Size Reached Critical Threshold PostgreSQL V13  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view
Hello Everyone,

I trust that everyone is Keep doing very Well !

We have installed PostgreSQL V13 on window’s server 2016, where we kept the Ram of the Server is 32 GB and disk size is 270 GB.Later we faced some performance issues regarding the database, after deep dive into it we came up and increased the Shared buffer size to 16 Gb. After the changed I am not sure we are facing that Page file Size reached to critical threshold. Currently the Page File size is 9504MB.

Highly Appreciated, if you guys could recommend/suggest any solution / idea.

Br,
Haseeb Ahmad

pgsql-performance by date:

Previous
From: Ayub Khan
Date:
Subject: Re: slow query
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: AWS forcing PG upgrade from v9.6 a disaster