| 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: | Whole Thread | Raw Message | 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 |