Re: Yet Another COUNT(*)...WHERE...question - Mailing list pgsql-general

From Rodrigo De León
Subject Re: Yet Another COUNT(*)...WHERE...question
Date
Msg-id 1187279493.226383.306630@d55g2000hsg.googlegroups.com
Whole thread Raw
In response to Re: Yet Another COUNT(*)...WHERE...question  (Decibel! <decibel@decibel.org>)
List pgsql-general
On Aug 16, 5:19 am, deci...@decibel.org (Decibel!) wrote:
> On Thu, Aug 16, 2007 at 12:12:03PM +0200, Rainer Bauer wrote:
> > "Scott Marlowe" wrote:
> > But if you go to eBay, they always give you an accurate count. Even if the no.
> > of items found is pretty large (example: <http://search.ebay.com/new>).
>
> And I'd bet money that they're using a full text search of some kind to
> get those results, which isn't remotely close to the same thing as a
> generic SELECT count(*).

http://www.addsimplicity.com/downloads/eBaySDForum2006-11-29.pdf

Search for the text "Scaling Search".

Interesting stuff.


pgsql-general by date:

Previous
From: "Rajaram J"
Date:
Subject: I get a error msg when i try to connect to the DB
Next
From: Rainer Bauer
Date:
Subject: Re: Yet Another COUNT(*)...WHERE...question