Postgres Pro
Downloads
Home   >   mailing lists

Re: select count(*) from a large table is very slow - Mailing list pgsql-admin

From Kenneth Marshall
Subject Re: select count(*) from a large table is very slow
Date
Msg-id 20070518131920.GA7069@it.is.rice.edu
Whole thread Raw
In response to select count(*) from a large table is very slow  (Jessica Richard <rjessil@yahoo.com>)
Responses Re: select count(*) from a large table is very slow  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-admin
Tree view 
Make a summary table and select from there instead.

Ken

On Fri, May 18, 2007 at 06:15:25AM -0700, Jessica Richard wrote:
> I have a ~30 milliow row table, select count(*) from this table is very very very slow...
>
> How dow I get it run faster?
>
> Thanks,
> Jessica
>
>
> ---------------------------------
> We won't tell. Get more on shows you hate to love
> (and love to hate): Yahoo! TV's Guilty Pleasures list.

pgsql-admin by date:

Previous
From: Jessica Richard
Date:
Subject: select count(*) from a large table is very slow
Next
From: Jessica Richard
Date:
Subject: select from dblink very slow