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 1tvIJb-003BYs-An for pgsql-admin@arkaria.postgresql.org; Thu, 20 Mar 2025 16:00:15 +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 1tvIIb-003sTU-DB for pgsql-admin@arkaria.postgresql.org; Thu, 20 Mar 2025 15:59:13 +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 1tvIIb-003sTC-0R for pgsql-admin@lists.postgresql.org; Thu, 20 Mar 2025 15:59:13 +0000 Received: from mail-wr1-x42d.google.com ([2a00:1450:4864:20::42d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvIIY-000A9F-1d for pgsql-admin@lists.postgresql.org; Thu, 20 Mar 2025 15:59:12 +0000 Received: by mail-wr1-x42d.google.com with SMTP id ffacd0b85a97d-3912d2c89ecso879237f8f.2 for ; Thu, 20 Mar 2025 08:59:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1742486349; x=1743091149; 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=bmGZfUe6JBnri1KAfg6sQkZb+laC0XT3PO7+rYWNhqA=; b=SkKwc0sqVoX44saIyevFGs/O0YgxcTRzk/NfqkRTVg+7AoFbxgTuSHrTQwj9vjs9ld CTmNvXQnkkuHg+dn/dR4Yoh7geKdpmADMvOUbguS2uTu1B2kw9gSi79l5zFYDuJpSDit p9zCrbywmSv7HhFIZD2778ubiSnT6x+BcYAuIwEWIEG63yXcTXnt5IhWeNiDSi+kwcxB y0PLprdEVzio4/hueuZmi/Nz+pkSC9ZFI4oLOfbNW3WXOTod9Q8iClvTO83BDwFkbzc1 smIsf4bOoPnWsze0uthuuCYxkvb215dcsR2PWrbJP17V+T0YQPQPuP4QBXojUVLAayHG Hkgw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742486349; x=1743091149; 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=bmGZfUe6JBnri1KAfg6sQkZb+laC0XT3PO7+rYWNhqA=; b=SskibzJsRyWXTMSJOlUpiO5AQln1iadowghsU0VAOsECCNbRtnycFZbYP3mboEwwTD ItoOIVoxsSQFYXNG0gOIwjbOZpGxTJGAGmp9vOEx0NPc+rpLdFyFkQ4zkhTXagjGfkut Ywxfg5Ly6J3yXP/ce5TEDqPwlv4PqSLKHD9Xr+UrWqOenxjkmDK4L/R5ahQAsjHCQpno mbLYtjP+hQSJdVONVNnON1ttYaGqT+lBN5xz5UxNTmPR3Mv0Sc2nlFLVcNXqu/NC2U4X jhNbzKBWXPI801uBW6YERPr26okMMDTioksDzGIVUJ9E+r+m/SQIvFkNYG+ZtjhOPZMX FjOg== X-Forwarded-Encrypted: i=1; AJvYcCX22Ayc/giXKHxm1gAA2ZSNZTbiSfBV1SUI+296dvMwL7THYUuizNPvC3vinTauseygbQQMFtQ1lird6w==@lists.postgresql.org X-Gm-Message-State: AOJu0Yxl7PNQ+Kcs9P30zcwlbzT1Cl9Nl/pQEa1vXtIoy6znBWKKkaqZ nh9P++woJxCeOXMSpwb2jU9dlIJK2Fl+/wyWSXLwsAyyuc+pSMZktHkmkKwOFA8= X-Gm-Gg: ASbGncuoPvFAsjXnCDcZKa2r38quKv6CvYg2sGW6orjxRkR9oSW4m19CkB3Rf+FilKG G2Kuo8aiCL1pu7pdHJqq3yIT45a0ohvTyP7zyovVQDTW0fKDeaGxsUKfn18D/BHJwejlDcnoSrY eSCdzBRNAQSdVbRoBWHKGhYZic/W5KisZ70qkbOhScwESsBxFMnNN0VI6FnxilGeCpPEt3fHZTp h9fAytmFI7iHVT+XdMq523DusyrqAl5PzTvVSMBJy17Ar7MRooZmL5cEuri1zcU00lCP53orMWf IKSGrFg0OtkGrUNvlTa1meuinvFk0xsd8EoNOmKpawgsXTitiycdBF5Gbqr1EDmv3SMUVC566w= = X-Google-Smtp-Source: AGHT+IHMCAGU+/mlr+pIc/2qKHWSoDakEFxMjvBO7i4WilFY58NiLIp5T9TqjgpD7wSAKnoKaEEBag== X-Received: by 2002:a05:6000:2d01:b0:391:4bf2:6f0d with SMTP id ffacd0b85a97d-3997f940e33mr12224f8f.52.1742486349332; Thu, 20 Mar 2025 08:59:09 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:4a1:e980:793b:ea4c:4c10]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-395cb7eb8c2sm23662968f8f.85.2025.03.20.08.59.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 20 Mar 2025 08:59:09 -0700 (PDT) Message-ID: Subject: Re: Background writer not much active From: Laurenz Albe To: Motog Plus , Pgsql-admin Date: Thu, 20 Mar 2025 16:59:08 +0100 In-Reply-To: References: <3d5ed781370b8eba8c7b261052cd3904db135d40.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-03-20 at 18:21 +0530, Motog Plus wrote: > We expect that many connections to the db, 1500-2000 so we have kept max = connection limit to 3000. Use a connection pooler. These are too many connections. Yours, Laurenz Albe