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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1kndVy-0005JA-1z
	for pgsql-admin@arkaria.postgresql.org; Fri, 11 Dec 2020 08:10:58 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1kndVw-0005Oy-Ur
	for pgsql-admin@arkaria.postgresql.org; Fri, 11 Dec 2020 08:10:56 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <akumar14871@gmail.com>)
	id 1kndVw-0005Or-Kp
	for pgsql-admin@lists.postgresql.org; Fri, 11 Dec 2020 08:10:56 +0000
Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <akumar14871@gmail.com>)
	id 1kndVt-0004ST-8g
	for pgsql-admin@postgresql.org; Fri, 11 Dec 2020 08:10:55 +0000
Received: by mail-wr1-x42b.google.com with SMTP id c5so4436343wrp.6
        for <pgsql-admin@postgresql.org>;
 Fri, 11 Dec 2020 00:10:52 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:from:date:message-id:subject:to;
        bh=qnTxMkz5nMrDRygKgqPmZJdqjZadB3kMhQ+/c/4/3PQ=;
        b=sri8+THSJwqPYrEI9gT3kLEJmQZk0w853uO0by8W0Voh0qcRfwHaqMBrQBzpicMTTq
         FTbZOya1gN7Y9C0LqJ3Go55v90T7vvfw7vlgdvxDCPFCXrSuRNWOGuLt8yjGLCQKfPEZ
         bi5rPKm2yhCUOHE7dF4GN5D8DxY5N/zgeuEw2jGEjOlcjbb2HmSxViPillj+94LuX6ZD
         Bmw3ziNkQWS6YIUWFIOjUdwWRPr+UYBHLcJhMGlY6BLgF8hD8hj9KNgwWJbpxQob58b9
         XoV0b2GAIpUgBKSO43D+yQJ0Uj5EMlVNnG4bZ/r07HAa56Z25v4Gcm3xtHb2BqBlZvbs
         4LMA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:from:date:message-id:subject:to;
        bh=qnTxMkz5nMrDRygKgqPmZJdqjZadB3kMhQ+/c/4/3PQ=;
        b=MgIy8HQmAC/SCeh2OQgQtKIh/e6SrSDBEY8Hr9PMd24SNjo6efxcnbijwbLqFAfXcx
         F4WUpttcxx1j36ogN9fNarArLkIN4Qqp5resGEyelM3POS4LEiQoi9PV5Tdi+hMwkEC6
         AmG4lYEaSgrOQKfkmTUT9rrxvuNX9YuLOClLJBv/GnKWLwEv9DBW72nrbIXvPjIu9fkJ
         q/9OaSWSYQ7ILOtOqDwQwapno9i9YeeZOXGDNvIEhWFWsKxSjZnSzf/MkU/VT/QhFAzI
         JwxbrBJFz8PShIFe0nPTn1lECSVT/AFDuv2w7zg4wegoXaL+F+M9K4c207HNkNNVuF53
         rhoA==
X-Gm-Message-State: AOAM533dq+Jkewtv3KIqijwVGc6bRBAlH0KmiFHbDijZkhSQBsncZ9yt
	7q3fsis2Szjqs0VYbLw13f3qVguUq0hf68tymCTkkCa3BztHPw==
X-Google-Smtp-Source: 
 ABdhPJzEOGQif7CZSqt9UkqhfxEywJ+wK5AS7ED5HzxZV/wORSbb12fHEI/Ejpze2G4D/zhxmeHOZTYR9AHJOOTmyTI=
X-Received: by 2002:adf:9d83:: with SMTP id p3mr12162971wre.313.1607674250716;
 Fri, 11 Dec 2020 00:10:50 -0800 (PST)
MIME-Version: 1.0
Received: by 2002:adf:fa4a:0:0:0:0:0 with HTTP; Fri, 11 Dec 2020 00:10:50
 -0800 (PST)
From: Atul Kumar <akumar14871@gmail.com>
Date: Fri, 11 Dec 2020 13:40:50 +0530
Message-ID: 
 <CA+ONtZ5Te8VoHypVP5N3sHDGq08UYuMYa4w66-tocryd6hyd+Q@mail.gmail.com>
Subject: Required checkpoints occurs too frequently
To: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

Hi,

We are getting this alert frequently "Required checkpoints occurs too
frequently" on postgres version 11.8

The RAM of the server is 16 GB.

and we have already set the max_wal_size= 4096 MB
min_wal_size= 192 MB.

Please help me in optimizing the same to avoid this alert.


Regards,
Atul