[postgis-users] Slow select from big table

[Matt Doughty]

I'm trying out a vacuum at the moment to see if it helps.

 

 

 

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

 

 

________________________________

De: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] En nombre de Rob Tester
Enviado el: miércoles, 06 de junio de 2007 17:23
Para: 'PostGIS Users Discussion'
Asunto: RE: [postgis-users] Slow select from big table

 

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/10804933/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/10804933/attachment.jpg>