If we compare them It should at least tell us what the server is doing
differently that is causing the query mis-behavior.
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
__ NOD32 3133 (20080526) Information __
On Mon, May 26, 2008 at 8:26 PM, Sebastian Rychter
<[EMAIL PROTECTED]> wrote:
> 2008-05-27 02:55:10 GMT LOG: duration: 112157.000 ms statement: SELECT
> 2008-05-27 03:07:29 GMT LOG: duration: 250.000 ms statement: SELECT
Wow, that is a big difference. I reformated your querys and diff'ed
the
Richard,
I'm not sure if this is the kind of log that you meant, but the one in
pg_log goes like this (the first query corresponding to the ODBC execution
(112157 ms), the second one is from pgAdmin (250 ms). I also logged for the
ODBC driver but didn't find any differences between the steps foll
