Search Postgresql Archives

Different query result, maybe bad index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux