Re: pg_multixact_member file limits

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_multixact_member file limits
Date: 2023-01-10 13:53:18
Message-ID: 933a4f60-487e-3655-b172-e9fbd34a6cd7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-01-10 13:57:22 Re: Use case for enabling log_duration other than benchmarking
Previous Message Alicja Kucharczyk 2023-01-10 13:14:03 Use case for enabling log_duration other than benchmarking