pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Markus Bertheau <mbertheau.pg@googlemail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Peter Koczan <pjkoczan@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: disabling an index without deleting it?
Date: Wed, 27 Feb 2008 00:38:49 -0500
Message-ID: <14265.1204090729@sss.pgh.pa.us> (raw)
In-Reply-To: <684362e10802262129w4fe41264p1eb75cadd5f4d259@mail.gmail.com>
References: <4544e0330802261246t574167fdpc47629d1bbe64fed@mail.gmail.com>
	<dcc563d10802261257h6abfbc92x62a7569b8610ecc4@mail.gmail.com>
	<20080226130339.64bd4ec3@commandprompt.com>
	<9050.1204064560@sss.pgh.pa.us>
	<684362e10802261848j79686752k6dfbe032e985b131@mail.gmail.com>
	<13604.1204087729@sss.pgh.pa.us>
	<dcc563d10802262116q54b0541fj1aa10821e2255419@mail.gmail.com>
	<684362e10802262129w4fe41264p1eb75cadd5f4d259@mail.gmail.com>

"Markus Bertheau" <mbertheau.pg@googlemail.com> writes:
> On the other hand, if the only reason to have that feature is to plan
> and execute queries pretending that one index doesn't exist, then DROP
> INDEX DEFERRED is not the most straightforward syntax.

Yeah, I was just about to mention that 8.3 has a hook that allows a
plug-in to manipulate the planner's notions of which indexes exist.
Ignoring a specific index would be really trivial.

			regards, tom lane



view thread (18+ messages)  latest in thread

Message-ID: <14265.1204090729@sss.pgh.pa.us>
Permalink:  ../14265.1204090729@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/14265.1204090729@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mbertheau.pg@googlemail.com, scott.marlowe@gmail.com, jd@commandprompt.com, pjkoczan@gmail.com
  Subject: Re: disabling an index without deleting it?
  In-Reply-To: <14265.1204090729@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox