| From: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Proposal: PageLayout footprint |
| Date: | 2008-08-11 05:06:41 |
| Message-ID: | 489FC8E1.9090307@sun.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Current content of control file is insufficient to check if database is
compatible with postgres server. I think we should create footprint file which
will contains all page data structures and their member offset and length (and
maybe more).
As a first step which is useful at least for in-place-upgrade is footprint
switch which prints page layout structures. I attach WIP patch.
I'm thinking also to create pg_footprint view with (version, structure name,
attribute, offset, size) columns. But I'm not sure about usefulness of this
catalog (?maybe for regression tests?).
Comments, ideas?
Thanks Zdenek
--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql
| Attachment | Content-Type | Size |
|---|---|---|
| footprint.patch | text/x-diff | 2.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2008-08-11 07:39:01 | proposal: UTF8 to_ascii function |
| Previous Message | David E. Wheeler | 2008-08-11 03:58:40 | Re: Type Categories for User-Defined Types |