Different query result, maybe bad index

From: Václav Steiner <steiner(dot)vaclav(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Different query result, maybe bad index
Date: 2021-02-24 11:50:04
Message-ID: CAJZf+Ug9XwBELE+SRhwF2h2queqDEzXnJ5YkQH8DNzg3=z52hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

We have three servers running postgres 9.6, master and two slaves feeded by
streaming replication.
On of those slaves we are getting different query results. The replica was
recreated from scratch, but problem persists.

If set enable_indexscan='off' and set enable_bitmapscan='off' we get
correct result.
It looks like problem with some index...?

Can anybody saw such behaviour?

I'll then send of course the table, index, etc. definition if necessary.

Thank you.

Best regards
Václav

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2021-02-24 11:59:18 Re: Different query result, maybe bad index
Previous Message Francisco Olarte 2021-02-24 11:15:02 Re: getting tables list of other schema too