Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group