pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_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>
  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 13:53  Ron <ronljohnsonjr@gmail.com>
  parent: Martin Ritchie <martinritchie@geotab.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