Re: Page File Size Reached Critical Threshold PostgreSQL V13

2021-06-10 Thread Justin Pryzby
Please work through the Slow Query wiki page and try to provide as much information as possible. It's too hard to try to help if each communication includes only a fraction of the requested information. On Thu, Jun 10, 2021 at 04:33:51PM +0500, Haseeb Khan wrote: > PFB the query and there are man

Re: Page File Size Reached Critical Threshold PostgreSQL V13

2021-06-10 Thread Justin Pryzby
On Thu, Jun 10, 2021 at 11:41:09AM +0500, Haseeb Khan wrote: > You mean, So should I request for to increase the System Ram from 32 Gb to 64 > Gb and keep the same parameter setting.Is it ? No - I don't know how large your DB is, or the other question that I asked. So I can't possibly make a sugg

Re: Page File Size Reached Critical Threshold PostgreSQL V13

2021-06-09 Thread Haseeb Khan
Hi Justin, You mean, So should I request for to increase the System Ram from 32 Gb to 64 Gb and keep the same parameter setting.Is it ? Br, Haseeb Ahmad > > On 10-Jun-2021, at 9:28 AM, Justin Pryzby wrote: > > On Thu, Jun 10, 2021 at 05:45:45AM +0500, Haseeb Khan wrote: >> We have install

Re: Page File Size Reached Critical Threshold PostgreSQL V13

2021-06-09 Thread Justin Pryzby
On Thu, Jun 10, 2021 at 05:45:45AM +0500, Haseeb Khan wrote: > 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 > an

Page File Size Reached Critical Threshold PostgreSQL V13

2021-06-09 Thread Haseeb Khan
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 in