Drop type "smgr"? - Mailing list pgsql-hackers

From Thomas Munro
Subject Drop type "smgr"?
Date
Msg-id CA+hUKG+DE0mmiBZMtZyvwWtgv1sZCniSVhXYsXkvJ_Wo+83vvw@mail.gmail.com
Whole thread Raw
Responses Re: Drop type "smgr"?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Drop type "smgr"?  (Robert Haas <robertmhaas@gmail.com>)
Re: Drop type "smgr"?  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
Hello hackers,

The type smgr has only one value 'magnetic disk'.  ~15 years ago it
also had a value 'main memory', and in Berkeley POSTGRES 4.2 there was
a third value 'sony jukebox'.  Back then, all tables had an associated
block storage manager, and it was recorded as an attribute relsmgr of
pg_class (or pg_relation as it was known further back).  This was the
type of that attribute, removed by Bruce in 3fa2bb31 (1997).

Nothing seems to break if you remove it (except for some tests using
it in an incidental way).  See attached.

Motivation: A couple of projects propose to add new smgr
implementations alongside md.c in order to use bufmgr.c for more kinds
of files, but it seems entirely bogus to extend the unused smgr type
to cover those.

-- 
Thomas Munro
https://enterprisedb.com

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: reloption to prevent VACUUM from truncating empty pages at the end of relation
Next
From: Tom Lane
Date:
Subject: Re: Drop type "smgr"?