On Fri, Nov 20, 2009 at 3:15 PM, Tom Lane <[email protected]> wrote: > Scott Marlowe <[email protected]> writes: >>>> I get this running mnogosearch against my 8.4.1 database consistently: >>>> PANIC: failed to add item to the right sibling in index "logged_in_uid" > > Hmm, if uid is an integer then all the index entries will be the same > size, which eliminates my first theory about there being some corner > case where we're (still) choosing an infeasible split point. Can you > comment about the insertion pattern for uid's --- are they ever-increasing > for instance? Do you have any special properties such as fillfactor set > on that index?
Access is pretty random actually, and fill factor on this database is 100% because it doesn't really get updated, just appended to. There are a lot of parallel insertions going on if that helps. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
