On Tue, Dec 9, 2008 at 6:56 AM, Thomas Guettler <hv(at)tbz-pariv(dot)de> wrote:
> Hi,
>
> I have a two tables: master and detail.
> I search all master rows without a detail row.
>
> master: 10000 rows
> detail: 29800 rows
>
> Although all three solution have the same result, The execution time
> differs very much.
post your postgresql version.
btw, 8.4 is going to be much smarter about converting these types of
plans. in the meantime, just use joins wherever possible.
merlin