On Thursday, November 26, 2015, mrtruji <mrtruji(at)gmail(dot)com> wrote:
> Ok this is strange. Shouldn't it always be one or the other? Total row
> count for the table is 279,096.
>
> doggies=# select count(*) from data where features_bin is null;
> count
> --------
> 279096
> (1 row)
>
> doggies=# select count(*) from data where features_bin is not null;
> count
> --------
> 279096
> (1 row)
>
>
Please bottom post.
What do you get with explain analyze on those two queries.
David J.