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 1sCZEY-006TPw-V4 for pgsql-general@arkaria.postgresql.org; Thu, 30 May 2024 06:25:56 +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 1sCZEZ-001eVy-02 for pgsql-general@arkaria.postgresql.org; Thu, 30 May 2024 06:25:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sCZEY-001eVq-Le for pgsql-general@lists.postgresql.org; Thu, 30 May 2024 06:25:54 +0000 Received: from mail-yb1-xb2e.google.com ([2607:f8b0:4864:20::b2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sCZEW-002d2B-97 for pgsql-general@lists.postgresql.org; Thu, 30 May 2024 06:25:53 +0000 Received: by mail-yb1-xb2e.google.com with SMTP id 3f1490d57ef6-dfa627dc3bdso131290276.0 for ; Wed, 29 May 2024 23:25:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717050351; x=1717655151; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=7izAvAV2eGEfD8bPMKxzwc6Qr8aipJ0xMiySE+iFbo0=; b=AlQjNbeDOz0aoGU1Kj08cBjEnU5lJDn2C3otGRMfkDHrp+KgjLypjFww8CBg4kkMtW 0n97uccL6ZrC93WMjALhktso938p8zrl6qsGbeNkOvFL5iRJ/1sRO5V76rJ7LPjrZ/5H Q8fixz0OC0YmYELqJ7uom6TyXJBA9u1EIsRfxfRQeagbMKad+v3allrTG2szDaKX4KYH LLtDA/t0FfJcmWelSmiKEHnH5Jv61EGY/+qQMOs8aKOIZwsbLRP0QLUuXwneGPDoaZX3 8Xr0bV4x9OfKnTYoZO4eR3BJa5cOUNJxFpArO9ikytAhYCcn03KVi61Gd/BLvahO/ozU dFTg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717050351; x=1717655151; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=7izAvAV2eGEfD8bPMKxzwc6Qr8aipJ0xMiySE+iFbo0=; b=iriL2oVeddMM3msPAYMpQiWaCMrbSg4+2rnVTdMuxk/X2bs0hx0Y/PrGZ5c4LoHTbq 3R17bX1wmhpcajRtf9q5jVakoLLerettPCOAPPi6AwT9CU7XNTpFxjrOMkubPXB30MNz wtCnFHREMOkm8PMhcO94n0Pce8XlCNsz/vIjdW+GEH7gjNjPvSng+eowaiZqZr0domwg +xO+bYBMEpz52miSY3UcYlch7raa9quTgapOZ3mX9geSbi8GGVl+OzHhi/YCrT9HOyAY 11gXowNUnXMjexpJ9XL8SK9e++adgaleTphdB7VGePhe/dJqCA0V16UXo94k2Hx+iDWY BjPg== X-Gm-Message-State: AOJu0YyHhX7YT8m3p3FTKReD0MIzmKkKjZjs8nhptC4l4+Y0cgOVIGEO q2x6LEn510HGWxGD0vOz6AbzR+fkwZOfE582JpgMwati43QCKsLIEtoI63Tk9lX66eoNm2Q7dks 5Oveh+GQt4pMb582vPnP0HjimhVBuajaoTi0= X-Google-Smtp-Source: AGHT+IGX19dFmi0cAtUhC5nfZeX1zSEDsETzoDVCkkNw4/KTeN7o5oIcSxonUbOzCVatkddWJBTkxF8F4SBcLBSnZqw= X-Received: by 2002:a25:ae9a:0:b0:df7:966b:214d with SMTP id 3f1490d57ef6-dfa5d89e028mr739023276.17.1717050351283; Wed, 29 May 2024 23:25:51 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Andrea Gelmini Date: Thu, 30 May 2024 08:25:34 +0200 Message-ID: Subject: Re: Memory issues with PostgreSQL 15 To: =?UTF-8?Q?Christian_Schr=C3=B6der?= Cc: "pgsql-general@lists.postgresql.org" , Eric Wong Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Il giorno mar 28 mag 2024 alle ore 18:40 Christian Schr=C3=B6der ha scritto: > Our PostgreSQL version is "PostgreSQL 15.5 on x86_64-pc-linux-gnu, compil= ed by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit". The database se= rver is a dedicated server with 15 GB RAM (and 4 cores, if this matters). Maybe you have PostgreSQL running inside a container with capped resources (I saw this on some recent distro, running it from systemd)?