Re: Rework the way multixact truncations work - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Rework the way multixact truncations work
Date
Msg-id 562FE3E1.5070303@agliodbs.com
Whole thread Raw
In response to Re: Rework the way multixact truncations work  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 10/27/2015 07:44 AM, Andres Freund wrote:
>> Unlinking old pg_clog files is strictly an optimization.  If you were to
>> > comment out every unlink() call in slru.c, the only ill effect on CLOG is the
>> > waste of disk space.  Is the same true of MultiXact?
> Well, multixacts are a lot larger than the other SLRUs, I think that
> makes some sort of difference.

And by "a lot larger" we're talking like 50X to 100X.  I regularly see
pg_multixact directories larger than 1GB.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Limit GIST_MAX_SPLIT_PAGES to XLR_MAX_BLOCK_ID
Next
From: Robert Haas
Date:
Subject: quieting DEBUG3