Re: panic failed to add item
От | Scott Marlowe |
---|---|
Тема | Re: panic failed to add item |
Дата | |
Msg-id | dcc563d10911201419l7b994e7awa4ccc5e003f8f5aa@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: panic failed to add item (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: panic failed to add item
|
Список | pgsql-general |
On Fri, Nov 20, 2009 at 3:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > Scott Marlowe <scott.marlowe@gmail.com> 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.
В списке pgsql-general по дате отправления: