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 1qE2LY-0000D4-TG for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Jun 2023 06:38:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qE2LX-0001NZ-Os for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Jun 2023 06:38:39 +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 1qE2LX-0001NC-EP for pgsql-hackers@lists.postgresql.org; Tue, 27 Jun 2023 06:38:39 +0000 Received: from mail-wm1-x331.google.com ([2a00:1450:4864:20::331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qE2LU-000glC-Px for pgsql-hackers@postgresql.org; Tue, 27 Jun 2023 06:38:38 +0000 Received: by mail-wm1-x331.google.com with SMTP id 5b1f17b1804b1-3f9c2913133so52781935e9.1 for ; Mon, 26 Jun 2023 23:38:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aiven.io; s=google; t=1687847914; x=1690439914; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to; bh=bbyVRpSNhsd77FCQN0n0fAt55G1qXi415BiwmrUgOC8=; b=RNrRhW6WA74cTDFnFJ3Dm88FehnXSmz7xhfU7eEtODtp0WNzoOcoWnupUwW8EdSyju L1iuaZD9lzesWVPX6lPJFwkjQn8II/3SAKnGmEtXmyh1fCIMKT6za56sTDZoxs4Pmz3d QlP5AYQkY9VgK6l13h24qoLaBs94s3h5blrks= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687847914; x=1690439914; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=bbyVRpSNhsd77FCQN0n0fAt55G1qXi415BiwmrUgOC8=; b=TlpbYAc3ZsuvyrIWLxB200uAQUVBs+ICa5DTDKgPEAjKF3d6q+e1VUYUHi0puUd3c4 DtsygB+cyNuyu7J0eWnw8D5+HDqmT+RFjwvdvEW1oK4GyiTGTwaLEvt22WSUUh8l719p EhBl9gpsahTiANZ6xDEHxmWnK6vG7Aishupxxy7BmgkCrKmSD/17piCYE5lfufFzhVpp os71IRyOqfQJm4otqhVn/h9WacPvSa3uWD/n+/Fir1eZDW1btBiUU7QVnwfSt3QceK1D 1SJBPitZCdCAbr3FSybhujmVU17n8yvcbLWm5+wKuecRJzU4t6QUM3F7cbHSxWkL3mAy Eyhw== X-Gm-Message-State: AC+VfDyW++rf54/pEMYsLurcQv6wh/4Ug1aso8ugvxIKkVNJ9rFbNjjf DIrp16L/bmpPz6ltTEZ8hQ+JqzG3eoQjtN8Z0YU= X-Google-Smtp-Source: ACHHUZ5GayhEaRVRZeZOSuJOZk3YVFS4V/Aqzp4MQILA3eOwv8JNeQ+MPG5dyBCnSzQnoE6FsiTipg== X-Received: by 2002:a5d:65c7:0:b0:313:ede8:9f13 with SMTP id e7-20020a5d65c7000000b00313ede89f13mr5010460wrw.32.1687847914492; Mon, 26 Jun 2023 23:38:34 -0700 (PDT) Received: from aivenlaptop.localnet ([45.13.105.93]) by smtp.gmail.com with ESMTPSA id v10-20020a5d590a000000b002fda1b12a0bsm9482338wrd.2.2023.06.26.23.38.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 26 Jun 2023 23:38:34 -0700 (PDT) From: Ronan Dunklau To: Andres Freund , pgsql-hackers@lists.postgresql.org Cc: pgsql-hackers@postgresql.org, Peter Eisentraut , tomas.vondra@enterprisedb.com Subject: Re: Add GUC to tune glibc's malloc implementation. Date: Tue, 27 Jun 2023 08:39:59 +0200 Message-ID: <1932843.PYKUYFuaPT@aivenlaptop> In-Reply-To: <8235070.T7Z3S40VBb@aivenlaptop> References: <3424675.QJadu78ljV@aivenlaptop> <8235070.T7Z3S40VBb@aivenlaptop> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Le mardi 27 juin 2023, 08:35:28 CEST Ronan Dunklau a =E9crit : > I re-attached the simple script I used. I've run this script with differe= nt > values for glibc_malloc_max_trim_threshold. I forgot to add that it was using default parametrers except for work_mem, = set=20 to 32M, and max_parallel_workers_per_gather set to zero.=20