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

From Rainer Bauer
Subject Re: Yet Another COUNT(*)...WHERE...question
Date
Msg-id q499c3p18grufr921991kh7s99rea7hvmj@4ax.com
Whole thread Raw
In response to Re: Yet Another COUNT(*)...WHERE...question  (Rainer Bauer <usenet@munnin.com>)
List pgsql-general
"Scott Marlowe" wrote:

>FYI, I went to the ebay page you posted, which listed something like
>98011 pages, and asked for page 96000.  It searched for about a minute
>and timed out with the error message
>
>There was a problem executing your request. Please try again.
>
>Tried it again, twice, about 5 minutes apart, and got the same error each time.
>
>So I'm guessing that ebay is better at making your THINK it has the
>exact count than actually having the exact count.

Well that depends on the current traffic on eBay. It worked allright this
afternoon (GMT), but I get the same error message now (btw, a few years ago
you only got an error message if a search retruned more than 1M items).

Try it with this search: <http://search.ebay.com/new> which gives about 2.2M
items.

Rainer

pgsql-general by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Re: SELECT ... FOR UPDATE performance costs? alternatives?
Next
From: Dave Page
Date:
Subject: Re: Running a stored procedure via pgagent, need an examp le