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

Re: 8.1.4 planner index selection

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: sfpug(at)postgresql(dot)org
Cc: Reece Hart <reece(at)harts(dot)net>
Subject: Re: 8.1.4 planner index selection
Date: 2006-06-19 22:56:29
Message-ID: 200606191556.30364.josh@agliodbs.com (view raw or flat)
Thread:
Lists: sfpug
Reece,

> When I add a simple predicate based on an indexed column to a query (Q1,
> below), the query becomes much slower (Q2).  This is despite a
> multi-column index that in principle ought to have greatly improved
> performance.  When I remove the multi-column index, the query plan for
> Q2 reverts to using the same index as that for Q1.

How large is that mutli-colum index?  Disk size?   How much RAM do you 
have?

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to

Responses

sfpug by date

Next:From: Jeff FrostDate: 2006-06-19 23:05:55
Subject: Re: 8.1.4 planner index selection
Previous:From: Reece HartDate: 2006-06-19 22:23:28
Subject: 8.1.4 planner index selection

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