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>, <jwieck(at)debis(dot)com>
Cc:
<hackers(at)postgreSQL(dot)org>
Subject:
RE: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)
Date:
1998-10-02 21:12:19
Message-ID:
000001bdee49$56c7cd40$3b291f0a@taral (view raw or flat )
Thread:
1998-09-27 09:20:35 from "Sergei Chernev" <ser(at)nsu(dot)ru>
1998-09-28 13:21:08 from David Hartwig <daveh(at)insightdist(dot)com>
1998-09-28 17:15:01 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-01 22:54:19 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-01 23:45:33 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-02 02:18:29 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-02 05:35:12 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-02 06:02:48 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-02 16:37:15 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-02 16:40:56 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-02 16:47:48 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-02 17:31:18 from jwieck(at)debis(dot)com (Jan Wieck)
1998-10-02 17:58:25 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-02 21:12:19 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-02 21:39:05 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-02 21:49:26 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-02 21:57:15 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-02 22:04:24 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-03 03:01:07 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-04 01:57:30 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-04 02:26:20 from "Taral" <taral(at)mail(dot)utexas(dot)edu>
1998-10-04 03:32:14 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-05 14:33:37 from David Hartwig <daveh(at)insightdist(dot)com>
1998-10-06 02:23:13 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-06 15:28:22 from David Hartwig <daveh(at)insightdist(dot)com>
1998-10-07 02:41:21 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-07 17:56:18 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-07 20:34:15 from David Hartwig <daveh(at)insightdist(dot)com>
1998-10-07 21:33:07 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
1998-10-02 17:40:39 from Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Lists:
pgsql-general pgsql-hackers
> Another idea is that we rewrite queries such as:
>
> SELECT *
> FROM tab
> WHERE (a=1 AND b=2 AND c=3) OR
> (a=1 AND b=2 AND c=4) OR
> (a=1 AND b=2 AND c=5) OR
> (a=1 AND b=2 AND c=6)
>
> into:
>
> SELECT *
> FROM tab
> WHERE (a=1 AND b=2) AND (c=3 OR c=4 OR c=5 OR c=6)
Very nice, but that's like trying to code factorization of numbers... not
pretty, and very CPU intensive on complex queries...
Taral
In response to
Responses
pgsql-hackers by date
Next :From: Bruce MomjianDate: 1998-10-02 21:34:05Subject : Re: [HACKERS] Open 6.4 itemsPrevious :From : teunisDate : 1998-10-02 20:08:23Subject : egcs, glibc-2.0.7, linux - any problems known?
pgsql-general by date
Next :From: Bruce MomjianDate: 1998-10-02 21:39:05Subject : Re: [HACKERS] RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)Previous :From : Greg YoungbloodDate : 1998-10-02 19:09:06Subject : Please help with performance tuning on Postgres
