Search Postgresql Archives

Re: Load balancing across disks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux