Andrey Lizenko <lizenko79@xxxxxxxxx> 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
