Best way to count distinct indexed things in PostgreSQL

Simon Waddington January 24, 2020 Reply

I think you'll find that

  select count(*) from (select text_hash from main_songtexthash group by text_hash) t;

is even faster. Although it might depend on your dataset.