Michael, Actually, you missed an alias :) the select now returned 800k rows! (according to explain)
pointed it out below. See my prev mail for more. If it's possible, try your query on a backend and look for notices like "Adding missing FROM clause for table ..." G. ------------------------------- cut here ------------------------------- ----- Original Message ----- From: "Michael Mattox" <[EMAIL PROTECTED]> Cc: "Postgresql Performance" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 4:09 PM > from monitorx m, monitorstatusx ms, monitorstatusitemx msi > where m.idx = 'M-TEST_1444-TEST_00_10560561260561463219352' AND > monitorx.jdoidx = ms.monitorx AND ^^^^^^^^ substitute the same alias "m" here. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
