| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | The Hermit Hacker <scrappy(at)hub(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Xun Cheng <xun(at)cs(dot)ucsb(dot)edu>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: Multiple Spindles ( Was: Re: [HACKERS] [hackers]development suggestion needed ) |
| Date: | 2000-01-14 05:40:23 |
| Message-ID: | 3.0.1.32.20000113214023.01085600@mail.pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
At 12:59 AM 1/14/00 -0400, The Hermit Hacker wrote:
>if tables/indexs were in different subdirectories, it would be too easy
>for me, at some point in the future, to take just the tables directory and
>put them on their own dedicated drive, halving the space used on either
>drive...
>
>I don't know...IMHO, it sounds like the simplist solution that provides
>the multi-spindle benefits ppl are suggesting...
Splitting tables/indexes seems to be the first-order optimization, from
my talking to folks who are far more experienced with databases than
I (I did mention I wrote my first query less than a year ago, didn't
I?)
Still...encapsulation within the RDBMS itself seems to be in the
spirit of what RDBMS's are all about...such encapsulation could
be expressed in very simple external form and still be useful, but
I think it should be encapsulated...
Among other things, if CREATE TABLESPACE were dumped by pg_dump,
I could move from V7.0 to V8.0 and beyond without having to
rebuild my distribution structure by hand :)
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2000-01-14 05:51:35 | RE: [HACKERS] [hackers]development suggestion needed |
| Previous Message | Tom Lane | 2000-01-14 05:38:54 | Does SSL code still work after async-connection changes? |