Postgres Pro
Downloads
Home   >   mailing lists

Is Tablespace something like Logical Volume? - Mailing list pgsql-novice

From Majid Azimi
Subject Is Tablespace something like Logical Volume?
Date
Msg-id CADOhCmvgU6XLYV7L1zRVtaMJ5EbewL=8C9xHVFTCN6LqvwwqAw@mail.gmail.com
Whole thread Raw
List pgsql-novice
Tree view 
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:

Previous
From: Steve Crawford
Date:
Subject: Re: Database not browsable during COPY on PostgreSQL
Next
From: DrYSG
Date:
Subject: Re: Slow duplicate deletes