Thread: Keyed Tables
I thought I had already posted this query but now I can't remember. If I have please excuse the repeat. But as I can't remember the answer either can someone please comment. Is there likely to be any attempt to allow a table to be keyed. It seems that by default a table is created as a heap and in order to improve access speed, one must create indices on that table. I use Ingres at work and quite like the ability to do a 'modify table to btree' type of command. When the table concerned is basically only a key plus value, it seems rather inefficient to have to have both the heap and then an index when supposedly one could simply make the table into a btree in the first place. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Glen Eustace, on behalf of GodZone Internet Services, a division of AGRE Enterprises Limited. 176 Te Awe Awe St, Palmerston North, New Zealand Ph: +64 6 356 2562, Fax: +64 6 357 0271, Mobile: 025 416 184, http://WWW.GodZone.Net.NZ
[Charset iso-8859-1 unsupported, filtering to ASCII...] > I thought I had already posted this query but now I can't remember. If > I have please excuse the repeat. But as I can't remember the answer > either can someone please comment. > > Is there likely to be any attempt to allow a table to be keyed. It > seems that by default a table is created as a heap and in order to > improve access speed, one must create indices on that table. > > I use Ingres at work and quite like the ability to do a 'modify table to > btree' type of command. When the table concerned is basically only a > key plus value, it seems rather inefficient to have to have both the > heap and then an index when supposedly one could simply make the table > into a btree in the first place. Yes, it is a nice feature, but we don't support it. We do have CLUSTER, but that is not as nice. -- 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
> Yes, it is a nice feature, but we don't support it. We do > have CLUSTER, but that is not as nice. Any chance of adding it to the list of possible enhancements ?
[Charset iso-8859-1 unsupported, filtering to ASCII...] > > Yes, it is a nice feature, but we don't support it. We do > > have CLUSTER, but that is not as nice. > > Any chance of adding it to the list of possible enhancements ? Not sure it is do-able for us. It would require so much work, that I hesitate to add it. -- 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
Whats the possibility of having full text searches added to text fields? That would be awesome..... Andy
On Sun, 23 May 1999, Andy Lewis wrote:
> Whats the possibility of having full text searches added to text fields?
>
> That would be awesome.....
Unfortunately, full text indexing is a different issue than the kind of
indexing performed on table columns, and if you want to do any kind of
efficient full text searching, you have to index the individual words in
the text or it'd be so slow as to be hardly useful (especially if you're
talking about 600,000 records with 2K of text in each text field).
Excalibur, for instance, creates its own internal indexing for full text
records, but uses an underlying SQL database for regular fielded data, and
when you design your database, you have to make the distinction about what
kind of indexing you want, stop words (words you don't want indexed, like
'the' and 'of'), and the way certain fields can or will be searched.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
The six great gifts of an Irish girl are beauty, soft voice, sweet speech,
wisdom, needlework, and chastity.
-- Theodore Roosevelt, 1907
We have a fulltext stuff in the contrib directory. > On Sun, 23 May 1999, Andy Lewis wrote: > > > Whats the possibility of having full text searches added to text fields? > > > > That would be awesome..... > > Unfortunately, full text indexing is a different issue than the kind of > indexing performed on table columns, and if you want to do any kind of > efficient full text searching, you have to index the individual words in > the text or it'd be so slow as to be hardly useful (especially if you're > talking about 600,000 records with 2K of text in each text field). > > Excalibur, for instance, creates its own internal indexing for full text > records, but uses an underlying SQL database for regular fielded data, and > when you design your database, you have to make the distinction about what > kind of indexing you want, stop words (words you don't want indexed, like > 'the' and 'of'), and the way certain fields can or will be searched. > > Brett W. McCoy > http://www.lan2wan.com/~bmccoy/ > ----------------------------------------------------------------------- > The six great gifts of an Irish girl are beauty, soft voice, sweet speech, > wisdom, needlework, and chastity. > -- Theodore Roosevelt, 1907 > > > > -- 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
On Sun, 23 May 1999, Bruce Momjian wrote:
> We have a fulltext stuff in the contrib directory.
What's it called? I only see some tcl frontend stuff. Despite my
pessimism form the prior message, I am interested in a full text retrieval
engine.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Lonely is a man without love.
-- Englebert Humperdinck
Its not really, really explanitory..... On Mon, 24 May 1999, Brett W. McCoy wrote: > On Sun, 23 May 1999, Bruce Momjian wrote: > > > We have a fulltext stuff in the contrib directory. > > What's it called? I only see some tcl frontend stuff. Despite my > pessimism form the prior message, I am interested in a full text retrieval > engine. > > Brett W. McCoy > http://www.lan2wan.com/~bmccoy/ > ----------------------------------------------------------------------- > Lonely is a man without love. > -- Englebert Humperdinck >
> On Sun, 23 May 1999, Bruce Momjian wrote: > > > We have a fulltext stuff in the contrib directory. > > What's it called? I only see some tcl frontend stuff. Despite my > pessimism form the prior message, I am interested in a full text retrieval > engine. It is called contrib/fulltextindex. Does someone want to suggest a better name? -- 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
On Mon, 24 May 1999, Bruce Momjian wrote:
> > What's it called? I only see some tcl frontend stuff. Despite my
> > pessimism form the prior message, I am interested in a full text retrieval
> > engine.
>
> It is called contrib/fulltextindex. Does someone want to suggest a
> better name?
I didn't see it on the ftp site. I only saw pgv and tcldb in the contrib
directory.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Cabbage, n.:
A familiar kitchen-garden vegetable about as large and wise as
a man's head.
-- Ambrose Bierce, "The Devil's Dictionary"
> On Mon, 24 May 1999, Bruce Momjian wrote: > > > > What's it called? I only see some tcl frontend stuff. Despite my > > > pessimism form the prior message, I am interested in a full text retrieval > > > engine. > > > > It is called contrib/fulltextindex. Does someone want to suggest a > > better name? > > I didn't see it on the ftp site. I only saw pgv and tcldb in the contrib > directory. Ah, here's the problem. Bruce means the contrib directory in the source distribution, which is at the top level, right beside src (were the core of postgresql lives). It's pgsql/contrib, if you do a CVS checkout. I'm not sure where it ends up in various binary packages. (/usr/lib/postgresql/contrib on my Debian Linux install, for example, has parts of it,m but not the whole thing) Ross -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
> On Mon, 24 May 1999, Bruce Momjian wrote: > > > > What's it called? I only see some tcl frontend stuff. Despite my > > > pessimism form the prior message, I am interested in a full text retrieval > > > engine. > > > > It is called contrib/fulltextindex. Does someone want to suggest a > > better name? > > I didn't see it on the ftp site. I only saw pgv and tcldb in the contrib > directory. Sorry, I meant in the distribution's contrib directory, not the ftp site. I didn't even know we had a contrib directory on the ftp site. -- 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
On Mon, 24 May 1999, Bruce Momjian wrote:
> Sorry, I meant in the distribution's contrib directory, not the ftp
> site. I didn't even know we had a contrib directory on the ftp site.
Wel, you do now! Thanks! I'll check it out!
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Once, adv.:
Enough.
-- Ambrose Bierce, "The Devil's Dictionary"
Going through the documentation I can only find little about outer joins. One statement is in the Changes doc about including syntax for outer joins, but there doesn't seem to be implemented any code after that. Is it true that there's no outer joins yet? Any plans? Btw. what is the syntax for outer joins. I know only Oracle's (+) operator.
Hey, found the module. Looks pretty interesting -- even has the
capability of ignoring stopwords. This is just what I am looking for!
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"What's the use of a good quotation if you can't change it?"
-- Dr. Who
He means the contrib directory in the source tree not the one on the ftp site. On Mon, 24 May 1999, bmccoy@lan2wan.com wrote: > On Mon, 24 May 1999, Bruce Momjian wrote: > > > > What's it called? I only see some tcl frontend stuff. Despite my > > > pessimism form the prior message, I am interested in a full text retrieval > > > engine. > > > > It is called contrib/fulltextindex. Does someone want to suggest a > > better name? > > I didn't see it on the ftp site. I only saw pgv and tcldb in the contrib > directory. > > Brett W. McCoy > http://www.lan2wan.com/~bmccoy > ----------------------------------------------------------------------- > Cabbage, n.: > A familiar kitchen-garden vegetable about as large and wise as > a man's head. > -- Ambrose Bierce, "The Devil's Dictionary" -- ------------------------------------------------------------------------------ Lincoln Spiteri Manufacturing Systems STMicroelectronics, Malta e-mail: lincoln.spiteri@st.com ------------------------------------------------------------------------------
On Mon, 24 May 1999, Lincoln Spiteri wrote:
> He means the contrib directory in the source tree not the one on the ftp site.
Yeah, we got that cleared up yesterday.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"Now this is a totally brain damaged algorithm. Gag me with a
smurfette."
-- P. Buhr, Computer Science 354
Sorry, I got this in my mail this morning, Due to a problem in the European Internet Gateway yesterday (solved this morning by xxxxx ), outgoing internet emails will suffer huge delays. The queue should be fully processed during next european night. Regards Lincoln On Tue, 25 May 1999, bmccoy@lan2wan.com wrote: > On Mon, 24 May 1999, Lincoln Spiteri wrote: > > > He means the contrib directory in the source tree not the one on the ftp site. > > Yeah, we got that cleared up yesterday. > > Brett W. McCoy > http://www.lan2wan.com/~bmccoy > ----------------------------------------------------------------------- > "Now this is a totally brain damaged algorithm. Gag me with a > smurfette." > -- P. Buhr, Computer Science 354 -- ------------------------------------------------------------------------------ Lincoln Spiteri Manufacturing Systems STMicroelectronics, Malta e-mail: lincoln.spiteri@st.com ------------------------------------------------------------------------------