| From: | "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | "Sebastian Rychter" <srychter(at)anvet(dot)com(dot)ar> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Extremely Low performance with ODBC |
| Date: | 2008-05-23 16:03:56 |
| Message-ID: | 396486430805230903k7f85f358va55fe8ab09a17eed@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, May 22, 2008 at 11:29 AM, Sebastian Rychter
<srychter(at)anvet(dot)com(dot)ar> wrote:
> Hi, I'm executing a query through psql ODBC which is taking around 2 minutes
> to complete. When I run it from PgAdmin it takes less than 3 seconds.
>
> Any idea ?
1) turn off all ODBC query logging from both the ODBC driver and the
ODBC administrator. This feature is a performance killer. Only use
this feature if you are trying to debug a problem.
2) Some client programs try to perform the joins on the client side
rather than the server side. I would check if the client is actually
passing the actual SQL statement back to the server. If it is trying
to perform the join on the client, it could be a big performance
killer.
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastian Rychter | 2008-05-23 16:47:56 | Re: Extremely Low performance with ODBC |
| Previous Message | Craig Ringer | 2008-05-23 08:53:00 | Re: Extremely Low performance with ODBC |