Re: BUG #17245: Index corruption involving deduplicated entries - Mailing list pgsql-bugs

On 29.10.2021 21:45, Peter Geoghegan wrote:
>> btree index "azurlane_wiki.mediawiki.page_main_title":
>>       ERROR:  item order invariant violated for index "page_main_title"
>>       DETAIL:  Lower index tid=(17,157) (points to heap tid=(540,5))
>> higher index tid=(17,158) (points to heap tid=(540,5)) page lsn=2/A019DD78.
> 
> I'm not surprised to see that it's the page table, once again. It's
> not particularly big, right? Are there other tables that are much
> larger?

This table is 15 MB in size and it contains wiki page titles along with 
their namespace IDs and such. The largest table is mediawiki.text, which 
is 807 MB and holds article text. Here are some of the largest tables:

  log_search            | 11 MB
  imagelinks            | 11 MB
  revision_comment_temp | 13 MB
  page                  | 15 MB
  content               | 15 MB
  slots                 | 19 MB
  watchlist             | 24 MB
  revision_actor_temp   | 25 MB
  image                 | 33 MB
  revision              | 37 MB
  logging               | 39 MB
  pagelinks             | 56 MB
  text                  | 807 MB

-- 
K. R.