Re: Constant propagation and similar issues - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Constant propagation and similar issues
Date
Msg-id 39BD0A2D.FFD47129@alumni.caltech.edu
Whole thread Raw
In response to Constant propagation and similar issues  (Jules Bean <jules@jellybean.co.uk>)
Responses Re: Constant propagation and similar issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Constant propagation and similar issues  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
> AFAIK hardly anyone actually uses CURRENT, and I've been thinking of
> proposing that we eliminate it to make the world safe for constant-
> folding timestamp operations.  (Thomas, any comments here?)

Well, it is a feature from "the old days". Pretty neat one at that, and
is an example of a useful feature not found in other DBs or in
standards, but which might show up someday because they are useful.
Throwing those things away one at a time will end us up at the lowest
common denominator, eventually :(

Another way of looking at the problem is to ask how we could retain this
feature in the face of the other optimization "desirements". istm that
types which have multiple behaviors could be queried for the behavior of
a particular example by the optimizer. For most types, a "query" would
not be necessary (so there is minimal overhead), but for this case a
function could return the property of an example as either cachable or
not.

Perhaps a true "serial type" would need similar behaviors, as might
other future types.
                  - Thomas


pgsql-hackers by date:

Previous
From: "Martin A. Marques"
Date:
Subject: Re: problems with GRANT on Solaris 8
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Re: when does CREATE VIEW not create a view?