Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sw0b0-001JKn-GJ for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Oct 2024 14:44:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sw0ay-00Gd2n-Ta for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Oct 2024 14:44:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sw0ay-00Gd2f-Ib for pgsql-hackers@lists.postgresql.org; Wed, 02 Oct 2024 14:44:52 +0000 Received: from mail-ed1-x52c.google.com ([2a00:1450:4864:20::52c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sw0au-002CC6-VD for pgsql-hackers@lists.postgresql.org; Wed, 02 Oct 2024 14:44:51 +0000 Received: by mail-ed1-x52c.google.com with SMTP id 4fb4d7f45d1cf-5c88370ad7bso7010491a12.3 for ; Wed, 02 Oct 2024 07:44:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=cybertec.at; t=1727880289; x=1728485089; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=ygbKnxgc9T5DxaCpz8tlGbsJgiSBoQHhppIcFmT+2Ro=; b=C4sjs0XbV7EJhHdYP98R3V+yKkgdBXZj4C4FdnaVTg13+bXYs7lzAEWrqiYmx1rAzZ T6KCmtaHM9Ks0JUwKmJ0Od6hfVtk0ib2/92mn6ENRWXIEJf9+wawXTomixTw7TxQp7rq ox8GbiIoSJ6prk0UjigOz3mFlmMWLEF5lVNIo= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727880289; x=1728485089; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=ygbKnxgc9T5DxaCpz8tlGbsJgiSBoQHhppIcFmT+2Ro=; b=ox16tJIcf93C7o0nxGnLn86l3g0KdKxC1dum6XgXSG98hyZkhyVeJiONCwZhpaFXCq 4KpZA6QCoIT+LkVLIxjCh6wCNdMSoswqMaO6KEjbUjyoSKE+wQ9epBG3rg/G42vHIN3Q aT1JKB5tj2V9pqT8o27LMM+U6kKKE/yqH3NLjRkuQvVNUTcMGy609eI0DbS8/THaIwMc y83BavEUicKFzhwqV1tmBV0huX3WzrfuU5f3QJ/eMGwxXg1pcoj4qpoKp0g8dDjtJHZb sRGScaoshiK+7eCnIMHx0lU4Dq8Dkug+9LA2/Iyo84XLv9PU4hWtboskGc9++PMNfXIA B7Bg== X-Forwarded-Encrypted: i=1; AJvYcCWdIovwVPXp+mxw/fKlCjGJBnj/aMS189FE167oKfZ++xSmNVDXC+LFb06kV+GqCXk0wHVb1ZlgYKJiaOgM@lists.postgresql.org X-Gm-Message-State: AOJu0YwGvjTpKodk2uPTmwLKmOUiBr0p+hlA+IXyG9/Wn6fq10i73ERT Mj8XXZYUMIyAG9cgqIoZroEc6sXpn4WP5D84zNy3+w7PZQDnUKapFLpOtiMdDdo= X-Google-Smtp-Source: AGHT+IFs0CSQBdaIsEkDOAwUuQBo1zxjxC8GdQMuwaeMKbcsJpDR+oYKOJX0MLKkbQuIR5Lk48+PuQ== X-Received: by 2002:a05:6402:2814:b0:5c8:77a5:d486 with SMTP id 4fb4d7f45d1cf-5c8b1b8acbfmr2833692a12.33.1727880289347; Wed, 02 Oct 2024 07:44:49 -0700 (PDT) Received: from [192.168.116.211] ([41.66.98.9]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-5c88248af26sm7914031a12.63.2024.10.02.07.44.47 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 02 Oct 2024 07:44:49 -0700 (PDT) Message-ID: <35ab74f3059c470355bc602e3b52538b1f11b835.camel@cybertec.at> Subject: Re: bgwrite process is too lazy From: Laurenz Albe To: wenhui qiu , PostgreSQL Hackers Date: Wed, 02 Oct 2024 16:44:46 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-10-02 at 16:48 +0800, wenhui qiu wrote: > Whenever I check the checkpoint information in a log, most dirty pages ar= e written by the checkpoint process That's exactly how it should be! Yours, Laurenz Albe