Re: Postgresql 8.0 RC1 not using indexes

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgresql 8.0 RC1 not using indexes
Date: 2004-12-18 07:13:53
Message-ID: 20041218071353.GA7600@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Dec 17, 2004 at 10:28:20PM -0600, Tony Caduto wrote:

> The function in question does some selects on the table that is being
> inserted and without the indexes working it ends up taking a very long time.
>
> unfortunatly I can't supppy any of the plpgsql function code.

Can you at least post the EXPLAIN ANALYZE output for a query that
you think isn't using an index?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Zsolt Pfiszter 2004-12-18 09:34:31 Re: posgresql 8.0 RC1 missing schemas
Previous Message Kris Jurka 2004-12-18 07:10:41 Re: Jdbc3SimpleDataSource does not require the setting of