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: (view raw, whole thread or download thread mbox)
Lists: sfpug

> 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 


Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to


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-2017 The PostgreSQL Global Development Group