[postgis-users] Slow select from big table

[Rob Tester]

Sounds more like a question for the general group.  But, have you run a
vacuum analyze on the table ?

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Matt
Doughty
Sent: Wednesday, June 06, 2007 8:19 AM
To: postgis-users at postgis.refractions.net
Cc: Sergio Jorrín Abellán
Subject: [postgis-users] Slow select from big table

 

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/ba818cfd/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3743 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070606/ba818cfd/attachment.jpg>