[postgis-users] Slow select from big table

[volunteer at spatiallink.org]

what if
select count(*) from table where true;
??

sincerely
siva

-------- Original Message --------
Subject: RE: [postgis-users] Slow select from big table
From: "Matt Doughty" <matt.doughty at geograma.com>
Date: Wed, June 06, 2007 11:30 am
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>

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
  
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- 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/98dedbc9/attachment.jpg>