This is my first question on the list, I wanted to ask if postgres can handle multi millions records? for example there will be 1 million records per table per day, so 365 millions per year.
Is yes, then please elaborate.
You should read this book. It's more detailed than you need at this point, but will give you an idea what is possible: