Re: delete and select with IN clause issues

On Fri, 3 Nov 2006, Tom Lane wrote:

> 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.

Well, it's been working wonderfully since the REINDEX, so I don't know what to
say. Any idea if having a too small max_fsm_pages could hose an index,
because I know that happened not too long before we started seeing this
problem. The fsm settings were increased prior to the problem occurring, but
it's possible the index was already damaged?

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954