pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_multixact_member file limits
2+ messages / 2 participants
[nested] [flat]
* pg_multixact_member file limits
@ 2023-01-10 04:51 Martin Ritchie <martinritchie@geotab.com>
2023-01-10 13:53 ` Re: pg_multixact_member file limits Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Martin Ritchie @ 2023-01-10 04:51 UTC (permalink / raw)
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
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 <https://twitter.com/geotab; | Facebook
<https://www.facebook.com/Geotab; | YouTube
<https://www.youtube.com/user/MyGeotab; | LinkedIn
<https://www.linkedin.com/company/geotab/;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_multixact_member file limits
2023-01-10 04:51 pg_multixact_member file limits Martin Ritchie <martinritchie@geotab.com>
@ 2023-01-10 13:53 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ron @ 2023-01-10 13:53 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-01-10 13:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-10 04:51 pg_multixact_member file limits Martin Ritchie <martinritchie@geotab.com>
2023-01-10 13:53 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox