Index Corrupted ?

From: Sébastien Boutté <sebastien(dot)boutte(at)smalltox(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Index Corrupted ?
Date: 2021-10-15 08:18:58
Message-ID: CAAw7mLEeZ=NYaK8vMqYgyE8zXj60yVWa+fqCJ3kqr92R72JdfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I've a strange problem with my upgrade of postgresql 13 (Previously 9.5).
I've two machines Server and Dev :

Server
CENTOS 7
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
Postgresql 13.4
Encoding UTF8
Collation en_US.TF8
CharacterType en_US.UTF8

Dev
Windows 10 English
Postgresql 13.4
Restore via pg_base_backup + wals reintegration standby.signal
Encoding UTF8
Collation en_US.UTF8
CharacterType en_US.UTF8

Here is my problem :

Server
select * from table where indexed_column = 'XXX' => 1 Row
select * from table where indexed_column like 'XXX' => 1 Row

Dev
select * from table where indexed_column = 'XXX' => 0 Row. Strange ???
select * from table where indexed_column like 'XXX' => 1 Row
reindex index indexed_column;
select * from table where indexed_column = 'XXX' => 1 Row. It's working ...

I've tried to reindex production database but it has not resolved anything.

Have you some ideas ?

Thanks

Sebastien

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julien Rouhaud 2021-10-15 08:41:41 Re: Index Corrupted ?
Previous Message David G. Johnston 2021-10-14 21:53:48 Re: bgwriter_flush_after