Postgres Pro
Downloads
Home   >   mailing lists

Re: - Mailing list pgsql-bugs

From Vladimir Ryabtsev
Subject Re:
Date
Msg-id CAMqTPqns6o6bckZRnG2bwyumoFWWZ=MeE0yoo3iFVkoNR4S0Hw@mail.gmail.com
Whole thread Raw
In response to Re:  (Peter Geoghegan <pg@bowt.ie>)
Responses Re:
List pgsql-bugs
Tree view
bt_page_items() returns two rows:

116 (97262,1) 88 false true
9b 31 39 36 38 e5 b9 b4 e3 83 a1 e3 82 ad e3 82
b7 e3 82 b3 e3 82 b7 e3 83 86 e3 82 a3 e3 83 bc
e3 82 aa e3 83 aa e3 83 b3 e3 83 94 e3 83 83 e3
82 af e3 81 ae e3 83 8f e3 83 b3 e3 82 ac e3 83
aa e3 83 bc e9 81 b8 e6 89 8b e5 9b a3 00 00 00

117 (118496,1) 80 false true
89 31 39 36 38 e5 b9 b4 e3 82 b0 e3 83 ab e3 83
8e e3 83 bc e3 83 96 e3 83 ab e3 82 aa e3 83 aa
e3 83 b3 e3 83 94 e3 83 83 e3 82 af e3 81 ae e3
83 a2 e3 83 ad e3 83 83 e3 82 b3 e9 81 b8 e6 89
8b e5 9b a3 00 00 00 00

This does not make much sense to me to be honest...

Please let me know what to check on OS level.

--
Vladimir

вт, 24 сент. 2019 г. в 17:35, Peter Geoghegan <pg@bowt.ie>:
>
>
> That's slightly inconvenient, because it's an internal page -- there
> is no heap TID that you can use to look at the row in the table
> directly. You're going to have to look at the index page directly, and
> try to make sense of pageinspect's hex representation of the data.
>
> The following will show details of the pair of tuples that are in the
> wrong order here:
>
> CREATE EXTENSION pageinspect;
> SELECT * FROM bt_page_items('vocabulary_phrase_key', 29915) WHERE
> itemoffset in (116, 117);
>
> What does that look like?
>
> I think that the problem here is likely to have something to do with
> OS collations -- this isn't a Postgres bug in all likelihood.

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re:
Next
From: Peter Geoghegan
Date:
Subject: Re: