Re: How does the planner deal with multiple possible - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: How does the planner deal with multiple possible
Date
Msg-id 1153489964.2846.6.camel@localhost.localdomain
Whole thread Raw
In response to Re: How does the planner deal with multiple possible indexes?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Ühel kenal päeval, R, 2006-07-21 kell 08:29, kirjutas Jim C. Nasby:

> No, this is 8.1.3, and it's a production machine so I'd prefer not to go
> about dropping indexes to get cost comparisons; unless there's some way
> to disable the use of an index in a given backend?

Currently the closest thing is 

BEGIN;
DROP INDEX xxx;

test query here

ABORT;

>  Otherwise I'll try
> and come up with a test case.
-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com





pgsql-hackers by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Transaction Speed and real time database
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL