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

Re: Index ot being used

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Index ot being used
Date: 2005-06-13 03:53:46
Message-ID: 20050613035346.GA20703@wolff.to (view raw or flat)
Thread:
Lists: pgsql-performance
On Sun, Jun 12, 2005 at 23:42:05 -0400,
  Madison Kelly <linux(at)alteeve(dot)com> wrote:
> 
> As you probably saw in my last reply, I went back to the old index and 
> tried the query you and Tom Lane recommended. Should this not have 
> caught the index?

Probably, but there might be some other reason the planner thought it
was better to not use it. Using indexes is not always faster.

It would help to see your latest definition of the table and indexes,
the exact query you used and explain analyze output.

In response to

Responses

pgsql-performance by date

Next:From: Madison KellyDate: 2005-06-13 04:29:08
Subject: Re: Index ot being used
Previous:From: Madison KellyDate: 2005-06-13 03:42:05
Subject: Re: Index ot being used

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