Re: CHECK constraints and optimizations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Edmund Dengler <edmundd(at)eSentire(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: CHECK constraints and optimizations
Date: 2004-05-07 01:02:21
Message-ID: 26714.1083891741@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> I can't see why this wouldn't work.

Doubtless you could do it. The problem with the idea is that those
inference tests are pretty expensive. I think that any such thing would
waste significant numbers of cycles on ordinary queries while only being
a win on a few poorly-written queries.

We do have to make a tradeoff between planning time and execution time,
and I fear that this idea is not going to be a win in those terms.
If you feel like experimenting, though, go for it ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-05-07 01:09:45 Re: creation permissions when moving from 7.2 -> 7.4
Previous Message Tom Lane 2004-05-07 00:52:28 Re: 7.2 or 7.4 for critical data?