Martin Below <machtin.below@xxxxxxxxxxxxxx> writes: > test=# select count(*) total, count(distinct client_id) ids, > count(distinct expires_on) dates from ps; > total | ids | dates > --------+--------+-------- > 213645 | 123366 | 213549 That says the expires_on column is practically unique, which makes me think the planner is indeed making the right choice. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general