From: Peter Koczan <pjkoczan@gmail.com>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: disabling an index without deleting it?
Date: Tue, 26 Feb 2008 14:46:04 -0600
Message-ID: <4544e0330802261246t574167fdpc47629d1bbe64fed@mail.gmail.com> (raw)
This might be a weird question...is there any way to disable a
particular index without dropping it?
There are a few queries I run where I'd like to test out the effects
of having (and not having) different indexes on particular query plans
and performance. I'd really prefer not to have to drop and ultimately
recreate a particular index, as some of the data sets are quite large.
So, is there any way to do this, or at least mimic this sort of behavior?
Peter
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: pjkoczan@gmail.com
Subject: Re: disabling an index without deleting it?
In-Reply-To: <4544e0330802261246t574167fdpc47629d1bbe64fed@mail.gmail.com>
* 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