Hi,
I have a strange case where a SELECT for a primary key returns 0 rows on one
slave, while it returns the correct 1 row on another slave and on the master.
It does however return that row on all slaves when queried with LIKE and
trailing or leading wildcard.
psql version is 9.3.5, because t
understand that different
stats there can lead to different performance, but I think whatever the stats
are and the execution plan is, this must not lead to a false result, right?
Besides, the scales look similar in slave1 and slave2, although the query
results are different.
Maik
>
> O
> Am 20.05.2015 um 15:17 schrieb Adrian Klaver :
>
> On 05/19/2015 11:52 PM, Musall Maik wrote:
>> Hi,
>>
>> I have a strange case where a SELECT for a primary key returns 0 rows on one
>> slave, while it returns the correct 1 row on another slave and on the
Hi Tom,
that's very useful information. Very cool to get such results so quickly here.
Thanks
Maik
> Am 20.05.2015 um 16:05 schrieb Tom Lane :
>
> Adrian Klaver writes:
>> The reason I ask is that the machine you are having problems with has OS
>> X. Over the years I have seen quite a few re
