Let's assume you have very simple table with users: # \d users Table "public.users" ...
May 22nd, 2008 by depesz | Tags: count, distinct, group by, performance, postgresql, surprise | 2 comments »
When I was working for one of customers we found some strange thing. We needed to found number of distinct sessions per day. Table layout was very simple:
