Re: Load balancing across disks

Paul Lambert wrote:
> 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.

You are looking for tablespaces :).

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

http://www.postgresql.org/docs/8.0/interactive/sql-createtablespace.html

>
> 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.
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/