Postgres Pro
Downloads
Home   >   mailing lists

Faster 'select count(*) from table' ? - Mailing list pgsql-performance

From Matt Mello
Subject Faster 'select count(*) from table' ?
Date
Msg-id 3E5BF1BD.9070301@spaceship.com
Whole thread Raw
In response to Re: Really bad insert performance: what did I do wrong?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Faster 'select count(*) from table' ?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
Tree view 
Does anyone know if there is a fast way to find out how many records are
in a table?

"Select count(*) from table" is very slow.

I would think that PG would keep up with the number of undeleted rows on
a realtime basis.  Is that the case?  If so, how would I query it?

Hope this is the correct list for this question.

Thanks!

--
Matt Mello

pgsql-performance by date:

Previous
From: Peter Childs
Date:
Subject: Re: slow query
Next
From: "scott.marlowe"
Date:
Subject: Re: Faster 'select count(*) from table' ?