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:
as you perhaps know there is this site/blog called high scalability. it contains articles about various things related to performance, scalability, availability and so on.
usually, when there is something about databases, it is about mysql. luckily for us, today they showed something about postgresql: