Feedback-ID: i76984098:Fastmail
Message-ID: <e76b9998-49bb-4e19-af9f-955f33647aa6@aklaver.com>
Date: Fri, 10 Oct 2025 08:03:04 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Index (primary key) corrupt?
To: Wim Rouquart <wim.rouquart@kbc.be>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <AS2PR05MB1075477BA334D4DA262AD75BFEF16A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <1bfa0b6b-11a8-458f-a3f3-3f86574abc1d@aklaver.com>
 <AS2PR05MB107548567EEDAAB3AF74A6C59EF11A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <f3ea70b8-c822-4b0f-b564-5e73d34188d4@aklaver.com>
 <AS2PR05MB10754A51AB7FC85161189FF7CEF11A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <e5e5026a-97e4-47aa-a668-76f23388ba85@aklaver.com>
 <AS2PR05MB10754F4A8BC2689D4E637869EEFEFA@AS2PR05MB10754.eurprd05.prod.outlook.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <AS2PR05MB10754F4A8BC2689D4E637869EEFEFA@AS2PR05MB10754.eurprd05.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/e76b9998-49bb-4e19-af9f-955f33647aa6%40aklaver.com>
Precedence: bulk

On 10/10/25 05:28, Wim Rouquart wrote:
> Internal
> 
> Hi,
> 
> Apologies for the late response, had other fish to fry...
> 
> In response to your questions:
> 
>> What is full(15.x) version of Postgres are you using?
> 
> 15.14
> 
>> Is it the community version or a fork or SaaS?
> 
> Standard release indeed, running on RHAT8
> 
>> What do you get for queries below?:
> 
>> select * from pg_opclass where oid = 3124;
> 
> |oid    |opcmethod      |opcname        |opcnamespace|opcowner  |opcfamily      |opcintype      |opcdefault     |opckeytype
> |3124   |403            |int8_ops       |11             |10                     |1976           |20                     |true           |0
> 
>> select * from pg_opclass where opcname = 'int8_ops';
> 
> |oid    |opcmethod      |opcname        |opcnamespace   |opcowner       |opcfamily      |opcintype      |opcdefault     |opckeytype|
> |3124   |403            |int8_ops       |11                     |10                     |1976           |20                     |true           |0         |
> |10021  |405            |int8_ops       |11                     |10                     |1977           |20                     |true           |0         |
> 

Was the above done before or after you did the reindex?

 From original post:

"
When doing a pg_dump of one of our databases one of the tables primary 
keys doesn't get exported. Pg_dump just skips this index, without any 
warning whatsoever (verbose mode was used to doublecheck).


When doing a REINDEX the issue is fixed.
"

That would imply that after the successful REINDEX and dump some action 
is taken that makes the index disappear.

What is the table used for?

Are there any sort of 'unusual' operations done on it?


-- 
Adrian Klaver
adrian.klaver@aklaver.com