[postgis-users] Slow select from big table

[Matt Doughty]

Hi List,

 

I've got a simple question, how can I speed up this query? 

 

SELECT COUNT (*) FROM table1

 

Currently it's taking a little more than five minutes to run on a table with 3.4 m rows. The table is gist indexed. Is it normal that Postgres takes so long?

 

Cheers,

 

Matt

 

 

 

Matt Doughty

 

GEOGRAMA S.L.

Tel.:  +34 945 13 13 72    652 77 14 15

Fax: +34 945 23 03 40 

www.geograma.com

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070606/f2bad899/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3743 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070606/f2bad899/attachment.jpg>