| From: | Mark Lewis <mark(dot)lewis(at)mir3(dot)com> |
|---|---|
| To: | Patric Bechtel <bechtel(at)ipcon(dot)de> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Query length restriction in v3 protocol? |
| Date: | 2006-05-11 17:08:02 |
| Message-ID: | 1147367282.32369.114.camel@archimedes |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Thu, 2006-05-11 at 10:26 +0800, Patric Bechtel wrote:
> > The outer join improvements are already in CVS HEAD:
> >
> > http://archives.postgresql.org/pgsql-performance/2006-02/msg00342.php
> >
> > If you test with CVS HEAD could you please post your results back here?
> > I know I'd be really interested in the results.
> >
> from the mail: "
> CVS HEAD can re-order left joins in common cases, but no existing
> release will touch the ordering of outer joins at all.
> "
A "left join" is an abbreviation for "left outer join", which is the
kind of outer join that Hibernate uses, and the left join re-ordering
fixes are definitely in CVS HEAD right now so I would anticipate you
would see a performance boost.
There's more discussion of the specific changes in the archives for the
performance mailing list, if you're interested.
-- Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andre Bialojahn | 2006-05-14 12:07:46 | Updated German translation |
| Previous Message | Kris Jurka | 2006-05-11 03:11:27 | Re: Bug with callable statement and output parameters |