Quick Links

select count(*) performance

From:	runic <runic(at)gmx(dot)de>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	select count(*) performance
Date:	2007-08-08 13:01:25
Message-ID:	1186578085.034463.116030@q75g2000hsh.googlegroups.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

Hello Group,

I'm new in PostgreSQL Business, therefore please forgive me a "newbie"
Question. I have a table with ca. 1.250.000 Records. When I execute
a "select count (*) from table" (with pgAdmin III) it takes about 40
secs.
I think that takes much to long. Can you please give me hints, where
I can search for Improvements?

TIA, Det

Responses

Re: select count(*) performance at 2007-08-09 14:44:41 from slawekj
Re: select count(*) performance at 2007-08-10 11:44:21 from Merlin Moncure
Re: select count(*) performance at 2007-08-10 13:08:18 from Brian Hurt
Re: select count(*) performance at 2007-08-11 15:54:41 from Detlef Rudolph

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Erik Jones	2007-08-08 15:15:41	Re: Update table performance
Previous Message	Enrico Weigelt	2007-08-08 12:40:54	Performance on writable views