Re: Yet Another COUNT(*)...WHERE...question

Поиск
Список
Период
Сортировка
От Rainer Bauer
Тема Re: Yet Another COUNT(*)...WHERE...question
Дата
Msg-id q499c3p18grufr921991kh7s99rea7hvmj@4ax.com
обсуждение исходный текст
Ответ на Re: Yet Another COUNT(*)...WHERE...question  (Rainer Bauer <usenet@munnin.com>)
Список 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 по дате отправления:

Предыдущее
От: "D. Dante Lorenso"
Дата:
Сообщение: Re: SELECT ... FOR UPDATE performance costs? alternatives?
Следующее
От: Dave Page
Дата:
Сообщение: Re: Running a stored procedure via pgagent, need an examp le