Re: count * performance issue

From: Chris <dmagick(at)gmail(dot)com>
To: sathiya psql <sathiya(dot)psql(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: count * performance issue
Date: 2008-03-06 05:48:19
Message-ID: 47CF85A3.8080407@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

sathiya psql wrote:
> count(*) tooks much time...
>
> but with the where clause we can make this to use indexing,... what
> where clause we can use??
>
> Am using postgres 7.4 in Debian OS with 1 GB RAM,
>
> am having a table with nearly 50 lakh records,

Looks suspiciously like a question asked yesterday:

http://archives.postgresql.org/pgsql-performance/2008-03/msg00068.php

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message petchimuthu lingam 2008-03-06 05:57:36 Confirmação de envio / Sending confirmation (captchaid:13266b2056e4)
Previous Message Chris 2008-03-06 05:46:15 Re: Confirmação de envio / Sending confirmation (captchaid:13266b20536d)