From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Andre Schubert <andre.schubert@km3.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Indexing timestamps
Date: Fri, 7 Jun 2002 22:48:25 -0400 (EDT)
Message-ID: <200206080248.g582mPu22554@candle.pha.pa.us> (raw)
In-Reply-To: <20020606152814.P30776-100000@megazone23.bigpanda.com>
Stephan Szabo wrote:
> On Thu, 6 Jun 2002, Josh Berkus wrote:
>
> >
> > Stephan,
> >
> > > Unfortunately you can't do that in that sort of syntax. You'll
> > > need to create a function that returns the month and is marked
> > > as iscachable and use that function in the index creation and
> > > query.
> >
> > Hmmm. I take it that NOW() is not ISCACHABLE, and that's Andre's indexing
> > problem? What would be the pitfall of creating an alternate version of
> > NOW() that ISCACHABLE?
>
> I believe it was not marked as iscachable. I think it's now marked as
> static in dev sources which I would guess would mean that it could
> consider an index scan. I think with care an iscachable function that
> just called now() would probably be safe for interactive queries.
We have all those new cacheable settings now to indicate things that can
change during the transaction, function call, or never.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgman@candle.pha.pa.us, sszabo@megazone23.bigpanda.com, josh@agliodbs.com, andre.schubert@km3.de
Subject: Re: Indexing timestamps
In-Reply-To: <200206080248.g582mPu22554@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox