Martin Below <machtin.be...@googlemail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general