RE: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)
Taral <taral@mail.utexas.edu>
From: "Taral" <taral@mail.utexas.edu>
To: "Bruce Momjian" <maillist@candle.pha.pa.us>
Cc: <jwieck@debis.com>, <hackers@postgreSQL.org>
Date: 1998-10-02T22:04:24Z
Lists: pgsql-hackers, pgsql-general
> How do we do that with UNION, and return the right rows. Seems the > _join_ happending multiple times would be much worse than the factoring. Ok... We have two problems: 1) DNF for unjoined queries. 2) Factorization for the rest. I have some solutions for (1). Not for (2). Remember that unjoined queries are quite common. :) For (1), we can always try to parallel the multiple queries... especially in the case where a sequential search is required. Taral