Re: High update activity, PostgreSQL vs BigDBMS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: High update activity, PostgreSQL vs BigDBMS
Дата
Msg-id 19873.1168224472@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: High update activity, PostgreSQL vs BigDBMS  ("Adam Rich" <adam.r@sbcglobal.net>)
Ответы Re: High update activity, PostgreSQL vs BigDBMS  ("Adam Rich" <adam.r@sbcglobal.net>)
Список pgsql-performance
"Adam Rich" <adam.r@sbcglobal.net> writes:
> I'm using 8.2 and using order by & limit is still faster than MAX()
> even though MAX() now seems to rewrite to an almost identical plan
> internally.

Care to quantify that?  AFAICT any difference is within measurement
noise, at least for the case of separately-issued SQL commands.

> Count(*) still seems to use a full table scan rather than an index scan.

Yup.  Don't hold your breath for something different.  Postgres has made
design choices that make certain cases fast and others slow, and
count(*) is one case that has come out on the short end of the stick.
If that's your most important measure of performance, then indeed you
should select a different database that's made different tradeoffs.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Adam Rich"
Дата:
Сообщение: Re: High update activity, PostgreSQL vs BigDBMS
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: High update activity, PostgreSQL vs BigDBMS