Re: Indexes

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Aasmund Midttun Godal <postgresql(at)envisity(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Indexes
Date: 2001-10-13 02:33:46
Message-ID: Pine.BSF.4.21.0110121932250.99565-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 12 Oct 2001, Aasmund Midttun Godal wrote:

> Can someone shed some light on as to how the indexes actually work?
>
> I want to index the results of a function, the function does a whole
> lot of different selects on different tables. Will the database know
> when to update the index.

AFAIK No. The functions for functional indexes probably should only
depend upon the arguments and no outside data. Anything else sounds like
a recipe for broken indexes.

In response to

  • Indexes at 2001-10-12 20:37:17 from Aasmund Midttun Godal

Responses

  • Re: Indexes at 2001-10-13 14:57:06 from Aasmund Midttun Godal

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-10-13 03:54:26 Re: VARCHAR vs TEXT
Previous Message Stephan Szabo 2001-10-13 02:31:53 Re: DROP VIEWS