[postgis-users] Slow select from big table

Gerry Creager gerry.creager at tamu.edu
Wed Jun 6 08:53:54 PDT 2007


What version of the database code are you running?

volunteer at spatiallink.org wrote:
> 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
> 
> 
> ------------------------------------------------------------------------
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Gerry Creager -- gerry.creager at tamu.edu
Texas Mesonet -- AATLT, Texas A&M University
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.862.3983
Office: 1700 Research Parkway Ste 160, TAMU, College Station, TX 77843





More information about the postgis-users mailing list