From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | scrappy(at)hub(dot)org |
Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us, dhogaza(at)pacifier(dot)com, xun(at)cs(dot)ucsb(dot)edu, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] [hackers]development suggestion needed |
Date: | 2000-01-14 04:43:49 |
Message-ID: | 20000114134349G.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>I agree with Tatsuo though I prefer
> create table t1 (i int) tablespace foo;
>.
>Isn't it preferable to encapsulate the table location and storage type ?
Agreed.
>At first,a tablespace would only correspond to a directory and it won't
>be so difficult to implment. But we would gain a lot with the feature.
>
>In the future,the tablespace may be changed to mean real(??)
>tablespace.
Good point.
> I think the major problem that I'm worried about isn't spreading tables
> across drives, but its when that *one* table grows to the point that its
> about to overflow my drive...I'd rather add a 9gig drive on, make it an
> 18gig file system, and let it continue to grow...
We could extend the create tablespace command something like:
create tablespace foo as '/pg/myspace1 /pg/myspace2 ';
to spread a table (space) among different disk drives. Moreover we
could define the "policy" to use the tablespace:
create tablespace foo as '/pg/myspace1 /pg/myspace2 ' policy roundrobin;
in above case, if the table hits the 1GB limit in /pg/myspace1 then
new segment will be created in /pg/myspace2.
Just an idea...
--
Tatsuo Ishii
From | Date | Subject | |
---|---|---|---|
Next Message | Don Baccus | 2000-01-14 04:50:03 | Re: [HACKERS] [hackers]development suggestion needed |
Previous Message | Bruce Momjian | 2000-01-14 04:41:05 | Re: Multiple Spindles ( Was: Re: [HACKERS] [hackers]development suggestion needed ) |