| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au> |
| Cc: | Josué Maldonado <josue(at)lamundial(dot)hn>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tunning postgresql |
| Date: | 2003-11-21 21:53:33 |
| Message-ID: | 3FBE895D.7080100@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Stephen Robert Norris wrote:
>
>This looks pretty good - 1.7ms is very quick for a query. If you're
>seeing performance problems, it must be from the ODBC layer.
>
>
>
I recall striking this sort of problem with old Oracle ODBC drivers - we
used to set "Pass Through" mode for all the queries. However, I am don't
know if the Pg driver supports it (or if it would actually help
significantly).
Might be worth trying out some other ODBC drivers for Pg. I am pretty
sure there are some, however I can recall the brands :-(
regards
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-11-21 21:58:42 | Re: ERROR: nodeRead: did not find '}' [x2] |
| Previous Message | Lamar Owen | 2003-11-21 21:27:32 | Re: First generic/redhatish RPM's uploaded to ftp.postgresql.org. |