Thread: pg_multixact_member file limits
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.
Martin Ritchie | |
| Geotab | |
| Senior DBA | |
| Direct | +1 (519) 741-7660 |
| Toll-free | +1 (877) 436-8221 |
| Visit | www.geotab.com |
| Twitter | Facebook | YouTube | LinkedIn | |
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.