[sNip]
>> bearing in mind that this index can be used with queries that contain
>> WHERE conditions like "create_date >= some-date-constant". The planner
>> must be able to convince itself that the right-hand side of the WHERE
>> condition is >= the cutoff in the index's predicate condition. Sinc
Tom Lane <[EMAIL PROTECTED]> writes:
> No, because the above represents a moving cutoff; it will (and should)
> be rejected as a non-immutable predicate condition. You could do
> something like
>
> CREATE INDEX my_Nov_03_index on my_table (create_date)
> WHERE (cre
"Randolf Richardson, DevNet SysOp 29" <[EMAIL PROTECTED]> writes:
> For the application I will need to develop in the future, it would be
> okay for this index to hold data more than 30 days old, and then be
> redefined on a monthly basis along with regular database vacuuming (and
> other
>> For example, if I want to index on a date field but only have the index
>> keep track of the most recent 30 days (and then create a secondary
>> index for all dates) so as to improve performance on more heavily
>> loaded systems.
>>
>> Am I understanding this new terminology correctly? Thank
"Randolf Richardson, DevNet SysOp 29" <[EMAIL PROTECTED]> writes:
> For example, if I want to index on a date field but only have the index
> keep track of the most recent 30 days (and then create a secondary index for
> all dates) so as to improve performance on more heavily loaded syste
[sNip]
>> I have been considering using "calculated index" or "computed index"
>> but dunno if that really conveys anything.
>
> Well, "Expression Indexes" is the most accurate. Or "Expression-Based
> Indexes."
What is the proposed definition of an "Expression Index?"
When I se
Tom Lane writes:
> Mainly that "expressional" is a made-up word.
At least it's better than "functional index", because I had always
wondered where the dysfunctional indexes went. :)
I like "expression index".
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcas
Josh Berkus wrote:
> Tom,
>
> > Mainly that "expressional" is a made-up word.
>
> So? We're in the tech biz, Tom. New-coined words are expected. And that
> way nobody will expect it to mean something else, since we made it up.
> -- H. Dumpty, Q.E.D.
>
> > I have been considering using "ca
Tom,
> Mainly that "expressional" is a made-up word.
So? We're in the tech biz, Tom. New-coined words are expected. And that
way nobody will expect it to mean something else, since we made it up.
-- H. Dumpty, Q.E.D.
> I have been considering using "calculated index" or "computed index"
>
Tom,
Jumping lists, NOVICE is unlikely to have an opinion about this.
> I'm not particularly happy with the phrase "expressional index", and
> would like to think of something else to use before the 7.4 docs go
> final. Any ideas?
Hmmm ... well, actually, I like "Expressional Indexes". What's
Josh Berkus <[EMAIL PROTECTED]> writes:
>> I'm not particularly happy with the phrase "expressional index", and
>> would like to think of something else to use before the 7.4 docs go
>> final. Any ideas?
> Hmmm ... well, actually, I like "Expressional Indexes". What's wrong
> with it?
Mainly t
11 matches
Mail list logo
