From: | "Reuven M(dot) Lerner" <reuven(at)lerner(dot)co(dot)il> |
---|---|
To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) |
Date: | 2013-05-25 23:21:13 |
Message-ID: | 51A14769.1080409@lerner.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi, Dave. Thanks for the response. You wrote:
> The problem lies in the fact that JDBC uses an unnamed statement to do
> the query. The planner can't plan these very well as the parameters are
> not available at plan time.
Is there any way to avoid this, and to give the planner more hints? Is
there an option in JDBC that can give us a more direct connection?
>
> This does not explain the slowness on linux however. Is postgresql tuned
> on linux, or windows ?
The tuning suggestions that I've given were pretty plain overall, and
mostly involved changing the amounts given to shared_buffers and
effective_cache_size. I know that I gave them suggestions for the Linux
box, so if any tuning was done, it was actually there. I was quite
surprised to hear that they were even trying it on Windows, let alone
that it gave significantly better performance.
On the Linux side, they've switched from ext3 to (non-journaled) ext2,
to improve performance. Execution is excellent on Linux, except via
JDBC and bound parameters.
Any other suggestions regarding the differences between Windows and
Linux? As you can imagine, this is really puzzling me (er, us).
Reuven
--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
http://lerner.co.il * Skype/AIM: reuvenlerner
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2013-05-25 23:28:13 | Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) |
Previous Message | Dave Cramer | 2013-05-25 23:03:11 | Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) |