Thread

1. Re: Mysql 321 - Mysql 322 - msql

   Marc G. Fournier <scrappy@hub.org> — 1998-11-27T12:54:57Z

   On Fri, 27 Nov 1998, Andrew McNaughton wrote:
   
   > It's possibly stronger on features, but it's slower than mysql.  It is
   > speed he's emphasizing.
   
   	I've never actually installed mysql, so can't really compare the
   two, but I've been using PostgreSQL for everything I need an RDBMS for
   since I first took on the project 3 years ago now (wow, time flies)...each
   release has gotten progressively faster, but we've pretty much hit a limit
   as far as optimizations are concerned, there probably isn't a *noticeable*
   difference between v6.3.2 and v6.4...
   
   	We are hoping to have the PREPARE statement put into v6.5, which
   should give a performance improvement in "repeatative queries", as the
   planning for the query can be done beforehand, taking out a step...
   
   > there was some discussion earlier this year on this list about adding
   > indexes suitable for fulltext searching  to PostgreSQL.  Did anything
   > happen in the end? It's the one feature I'd really like to have.  I
   > suspect it would be an important one to James also.
   
   	What do you mean by "fulltext searching"?
   
   Marc G. Fournier                                
   Systems Administrator @ hub.org 
   primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
   
   
   

2. Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql

   Tom Ivar Helbekkmo <tih@nhh.no> — 1998-11-27T13:25:00Z

   The Hermit Hacker <scrappy@hub.org> writes:
   
   > 	What do you mean by "fulltext searching"?
   
   He's talking about inverted text indices, where text is indexed such
   that a word is the key, and the index returns pointers to all the
   places where that word occurs.  Knowledge of word structure is usually
   built in, so that "hacks", "hacker", "hackers", "hacking" and so on
   are known to be derivatives of "hack", and can match it if requested.
   Noise words such as "a", "the" and so forth are usually not indexed.
   
   Inverted indexed text storage tends to take up much space, but there
   are ways to reduce this, and the best implementations do it remarkably
   well.  A simple example: it is not really necessary to actually store
   the original text; it can instead be a sequence of links to the store
   of all individual words in the text database.
   
   See http://glimpse.cs.arizona.edu/ for a powerful inverted indexing
   engine and various related software.
   
   -tih
   -- 
   Popularity is the hallmark of mediocrity.  --Niles Crane, "Frasier"
   
   

3. Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql

   Marc G. Fournier <scrappy@hub.org> — 1998-11-27T13:37:51Z

   On 27 Nov 1998, Tom Ivar Helbekkmo wrote:
   
   > The Hermit Hacker <scrappy@hub.org> writes:
   > 
   > > 	What do you mean by "fulltext searching"?
   > 
   > He's talking about inverted text indices, where text is indexed such
   > that a word is the key, and the index returns pointers to all the
   > places where that word occurs.  Knowledge of word structure is usually
   > built in, so that "hacks", "hacker", "hackers", "hacking" and so on
   > are known to be derivatives of "hack", and can match it if requested.
   > Noise words such as "a", "the" and so forth are usually not indexed.
   > 
   > Inverted indexed text storage tends to take up much space, but there
   > are ways to reduce this, and the best implementations do it remarkably
   > well.  A simple example: it is not really necessary to actually store
   > the original text; it can instead be a sequence of links to the store
   > of all individual words in the text database.
   > 
   > See http://glimpse.cs.arizona.edu/ for a powerful inverted indexing
   > engine and various related software.
   
   	Just curious, but other then specialized applications like
   Glimpse, does anyone actually support/do this?
   
   Marc G. Fournier                                
   Systems Administrator @ hub.org 
   primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
   
   
   

4. Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql

   Tom Samplonius <tom@sdf.com> — 1998-11-27T17:47:55Z

   On Fri, 27 Nov 1998, The Hermit Hacker wrote:
   
   > 	Just curious, but other then specialized applications like
   > Glimpse, does anyone actually support/do this?
   
     Well, Oracle has their ConText option that does stuff like this.
   
   > Marc G. Fournier                                
   > Systems Administrator @ hub.org 
   > primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
   
   Tom