Postgres Pro
Downloads
Home   >   mailing lists

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

From Jessica Richard
Subject select count(*) from a large table is very slow
Date
Msg-id 133912.35849.qm@web56406.mail.re3.yahoo.com
Whole thread Raw
Responses Re: select count(*) from a large table is very slow  (Kenneth Marshall <ktm@rice.edu>)
Re: select count(*) from a large table is very slow  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-admin
Tree view
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: Johann Spies
Date:
Subject: Re: ERROR: invalid memory alloc request size
Next
From: Kenneth Marshall
Date:
Subject: Re: select count(*) from a large table is very slow