Andrey Lizenko <lizenk...@gmail.com> writes: > I'm observing strange behaviour on comparing ::text field with string while > quering replica.
These symptoms seem consistent with the theory that the replica's index
for that column (symbols_aggregates_uniq) is corrupt. I think your
casts etc are just serving to defeat selection of an indexscan.
Why it's corrupt, I dunno, but you might try forcing a reindex on the
master.
regards, tom lane
