Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lr8pb-0003ns-8z for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jun 2021 00:45:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lr8pZ-0003Aq-H4 for pgsql-performance@arkaria.postgresql.org; Thu, 10 Jun 2021 00:45:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lr8pZ-0003Ai-6z for pgsql-performance@lists.postgresql.org; Thu, 10 Jun 2021 00:45:57 +0000 Received: from mail-wr1-x436.google.com ([2a00:1450:4864:20::436]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lr8pS-0000fL-Ta for pgsql-performance@lists.postgresql.org; Thu, 10 Jun 2021 00:45:56 +0000 Received: by mail-wr1-x436.google.com with SMTP id l2so104478wrw.6 for ; Wed, 09 Jun 2021 17:45:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:date:subject:message-id :to; bh=S2L5qxJhuiA4W0UVPGmyscH1Qbs3+O9Mp0o3rU2Ki0A=; b=uduXRMycGpoZQlKWQDOjhj7s6iPfVXdjtYIFVgxQ+iDoZAXuJ1+3uRfRRiuc4RRFK3 eqmBD6zDg/50dQaYIrfXPx/551x0gFCBghatTV6UGJS9BVw9aVNp++4jyq1P1/F0fQHY blX6CES2ye5VMZWhVvhx3GA4WupuEJb3cxTwobFiO6t3zdlrEleioK4uKGuG7CI11tsM UQWOYI1pw+OmsOZaSEQk+DOFl1m2D1SyfZ+O3g25Ln0b9xL6bMA6wE/6MYiIZlJP+JqR pVJ4mcDbjqHLpNvyPSJ+RAQvWeXlOxGYUja3fI9LUouhjIRmNVeEIbfe667kLL+nHlIL rflg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version:date :subject:message-id:to; bh=S2L5qxJhuiA4W0UVPGmyscH1Qbs3+O9Mp0o3rU2Ki0A=; b=jhy/XSvuU+0eh0Dbg9L0dsovOttEVKUfjP58TNls3nHHJaZ+E07DNjIIYcN9bs1jtt w9eBxIafGuOSibIQiNhRgt+N/IYz5eRyLWtc98NUGhYWIqrce7rZ1pbdqvKeDHstX7Tn 3GtI2LCZ5A7UkS7PjfVeduWdILBTf/d0j+qNw9YA0W/5KAnimTNzG2m5HIrhpQFomEU8 Ng0GZpN2IZ8CKSW5GJSAu1wcRU4UCWgfPN9idKCyB1pNRT2S8n8cdwuTYOKBORCBBQW6 utG31GSYmyigv5FLIEeE+2hN5Lt8XkWz84CRh9aWQ3GW7R0dQ730p0yJzvzirNlIqS1r zABQ== X-Gm-Message-State: AOAM531QiuuFcOWkE6FVn6Wjdqbte7upr6Y67wQcwMhJDsNtdondBsOH SLONSSXSYtbJ7vWFsoT0hmSbt7+uUmE= X-Google-Smtp-Source: ABdhPJypdXzoDokkUtD34O3HDor1PHX+3J4FykSZn/XB8SXGTF5oybyx1IS6QLbew6hXyNOwGxdDtg== X-Received: by 2002:a5d:6a02:: with SMTP id m2mr2361435wru.77.1623285948429; Wed, 09 Jun 2021 17:45:48 -0700 (PDT) Received: from smtpclient.apple ([61.5.153.49]) by smtp.gmail.com with ESMTPSA id o7sm1513371wro.76.2021.06.09.17.45.47 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 09 Jun 2021 17:45:48 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-F42F0BF8-D364-4E1D-BCDE-EA628C1B62C2 Content-Transfer-Encoding: 7bit From: Haseeb Khan Mime-Version: 1.0 (1.0) Date: Thu, 10 Jun 2021 05:45:45 +0500 Subject: Page File Size Reached Critical Threshold PostgreSQL V13 Message-Id: To: pgsql-performance@lists.postgresql.org X-Mailer: iPhone Mail (18F72) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-F42F0BF8-D364-4E1D-BCDE-EA628C1B62C2 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello Everyone, I trust that everyone is Keep doing very Well ! We have installed PostgreSQL V13 on window=E2=80=99s server 2016, where we k= ept the Ram of the Server is 32 GB and disk size is 270 GB.Later we faced so= me performance issues regarding the database, after deep dive into it we cam= e up and increased the Shared buffer size to 16 Gb. After the changed I am n= ot sure we are facing that Page file Size reached to critical threshold. Cur= rently the Page File size is 9504MB. Highly Appreciated, if you guys could recommend/suggest any solution / idea.= Br, Haseeb Ahmad= --Apple-Mail-F42F0BF8-D364-4E1D-BCDE-EA628C1B62C2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello Everyone,

I trust t= hat everyone is Keep doing very Well !

=
We have installed PostgreSQL V13 on window=E2=80=99s server 2016,= where we kept the Ram of the Server is 32 GB and disk size is 270 GB.Later w= e 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 chan= ged I am not sure we are facing that Page file Size reached to critical thre= shold. Currently the Page File size is 9504MB.

High= ly Appreciated, if you guys could recommend/suggest any solution / idea.

Br,
Haseeb Ahmad
= --Apple-Mail-F42F0BF8-D364-4E1D-BCDE-EA628C1B62C2--