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