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: (view raw, whole thread or download thread mbox)
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
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

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-2017 The PostgreSQL Global Development Group