Re: truncating pg_multixact/members - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: truncating pg_multixact/members
Date
Msg-id 1388267260.20441.YahooMailNeo@web122302.mail.ne1.yahoo.com
Whole thread Raw
In response to truncating pg_multixact/members  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: truncating pg_multixact/members
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

> 1. slru.c doesn't consider file names longer than 4 hexadecimal chars.

> Fixing (1) is simple: we can have each SLRU user declare how many digits
> to have in file names.  All existing users but pg_multixact/members
> should declare 4 digits; that one should declare 5.  That way, the
> correct number of zeroes are allocated at the start point and we get
> nice, equal-width file names.  Eventually, predicate.c can change to
> wider file names and get rid of some strange code it has to deal with
> overrun.

That would be nice.

There would be the issue of how to deal with pg_upgrade, though. If
I remember correctly, there is no strong reason not to blow away
any existing files in the pg_serial subdirectory at startup (the
way NOTIFY code does), and at one point I had code to do that.  I
think we took that code out because the files would be deleted
"soon enough" anyway.  Barring objection, deleting them at startup
seems like a sane way to handle pg_upgrade issues when we do
increase the filename size.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: [PATCH] Regression tests in windows ignore white space
Next
From: Tom Lane
Date:
Subject: Re: planner missing a trick for foreign tables w/OR conditions