Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7BF972E008A for ; Tue, 26 Feb 2008 16:46:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 06982-03 for ; Tue, 26 Feb 2008 16:46:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.176]) by postgresql.org (Postfix) with ESMTP id F36B02E008C for ; Tue, 26 Feb 2008 16:46:06 -0400 (AST) Received: by el-out-1112.google.com with SMTP id r27so2174843ele.5 for ; Tue, 26 Feb 2008 12:46:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=UcvICxPQmCxvSNONRirE3/QnpdHDUIR6Wzdh+XTVBQM=; b=F0RaPZQoWv9RJ+9tz7itQPbN53W4GMu+9psuvTY4l64CZqSRlTIve+HJMk0boFyFPN42ksDjROgOJl7Y4iObgk51DLHHP4hc0TT0+0ZeMZRSRPUgYvoKi8fjLEtxWj+jLefynoNqCZ/gam1v15thvJkamftFWcFvP1UFwk1flUE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Th6/9oXb7+xezlM+tA8gN+QCiFVv8EQiPYWzQMX/rzUtWgxtmraocwYQPX1JlKwl7vqcp5ckJtBDuVbMfJXiLcj2D3/asxiaEgqejLo1tdaS+vh/7dQqs/Yk9cGquRC8aFkp4oo+wmOd7Q0ZoYXue6w1/Iln+XCNsEMDsm5J66s= Received: by 10.115.47.1 with SMTP id z1mr6130381waj.117.1204058764196; Tue, 26 Feb 2008 12:46:04 -0800 (PST) Received: by 10.114.199.20 with HTTP; Tue, 26 Feb 2008 12:46:04 -0800 (PST) Message-ID: <4544e0330802261246t574167fdpc47629d1bbe64fed@mail.gmail.com> Date: Tue, 26 Feb 2008 14:46:04 -0600 From: "Peter Koczan" To: pgsql-performance Subject: disabling an index without deleting it? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/350 X-Sequence-Number: 28892 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