Re: count(*) slow on large tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Christopher Browne <cbbrowne(at)libertyrms(dot)info>, pgsql-performance(at)postgresql(dot)org
Subject: Re: count(*) slow on large tables
Date: 2003-10-04 18:34:32
Message-ID: 20792.1065292472@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> It doesn't seem complex enough for a separate TODO.detail item.

I thought it was, if only because it is so easy to think of wrong
implementations.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-10-04 18:38:57 Re: pg_dump bug in 7.4
Previous Message Tom Lane 2003-10-04 18:24:40 Re: pg_dump bug in 7.4

Browse pgsql-performance by date

  From Date Subject
Next Message Hannu Krosing 2003-10-04 20:59:00 Re: COUNT(*) again (was Re: [HACKERS] Index/Function
Previous Message Bruce Momjian 2003-10-04 18:19:46 Re: count(*) slow on large tables