[postgis-users] Slow select from big table

Webb Sprague webb.sprague at gmail.com
Wed Jun 6 09:40:31 PDT 2007


Are you using the psql shell or pgAdmin? I ask because the shell
doesn't have an "about" menu :)  Can you try your query from the shell
just for grins?

Also -- did you specify which OS?

On 6/6/07, Matt Doughty <matt.doughty at geograma.com> wrote:
> Sorry, meant to say 8.2.something (not sure about what sub-sub-version it is). It's the version released in March.
>
> The 1.6.3 came from the About... in the Help menu.

Darn - that would have been a quick fix !

>
> 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
>
>
>
> -----Mensaje original-----
> De: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] En nombre de Webb Sprague
> Enviado el: miércoles, 06 de junio de 2007 18:26
> Para: PostGIS Users Discussion
> Asunto: Re: [postgis-users] Slow select from big table
>
> What is this?
>
> > Version 1.6.3.
>
> The latest postgresql is 8.2.4, and the latest postgis is 1.2.1.
>
> Am I missing something (wouldn't be the first time...)?
> _______________________________________________
> 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
>



More information about the postgis-users mailing list