Re: Different query result, maybe bad index

2021-02-24 Thread Julien Rouhaud
Hi, On Wed, Feb 24, 2021 at 7:50 PM Václav Steiner wrote: > > 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

Re: Different query result, maybe bad index

2021-02-24 Thread Laurenz Albe
On Wed, 2021-02-24 at 12:50 +0100, Václav Steiner wrote: > 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

Different query result, maybe bad index

2021-02-24 Thread Václav Steiner
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 c