I am currently creating a database which will have less than 20 quite simple tables. Unfortunately, some of those tables will have more than 1 million entries. In order to maintain fairly good query times I would like to ask for some tips on how I should organize that database, what I should do or what I should avoid.
Thanks Matt ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match