Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Multiple data base on same server
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: elias ghanem <e(dot)ghanem(at)acteos(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Multiple data base on same server
- Date: Fri, 26 Feb 2010 13:03:33 +0000
- Message-id: <4B87C6A5.6040005@archonet.com> <text/plain>
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
- Follow-Ups:
- Re: Multiple data base on same server
- From: Craig James
- Re: Multiple data base on same server
- References:
- Re: Multiple data base on same server
- From: elias ghanem
- Re: Multiple data base on same server
- Prev by Date: Re: Multiple data base on same server
- Next by Date: Re: bgwriter, checkpoints, curious (seeing delays)
- Previous by thread: Re: Multiple data base on same server
- Next by thread: Re: Multiple data base on same server
- Indexes: