PFC <[EMAIL PROTECTED]> writes: > The IN() is quite small (150 values), but the two large tables are > seq-scanned... is there a way to avoid this ?
Not in 8.1. HEAD is a bit smarter about joins to Append relations. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org