Postgres Pro
Downloads
Home   >   mailing lists

select count(*) performance - Mailing list pgsql-performance

From runic
Subject select count(*) performance
Date
Msg-id 1186578085.034463.116030@q75g2000hsh.googlegroups.com
Whole thread Raw
Responses Re: select count(*) performance
Re: select count(*) performance
Re: select count(*) performance
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "slawekj"
Date:
Subject: Re: select count(*) performance
Next
From: Piotr Kołaczkowski
Date:
Subject: Re: Update table performance