At 06:07 PM 4/14/00 -0400, Tom Lane wrote:
>The Hermit Hacker <[EMAIL PROTECTED]> writes:
>> Well, with that simple change of (url.url || ''), the results go to being
>> much much more acceptable for a database whose ndict now contains
>> 6million+ tuples :)
>
>So are we going to stand down from panic mode, or should I still plan on
>squeezing in a first-cut LIKE estimator tomorrow?
While the size of Marc's database is probably unusually large, the
kind of querying he is doing is pretty common, really. For instance,
the ACS toolkit does this to allow one to search for users by
their login e-mail name, which are each unique just like in Marc's
search case.
So as much as I'm eager to see PG 7.0 roll out the door, I'd like
to see improvement in this area. We're rolling our first major
release of the toolkit to run on PG 7.0 only so I suppose folks
wouldn't notice that these searches are slower than in PG 6.5! :)
(and of course no site using our toolkit is likely to have 6
million users registered in my lifetime!)
- Don Baccus, Portland OR <[EMAIL PROTECTED]>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]
