Skip site navigation (1) Skip section navigation (2)

Is Tablespace something like Logical Volume?

From: Majid Azimi <majid(dot)merkava(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Is Tablespace something like Logical Volume?
Date: 2012-03-07 12:48:20
Message-ID: CADOhCmvgU6XLYV7L1zRVtaMJ5EbewL=8C9xHVFTCN6LqvwwqAw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
hi guys,

I'm confused about tablespaces in PostgreSQL. Is it something like
LVM? I mean when disk is getting full, can we add another disk, format
and then CREATE TABLESPACE tblspace LOCATION /media/disk2/data and
tables are automatically continue to grow on second table space(tables
are not partitioned)? Is it enough? Or we should manually ALTER
databases, tables or indexes and move them to other tablespace?

pgsql-novice by date

Next:From: DrYSGDate: 2012-03-07 15:09:38
Subject: Re: Slow duplicate deletes
Previous:From: Steve CrawfordDate: 2012-03-06 23:55:08
Subject: Re: Database not browsable during COPY on PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group