this is my 7th year in the adult online industry, and i've used mySQL religiously for the entire time.

however, i'm possibly gonna be dealing with a database table with around 1 million rows, and i'm a little concerned about the performance of mySQL in such a situation.

i've heard that postgreSQL is intended for larger and more complex databases, but i've had very little exposure to it.

does anyone here use postgreSQL? any suggestions? comments? concerns? advice?

thanks