Dear all,
As a db grows fetching distinct values gets more and more time consuming. What is the best practice for solving this problem:
1) Create separate tables for each columns of which distinct values are required
2) Create one table with two columns: 1)name of the column and 2) multiple distinct values (Is it possible to store in a cell multiple values, such arrays etc)
3) Do you know some more proficient solution?
Thanks

I also came across the same problem of having slow distinct values,
i don't know if this really could help you .

see this link, about postgres tricks.
PostgreSQL SQL Tricks - PostgreSQL