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?