From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Patches (current CVS) for changes if index AM tables |
Date: | 2001-08-15 12:07:20 |
Message-ID: | Pine.GSO.4.33.0108151447531.7278-103000@ra.sai.msu.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
we finished first stage of our proposal for changing of index AM tables
(see for reference http://fts.postgresql.org/db/mw/msg.html?mid=1029290)
I attached 3 files:
1. patch_72_systbl.gz - patch to current CVS
2. btree_gist.tar.gz - contrib/btree_gist module -
implementation of Btree using GiST with
support of int4 and timestamp types.
3. test.tar.gz - test suite for brave (not for applying !)
Regression tests and our tests passed fine
Patch is for today CVS, please apply them asap to avoid possible
conflicts.
Now we're going to 2nd stage of our proposal.
We plan to remove pg_index.indislossy (now we have pg_amop.amopreqcheck)
and pg_index.indhaskeytype (it's just don't used, all functionality
is in pg_opclass.opckeytype now)
question:
Do we need to normalize pg_amop and pg_amproc tables ?
Tom was concerned (http://fts.postgresql.org/db/mw/msg.html?mid=1025860)
about possible performance degradation.
We think it's possible to leave tables as is. Of course it'd require
some attention when updating these tables.
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
Attachment | Content-Type | Size |
---|---|---|
patch_72_systbl.gz | application/octet-stream | 12.8 KB |
btree_gist.tar.gz | application/octet-stream | 14.1 KB |
test.tar.gz | application/octet-stream | 1.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Wald, Matthias | 2001-08-15 12:18:35 | UB-Trees |
Previous Message | Tatsuo Ishii | 2001-08-15 09:35:00 | Re: Re: To be 7.1.3 or not to be 7.1.3? |