disk usage advice needed

Поиск
Список
Период
Сортировка
Искать
От
newsreader@mediaone.net
Тема
disk usage advice needed
Дата
в 00:21:08
Msg-id
20010501142650.A8823@dragon.universe
Список
Дерево обсуждения
disk usage advice needed newsreader@mediaone.net
Re: disk usage advice needed Bruce Momjian <pgman@candle.pha.pa.us>
Re: disk usage advice needed newsreader@mediaone.net
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.

Thanks in advance
В списке pgsql-general по дате отправления
От: Chris Hayner
Дата:
Сообщение: making with ssl support
От: Ryan Mahoney
Дата:
FAQ