From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | Peter <peter(at)greatnowhere(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Query optimization problem |
Date: | 2007-02-02 14:00:32 |
Message-ID: | 45C34400.9070600@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Richard Huxton wrote:
> Peter wrote:
>>
>> Query returned successfully with no result in 600 ms.
>>
>> Why SELECT takes 3+ second to execute? Is it something to do with my
>> Postgres server optimization, or PgAdmin does not show correct data
>> retrieval runtime (leaks over into query runtime or something)?
>
> Data transfer and display time usually.
>
> Try SELECT count(*) FROM ... instead and see if the times are closer.
>
The display time in pgAdmin 1.6 and above is negligible (ie.
microseconds). That's why it no longer shows 2 times as previous
versions did.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2007-02-02 14:10:12 | Re: database backup trouble |
Previous Message | John D. Burger | 2007-02-02 13:50:14 | Re: How to allow users to log on only from my application |