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

help / color / mirror / Atom feed
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 12:26:36 -0500
Message-ID: <3889.1162574796@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.64.0611022308080.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>
	<26796.1162535008@sss.pgh.pa.us>
	<Pine.LNX.4.64.0611022239120.6160@discord.home.frostconsultingllc.com>
	<27200.1162537088@sss.pgh.pa.us>
	<Pine.LNX.4.64.0611022308080.6160@discord.home.frostconsultingllc.com>

Jeff Frost <jeff@frostconsultingllc.com> writes:
> Well, I spoke to soon on the it all works front.  So, it's been
> reindexed and appears to be working properly now.  I guess I'll keep
> an eye on it for a while.  I didn't get your query suggestion in time,
> so hopefully I grabbed the right binary file..though it did seem to
> disappear after the reindex, so I think it's likely the correct one.
> Definitely got the correct second one.

Well, I can't find anything wrong :-(.  There are some differences in
the list of contained keys, but they're all up near the end of the
range, which is consistent with the assumption that the table is live
and had some changes between your two dumps of the index.  In
particular, there's no difference in the entries for the troublesome
key value:

38635629                24080   25
38635629                24080   26
38635629                24080   27

So I dunno what to make of it.  If it happens again, we need to look
more closely.

			regards, tom lane



view thread (12+ messages)  latest in thread

Message-ID: <3889.1162574796@sss.pgh.pa.us>
Permalink:  ../3889.1162574796@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3889.1162574796@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-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, jeff@frostconsultingllc.com
  Subject: Re: delete and select with IN clause issues
  In-Reply-To: <3889.1162574796@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