Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: taral@mail.utexas.edu (Taral)
Cc: jwieck@debis.com, hackers@postgreSQL.org
Date: 1998-10-03T03:01:07Z
Lists: pgsql-hackers, pgsql-general
[Charset iso-8859-1 unsupported, filtering to ASCII...] > > 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. I don't know how to return the proper rows with UNION. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026