Here're two cases - 1. 20 tables in one huge database A on one machine 2. 10 tables in each database if they can functionally separated, so two databases A1 and A2 on one machine
What's the estimated performance difference on queries from A2 and A1 comparing the same querying from A in general using PostgreSQL? 1) What if A1 contains 10 bigger tables [80% of A], A2 container 10 tables with less data [20% of A] 2) And A1 and A2 contains 50% of A each Thanks. johnl ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
