Postgres Pro
Downloads
Home   >   mailing lists

Re: Query optimization problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Query optimization problem
Date
Msg-id 21935.1170430984@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query optimization problem  (Peter <peter@greatnowhere.com>)
Responses Re: Query optimization problem  (Peter <peter@greatnowhere.com>)
List pgsql-general
Tree view 
Peter <peter@greatnowhere.com> writes:
>> Try SELECT count(*) FROM ... instead and see if the times are closer.

> Correct. That executes in 300ms flat:

So your problem is data transfer, not the query per se.

How old a pgAdmin are you using?

            regards, tom lane

pgsql-general by date:

Previous
From: Peter
Date:
Subject: Re: Query optimization problem
Next
From: Dave Page
Date:
Subject: Re: pgAdmin III and pgpass was I "might" have found a bug on 8.2.1 win32