Re: Index not used in functions in 7.0?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kyle Bateman <kyle(at)actarg(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, merrill(at)actarg(dot)com
Subject: Re: Index not used in functions in 7.0?
Date: 2000-05-16 15:50:03
Message-ID: 21401.958492203@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kyle Bateman <kyle(at)actarg(dot)com> writes:
> I dumped the log (-d 9) from the postmaster and the plan confirms that
> the scan is sequential when called from within the function but indexed
> when the SQL is called directly.

Yikes, that does sound like a bug.

> I'd be happy to provide a dump of the data, do other testing or whatever
> would help. I'm not sure who on the team is best to look at this.

How big would the dump file be? I'm willing to look at this, and if the
dump isn't very large then it'd be easier to just install your DB here
instead of trying to gin up my own test case.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message mig 2000-05-16 15:54:52 Re: pattern matching operator
Previous Message Jeff Hoffmann 2000-05-16 15:47:38 Re: Question about databases in alternate locations...