Re: Tablespace on Postgrsql

On 7/25/2013 10:16 PM, Atri Sharma wrote:
> On Fri, Jul 26, 2013 at 7:21 AM, devonline<devonline@backpost.com>  wrote:
>> >Thanks for the in formation.  Can you please tell me what would be a scalable
>> >architecture? (using pg_default) or separate custom tablespaces
> Putting too may tables in one tablespace can lead to confusion, to say
> the least. Keeping logically separate tablespaces seems a much saner
> idea to me, IMHO.


schema are the appropriate structure for logically grouping tables if
you have a large number.


tablespaces are purely about the storage.

as I said before, if your server has only one main data raid with one
big file system, then a single tablespace is appropriate.  if your
server has multiple distinct raids and volumes, then different
tablespaces are appropriate.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast