| From: | PFC <lists(at)boutiquenumerique(dot)com> |
|---|---|
| To: | "Thomas Kellerer" <spam_eater(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: SELECT very slow |
| Date: | 2005-06-16 15:29:32 |
| Message-ID: | op.ssgyniecth1vuj@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> 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 ?
>
> http://jdbc.postgresql.org/documentation/80/query.html#query-with-cursor
>
> Thomas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2005-06-16 15:33:19 | Re: SELECT very slow |
| Previous Message | grupos | 2005-06-16 15:10:25 | Re: SELECT with sum on groups ORDERING by the subtotals |