Re: joint prefetching narrows result set

From: Bryan Lewis (brya..aine.rr.com)
Date: Thu Apr 20 2006 - 10:18:48 EDT

  • Next message: Bryan Lewis: "Re: PK problem with Postgre"

    Cool, thanks. Gotta switch my bookmark over to the new docs!

    Andrus Adamchik wrote:

    >
    > On Apr 20, 2006, at 4:28 AM, Bryan Lewis wrote:
    >
    >> Maybe it's common knowledge that one shouldn't specify a joint prefetch
    >> on such a relationship? (The old non-joint prefetch with its separate
    >> query didn't cause any trouble, of course.) I didn't see this
    >> discussed
    >> in the user guide. It's not a big deal but I thought I'd mention it in
    >> case I'm doing something wrong or it's not common knowledge.
    >
    >
    > Bryan,
    >
    > It is mentioned briefly in the new docs (last item under prefetching
    > hints) -
    >
    > http://objectstyle.org/confluence/display/CAYDOC/Prefetching
    >
    > This is a totally arbitrary limitation. In the following releases
    > we'll add support for the outer joins and this will become a non-issue.
    >
    > Andrus
    >



    This archive was generated by hypermail 2.0.0 : Thu Apr 20 2006 - 10:19:20 EDT