On 26/02/10 12:45, elias ghanem wrote:
Hi, Thanks for your answer, Concerning the second point, each db have different table that are logically related (for ex, tables for configuration, tables for business...) plus I'm planning to put the indexes on their own tablespaces. Concerning the disks I will maybe stored on multiple disks (but surely not 200-300). So I'm just wondering If this big number of tablespaces on a same db server may cause problems,
If the tablespaces aren't on different disks, I'm not sure what the point is.
Do you perhaps mean schemas? So you have e.g. a "system" schema with tables "users", "activity_log" etc? There's no problem with 20-30 schemas per database.
-- Richard Huxton Archonet Ltd -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
