From: | Richard Emberson <emberson(at)phc(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Mapping tables to disk drives |
Date: | 2002-02-20 03:33:47 |
Message-ID: | 3C73191B.D83E1A62@phc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bruce Momjian wrote:
> Richard Emberson wrote:
> > Are there any guides, references, etc. for helping someone:
> > 1) know how to map a particular table to a particular disk drive (is it
> > just symbolic links) and
>
> Yep, just symlinks. We know we need a better method. Also, as the
> table grows, extent files for >1gb will also need to be symlinked.
>
> > 2) for what type of queries and table layout combination would it make
> > sense to do so?
>
> First, pg_xlog/ should be on a separate drive. Then you can think about
> moving indexes and tables to separate drives.
I looked around the .../data directory. How does one map from index and
table names
to file names?
Also, I assume that when a extent file for >1Gb is created (by the DB as it
is running)
one must stop the DB, move the file, make a symbolic link to the moved file,
and then
restart the DB.
>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Carlo Florendo | 2002-02-20 08:44:59 | Install postmaster as service in win2K |
Previous Message | Bruce Momjian | 2002-02-20 03:31:38 | Re: Mapping tables to disk drives |