Re: Performance of count(*)

Поиск
Список
Период
Сортировка
От Andreas Tille
Тема Re: Performance of count(*)
Дата
Msg-id Pine.LNX.4.62.0703221239570.13747@wr-linux02
обсуждение исходный текст
Ответ на Re: Performance of count(*)  (Andreas Kostyrka <andreas@kostyrka.org>)
Ответы Re: Performance of count(*)  (Andreas Kostyrka <andreas@kostyrka.org>)
Re: Performance of count(*)  ("Luke Lonergan" <llonergan@greenplum.com>)
Список pgsql-performance
On Thu, 22 Mar 2007, Andreas Kostyrka wrote:

> Which version of PG?

Ahh, sorry, forgot that.  The issue occurs in Debian (Etch) packaged
version 7.4.16.  I plan to switch soon to 8.1.8.

> That's the reason why PG (check the newest releases, I seem to
> remember that there has been some aggregate optimizations there),

I'll verify this once I moved to the new version.

> does
> a SeqScan for select count(*) from table. btw, depending upon your
> data, doing a select count(*) from table where user=X will use an
> Index, but will still need to fetch the rows proper to validate them.

I have an index on three (out of 7 columns) of this table.  Is there
any chance to optimize indexing regarding this.

Well, to be honest I'm not really interested in the performance of
count(*).  I was just discussing general performance issues on the
phone line and when my colleague asked me about the size of the
database he just wonderd why this takes so long for a job his
MS-SQL server is much faster.  So in principle I was just asking
a first question that is easy to ask.  Perhaps I come up with
more difficult optimisation questions.

Kind regards

         Andreas.

--
http://fam-tille.de

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

Предыдущее
От: ismo.tuononen@solenovo.fi
Дата:
Сообщение: Re: Performance of count(*)
Следующее
От: David Brain
Дата:
Сообщение: Potential memory usage issue