Re: count * performance issue

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: "Greg Smith" <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: count * performance issue
Date: 2008-03-06 16:05:59
Message-ID: 937d27e10803060805h442eb120t73b2d256aabe1d51@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Mar 6, 2008 at 3:49 PM, Greg Smith <gsmith(at)gregsmith(dot)com> wrote:
>
> You only get this accelerated significantly when using MyISAM, which can
> tell you an exact count of all the rows it hasn't corrupted yet.

Please don't do that again. I'm going to have to spend the next hour
cleaning coffee out of my laptop keyboard.

:-)

--
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Lewis 2008-03-06 16:16:31 Re: count * performance issue
Previous Message Greg Smith 2008-03-06 15:49:33 Re: count * performance issue