Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)
Дата
Msg-id 199810030301.XAA01160@candle.pha.pa.us
обсуждение исходный текст
Ответ на RE: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)  ("Taral" <taral@mail.utexas.edu>)
Список pgsql-hackers
[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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Bug in contrib/spi/refint.c
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: Antwort: Patches for gram.y and keywords.c