Load balancing across disks

Поиск
Список
Период
Сортировка
Искать
От
Paul Lambert
Тема
Load balancing across disks
Дата
Msg-id
45BD60FB.1020501@autoledgers.com.au
Список
Дерево обсуждения
Load balancing across disks Paul Lambert <paul.lambert@autoledgers.com.au>
Re: Load balancing across disks Bruno Wolff III <bruno@wolff.to>
Re: Load balancing across disks "Joshua D. Drake" <jd@commandprompt.com>
Re: Load balancing across disks ff@suse.de
Re: Load balancing across disks Douglas McNaught <doug@mcnaught.org>
Im in the process of finalising my conversion from M$ SQL server to 
Postgres - all of which I'm very happy about so far.

The database I work with has 37 tables, 5 of which run into the order of 
tens of millions of records and approximately another 10 can run into 
millions depending on the size of the customers main system. The DB is 
going to be expanded to have another 15 or so tables when I step up 
replication from my primary OpenVMS based application, some of these 
will also have extremely high usage - again depending on the size of the 
customers main system.

In order to balance disk load and ensure faster data access, my current 
SQL server setup has the data spread across 3 physical disk devices. One 
question I would like to know which I can't find in the documentation 
I've been reading is if Postgres has any similar data distribution 
abilities.

I.e. can I create a data file on D drive which holds tables a, b and e, 
and a data file on E drive which holds tables c, d and f.

If this is possible, could someone point me to some documentation so I 
can experiment a little.

If not possible, I guess I'll have to upgrade to some faster hardware... 
if they'll be willing to give me money for that ;)

BTW, I'm using 8.2 on M$ Weenblows (Yes I know weenblows sucks, but i 
don't have sufficient unix/linux/other platform Postgres runs on 
experience to run the db on another server.... I'll wait for someone to 
port it to OpenVMS ;) and then use it on that (I know, I'm dreaming) - 
OpenVMS makes unixish systems look like they have the reliability of 
weenblows, I'll tell you that much :D)

Cheers.

-- 
Paul Lambert
Database Administrator
AutoLedgers

В списке pgsql-general по дате отправления
От: Michael Fuhr
Дата:
От: Douglas McNaught
Дата:
FAQ