Re: Suggestion/request - Mailing list pgsql-docs
From | Bruce Momjian |
---|---|
Subject | Re: Suggestion/request |
Date | |
Msg-id | 199910150145.VAA10683@candle.pha.pa.us Whole thread Raw |
List | pgsql-docs |
This looks good, and I would like to include it in the distibution somewhere in HTML format so we can perhaps use it later. I have converted it to HTML, but does anyone have an idea where to put it. I could put it in doc/src/sgml, but that appears to be the wrong place. I am going to gzip the HTML file and put in src/sgml, even though it is not sgml nor part of the docs unless someone can tell me where they want it. [Charset iso-8859-1 unsupported, filtering to ASCII...] > Bruce: > > I'm referring to a new index type rather than a new data type. Sorry I > didn't make that clear enough. Here is the document. > > Thanks and regards, > > David C. Sisk > Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at > http://www.ipass.net/~davesisk/oont.htm > Like original modern rock? Listen to song samples and buy a CD at > http://www.mp3.com/disparityofcult > Raleigh music compilation! All $$$ go to NC Food Bank. > http://www.mp3.com/whisper2ascream > > *** SPECIAL NOTE*** > During October 1999, Disparity of Cult will donate all our revenues from CD > sales to the > North Carolina Hurricane Floyd Disaster Relief Fund. See the MP3 site above > for details. > -----Original Message----- > From: Bruce Momjian <maillist@candle.pha.pa.us> > To: David Sisk <davesisk@ipass.net> > Date: Wednesday, October 13, 1999 10:41 PM > Subject: Re: Suggestion/request > > > >[Charset iso-8859-1 unsupported, filtering to ASCII...] > >> Hello Bruce: > >> > >> A little over a year ago, I had formulated what I was calling an > "aggregate > >> index" (a little different from PostgreSQL's idea of an aggregate). I > had > >> considered promoting this concept to Oracle Corp, but couldn't come up > with > >> the right contacts. Since then, they have implemented something called > >> "materialized views" that theoretically, serves the same purpose > (although I > >> liked my approach better!). > >> > >> Anyway, this index type would allow decision support queries (big > SELECT's) > >> to execute blazingly fast. I know the enhancement list is big, but if > you > >> are interested, I'd like to forward you a document on this index type. > >> > >> Just out of curiosity, are there any plans to implement other index types > >> such as bitmap indexes, join indexes, etc? I didn't specifically see > those > >> listed... > > > >No one has mentioned adding additional data types, though I can > >understand their usefulness. We have been trying to chip away at the > >big user-request items in the past few years. I am sure it would be > >nice to add new types, but our fixup plate is so full, it is hard to > >consider them. > > > >I can certainly put the document into our documentation for possible > >implementation in the future. > > > >-- > > Bruce Momjian | http://www.op.net/~candle > > maillist@candle.pha.pa.us | (610) 853-3000 > > + If your life is a hard drive, | 830 Blythe Avenue > > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > [Attachment, skipping...] -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
pgsql-docs by date: