Search Postgresql Archives

Re: Tablespace Issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Thu, Feb 17, 2011 at 4:08 AM, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> wrote:
Dear all,

Today I got to have a strong  issue while craeting table in a database.

pdc_uima=# create table clause2_naxal as select * from clause2 c ,page_naxal_v3 p where c.source_id = p.crawled_page_id;
ERROR:  could not extend relation pg_tblspc/17208/17216/23098672: No space left on device
HINT:  Check free disk space.
pdc_uima=# drop table clause2_naxal;
ERROR:  table "clause2_naxal" does not exist

I thougt that that the hard disk becomes full in which the tablespace is created for pdc_uima database.

So, I attach a new hard disk(300 Gb ) and create a new tablespace  in it .

And after, issue the below command :

ALTER DATABASE pdc_uima SET TABLESPACE ts_pdc_uima1;

It takes so much time as database size is near about 40 GB.

It seems it moves the whole database to new place. I think this is not good for future. Is there is any way to  have new  data in  new  tablespace  and  remain old as it  is.

There is a 'TABLESPACE' option to the CREATE TABLE statament.
   http://www.postgresql.org/docs/current/static/sql-createtable.html


--Scott
 

Also, Can I delete the old tablespace now .


Thanks & Best Regards,

Adarsh Sharma


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux