Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Erik JonesDate: 2007-08-08 15:15:41
Subject: Re: Update table performance
Previous:From: Enrico WeigeltDate: 2007-08-08 12:40:54
Subject: Performance on writable views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group