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

From: "Taral" <taral(at)mail(dot)utexas(dot)edu>
To: "Bruce Momjian" <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: <jwieck(at)debis(dot)com>, <hackers(at)postgreSQL(dot)org>
Subject: RE: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)
Date: 1998-10-02 22:04:24
Message-ID: 000201bdee50$9d9c4320$3b291f0a@taral
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 1998-10-02 22:36:07 Re: [GENERAL] Bug in contrib/spi/refint.c
Previous Message Anand Surelia 1998-10-02 21:57:23 Bug in contrib/spi/refint.c

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-10-02 22:36:07 Re: [GENERAL] Bug in contrib/spi/refint.c
Previous Message Bruce Momjian 1998-10-02 21:58:00 Open 6.4 items