From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | newsreader(at)mediaone(dot)net |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: disk usage advice needed |
Date: | 2001-05-02 14:45:09 |
Message-ID: | 200105021445.f42Ej9o05650@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Hello
>
> My data directory is like (pg 7.1 linux 2.4.4)
> ---
> $ ls
> PG_VERSION base/ global/ pg_hba.conf pg_ident.conf pg_xlog/ postgresql.conf postmaster.opts
> ----
>
> With 7.0.3 I remember?? that there are files named according to table
> names. With 7.1 I don't know which disk file is associated with
> which table. What I would like to do is spread the files between
> two ide disks in order to gain some performance. I heard
> somewhere that I can symlink some of the files to a different
> disk to gain some speed and I was wondering of which of those
> files are my tables. What advise would you give if I
> can split pg data between two disks.
>
> I think all of the data is in base/ directory and it looks
> like this
>
> 1/ 18719/ 18836/ 573216/
>
> I have two currently two big tables that are
> constantly (1-5 times per second the whole day)
> being accessed and always simultaneously and
> I wish these two tables to live on two separately.
I just wrote two articles, one on performance and the other on writing
PostgreSQL applications. You can get them at:
http://candle.pha.pa.us/main/writings/pgsql/
--
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 | Vivek Khera | 2001-05-02 14:47:50 | best way to implement producer/consumer in Perl |
Previous Message | Gregory Wood | 2001-05-02 14:40:13 | Re: Stranger than fiction... |