| From: | Martin Ritchie <martinritchie(at)geotab(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | pg_multixact_member file limits |
| Date: | 2023-01-10 04:51:19 |
| Message-ID: | CA+LW_6K1nShUmTUPjWJFbd48u35tTBdHzKoJRXfs7RwEF_+MVA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro Horiguchi | 2023-01-10 06:01:52 | Re: Segmentation fault on RelationGetDescr in my first extension |
| Previous Message | Joe Conway | 2023-01-09 15:57:35 | Re: How do the Linux distributions create the Linux user/group "postgres"? |