From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: delete and select with IN clause issues
Date: Fri, 03 Nov 2006 01:23:28 -0500
Message-ID: <26796.1162535008@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.64.0611022021150.6160@discord.home.frostconsultingllc.com>
References: <Pine.LNX.4.64.0611021541050.29554@discord.home.frostconsultingllc.com>
<24512.1162525800@sss.pgh.pa.us>
<Pine.LNX.4.64.0611022021150.6160@discord.home.frostconsultingllc.com>
Jeff Frost <jeff@frostconsultingllc.com> writes:
> On Thu, 2 Nov 2006, Tom Lane wrote:
>> This seems pretty darn weird. I am wondering about corrupt indexes ---
>> can you find the indicated key in either table if you set
>> enable_indexscan and enable_bitmapscan to 0?
> test_tracking=# begin;
> BEGIN
> test_tracking=# set enable_seqscan TO false;
> SET
> test_tracking=# set enable_bitmapscan to false;
> SET
That's not actually the test case I asked for ...
> Nope, I guess I didn't \d visit..thought I did...it's below. I'm going to
> guess that there is index corruption and a reindex page_view will fix it. Do
> you want me to gather any information in case this is a reproducible bug
> before I issue the reindex?
I'm thinking the same --- please save a physical copy of
page_view_visit_idx before you reindex it, and if that fixes the
problem, please send me copies of both the before and after states
of the index.
regards, tom lane
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-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, jeff@frostconsultingllc.com
Subject: Re: delete and select with IN clause issues
In-Reply-To: <26796.1162535008@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