From: | Jack W <dbdevelop2000(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Need suggestions |
Date: | 2009-06-25 18:30:50 |
Message-ID: | 3473330e0906251130v32318488ne195648db7fa59ae@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I will create several databases on PostGreSQL. All the databases have the
same structure: same number of table/index.
I have two choices:
1. For each database, I create a new tablespace and create a new database in
the tablespace.
2. I only create one tablespace. Create all the databases on the same
tablespace.
What is the advantage and disadvantage of the two choices? For the first
choice, different database locates in different physical directory on the
hard drive. For the second choice, all the database locate in the same
physical directory.
Another possibility is to create a new "database cluster directory" for each
database. Then each database is managed by different database server
instance using different connection.
Which way is better? Thanks a lot.
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moran | 2009-06-25 18:37:04 | Re: Need suggestions |
Previous Message | Scott Marlowe | 2009-06-25 17:31:49 | Re: Vacuum on the database versus individual tables. |