Re: Query optimization problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter <peter(at)greatnowhere(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query optimization problem
Date: 2007-02-02 15:43:04
Message-ID: 21935.1170430984@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter <peter(at)greatnowhere(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. 2007-02-02 15:43:06 Re: Postgres SQL Syntax
Previous Message Hakan Kocaman 2007-02-02 15:41:24 Re: Functions, composite types and Notice