On Tue, Dec 9, 2008 at 6:56 AM, Thomas Guettler <hv@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
