| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: SELECT very slow |
| Date: | 2005-06-16 15:33:19 |
| Message-ID: | d8s5q1$5ud$1@sea.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 16.06.2005 17:29 PFC wrote:
>> If autocommit is on (or fetch size is zero) then the driver will
>> build the whole
>> result set before returning to the caller.
>
>
> Sure, but that is not your problem : even building the whole result
> set should not take longer than a few seconds (I gave you test timings
> in a previous message).
> So... what ?
> What does the taskman say ? CPU at 100% ? how much kernel time ?
>
Taskmanager (I'm on windows) does not show any high CPU usage. And (as I wrote
in the initial post) I cannot see any memory increase in the PG process as well
(which I would expect with a result set of that size built up in memory).
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Din Adrian | 2005-06-16 17:11:17 | Re: [SQL] PostgreSQL and Delphi 6 |
| Previous Message | PFC | 2005-06-16 15:29:32 | Re: SELECT very slow |