On 11/30/12 8:30 AM, Ivan Marchesini wrote:
Thanks but as I said I have tried using psql directly on the server. And still there is a strong difference between the queries execution time with and without the geometric field. May be it is a problem of clients but I obtain the same problem with pgadmin, psql and other servers. So I suppose it is not. :-)
query without Geometry is returning 1474 tuples of 133 bytes each. thats about 200 kbytes worth of tuples which have to be sorted, then converted to client format.
query WITH geometry is returning 1474 tuples of 196111 bytes each. thats about 300MB which have to be sorted, then converted to client format.
you're surprised handling 300MB takes longer than 200KB? -- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
