Thread

1. Re: indexing words

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-03-31T15:28:29Z

   > 
   > On Mon, 30 Mar 1998, Bruce Momjian wrote:
   > 
   > > With the CLUSTER change, are things faster.  Can you give me some times?
   > > Can you supply some source to put into contrib/?
   > 
   > I did some timing after I clustered the data. However, I remember no 
   > spectacular speedups. Maybe I remember wrong. I'll do the timings again 
   > tonight and send them to you. I'd be happy to send sources to be put into 
   > contrib, but I might need some help cleaning it up so ppl can actually 
   > *use* it (an easy build, maybe some script to create the correct 
   > tables/indices for a particular setup etc.)
   > 
   > I also think it would be nice if there was a function that could be 
   > called to build the index *after* the main table is populated. Might be 
   > much faster for large tables (but then again, it might not be).
   > 
   > Give me some time (end of the week?), I'm very busy with graduating right 
   > now :)
   
   Great.  Remember, we have an problem with the optimizer and referencing
   two tables by different names, so that may be part of the problem with
   performance.
   
   At this point, I would be interested in just hearing about single and
   two word search times.
   
   The CLUSTER really speeded up things here.
   
   
   -- 
   Bruce Momjian                          |  830 Blythe Avenue
   maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
     +  If your life is a hard drive,     |  (610) 353-9879(w)
     +  Christ can be your backup.        |  (610) 853-3000(h)
   
   

2. Re: indexing words

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-04-26T04:05:40Z

   Hate to bother you again, but do you think you can test speed with
   CLUSTER, and have the text indexing packaged up for /contrib by the time
   we release 6.4, with beta August 1?
   
   With 6.3.* closed, there is no rush on any of this.
   
   > 
   > On Mon, 30 Mar 1998, Bruce Momjian wrote:
   > 
   > > With the CLUSTER change, are things faster.  Can you give me some times?
   > > Can you supply some source to put into contrib/?
   > 
   > I did some timing after I clustered the data. However, I remember no 
   > spectacular speedups. Maybe I remember wrong. I'll do the timings again 
   > tonight and send them to you. I'd be happy to send sources to be put into 
   > contrib, but I might need some help cleaning it up so ppl can actually 
   > *use* it (an easy build, maybe some script to create the correct 
   > tables/indices for a particular setup etc.)
   > 
   > I also think it would be nice if there was a function that could be 
   > called to build the index *after* the main table is populated. Might be 
   > much faster for large tables (but then again, it might not be).
   > 
   > Give me some time (end of the week?), I'm very busy with graduating right 
   > now :)
   > 
   > Maarten
   > 
   > _____________________________________________________________________________
   > | TU Delft, The Netherlands, Faculty of Information Technology and Systems  |
   > |                   Department of Electrical Engineering                    |
   > |           Computer Architecture and Digital Technique section             |
   > |                          M.Boekhold@et.tudelft.nl                         |
   > -----------------------------------------------------------------------------
   > 
   > 
   
   
   -- 
   Bruce Momjian                          |  830 Blythe Avenue
   maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
     +  If your life is a hard drive,     |  (610) 353-9879(w)
     +  Christ can be your backup.        |  (610) 853-3000(h)
   
   

3. Re: indexing words

   Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl> — 1998-04-26T08:37:09Z

   On Sun, 26 Apr 1998, Bruce Momjian wrote:
   
   > Hate to bother you again, but do you think you can test speed with
   > CLUSTER, and have the text indexing packaged up for /contrib by the time
   > we release 6.4, with beta August 1?
   > 
   > With 6.3.* closed, there is no rush on any of this.
   
   Oh, august 1 should be no problem.
   
   Maarten
   
   _____________________________________________________________________________
   | TU Delft, The Netherlands, Faculty of Information Technology and Systems  |
   |                   Department of Electrical Engineering                    |
   |           Computer Architecture and Digital Technique section             |
   |                          M.Boekhold@et.tudelft.nl                         |
   -----------------------------------------------------------------------------