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 1pFF4E-0004Sx-C7 for pgsql-general@arkaria.postgresql.org; Tue, 10 Jan 2023 13:53:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pFF4D-0001c0-0a for pgsql-general@arkaria.postgresql.org; Tue, 10 Jan 2023 13:53:29 +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 1pFF4C-0001br-K2 for pgsql-general@lists.postgresql.org; Tue, 10 Jan 2023 13:53:28 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pFF46-0000C2-Bi for pgsql-general@lists.postgresql.org; Tue, 10 Jan 2023 13:53:27 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id y194-20020a4a45cb000000b004a08494e4b6so3221533ooa.7 for ; Tue, 10 Jan 2023 05:53:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=CaIqgZueS3BT31kQn6jk3sJkqbawVB+hOyOZwoZw0Cs=; b=ZywmRiTyqn8ZUyhhLkwTTAN9rUCYll+BQOreLZEHLhRknyA3JhPgmnysDsrG/HLYkh FXvlZnaqLcwqr+lGvyGDR66l9rgPnsu1z+4kB80FuZCRMJzJsAZ4BcxXQV5bVnWeaEzz fqdOp4X9XVt6DjArmVFHfEJ5lJBzFGwzELuHiBSnvy+yF5jePllfjZuAZOh1/C7xh/ye SzXLo7b2yFXmHRtiHH0d0Sa2whI/zXtO0GuGVYCTWy/cwlJtsNeFGZtsI4RjDyhCkyWL JNSiyGulwK/c0WepEZQ4F82bB4lfzsRPiiGFFYR9m8w1S0bru364GBi8dpJCSnbuT40K 3UKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=CaIqgZueS3BT31kQn6jk3sJkqbawVB+hOyOZwoZw0Cs=; b=gSkm4GjMojXDkoMVL+jj0P+CXsm6N2rPsZTCEnSXHJ9sDVkEz0Q3enjEd0JJt1sZZV iiHIGeG3tx5rxHvu3n8DJFktjQVviyRgeZ7Ycd5DZqEBUAHsT68OMMkmmcRBXWj2Z7YG uKVuU1TqWieWOXFHV4kJJ21zPZ1Ka4+InI78lRzgmrKrvXPSLXbo6/YpkrKkwVUTllVs fUrdfLy504uoyZjW7B3ebxPCEbJRGpk5epsb41X4Zt1G6PkPk3/U+jswbOE/xjKLOLrS w2ZAaXEmChMVXkkvZXYNMFK5uSITq1azOzU+t0Xpj/NViGSRG1j3Dovw1KnFU4BJQUAR ankQ== X-Gm-Message-State: AFqh2koIw3smaOTa7l77byKoNl4f7Kf+gK59yNFDyHpJace0AbB250I0 wrqoJM3Rt4cNIkr3kh0uS/lTr21r38w= X-Google-Smtp-Source: AMrXdXs1K44z/iqBsat5TZ86rTlnLt1gZWaB835tqquk37UYA8d6WiyLHTvWyQwY3xyyAMRZnuxhjQ== X-Received: by 2002:a4a:952f:0:b0:49f:8941:ffed with SMTP id m44-20020a4a952f000000b0049f8941ffedmr29944201ooi.9.1673358800270; Tue, 10 Jan 2023 05:53:20 -0800 (PST) Received: from [192.168.1.66] (108-250-206-84.lightspeed.nworla.sbcglobal.net. [108.250.206.84]) by smtp.googlemail.com with ESMTPSA id f13-20020a4ae60d000000b00492f9f46aa4sm5662572oot.36.2023.01.10.05.53.18 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 10 Jan 2023 05:53:18 -0800 (PST) Message-ID: <933a4f60-487e-3655-b172-e9fbd34a6cd7@gmail.com> Date: Tue, 10 Jan 2023 07:53:18 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: pg_multixact_member file limits Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/9/23 22:51, Martin Ritchie wrote: > Are there any limits on the number of records in > the postgresql/12/main/pg_multixact/members directory? We have a database > that has grown to tens of thousands of files in this directory during an > autovacuum after a large data purge. It shrank after the autovacuum completed. Wouldn't that be a function of how much filesystem performance degrades as the number of files in a directory increases? -- Born in Arizona, moved to Babylonia.