Re: B-tree Index corruption

From: Filip Sedlák <filip(at)sedlakovi(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Michal Danilák <michal(at)monitora(dot)cz>
Subject: Re: B-tree Index corruption
Date: 2023-11-21 10:32:42
Message-ID: 5391581b-c43c-4ec7-b9c1-22323ce8f7da@sedlakovi.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> It can take awhile before the results of inconsistent sorting order
> become obvious, but the state of the index will progressively degrade
> as new entries get inserted into the wrong subtree.

This part, I definitely didn't expect. I'm glad that reindex should fix it!

Thank you very much!
Filip Sedlák

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Gallacher Neil 2023-11-21 13:26:16 ERROR: value out of range: underflow in numeric log calculation
Previous Message Laurenz Albe 2023-11-21 08:33:18 Re: About #13489, array dimensions and CREATE TABLE ... LIKE