Postgres Pro
Downloads
Home   >   mailing lists

Re: scaling postgres - can child tables be in a different tablespace? - Mailing list pgsql-general

From John R Pierce
Subject Re: scaling postgres - can child tables be in a different tablespace?
Date
Msg-id 55C0C3CB.2070300@hogranch.com
Whole thread Raw
In response to Re: scaling postgres - can child tables be in a different tablespace?  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view 
On 8/4/2015 6:14 AM, Melvin Davidson wrote:
> As additional advice, to get the best performance, you will want all
> your tablespaces to be on separate spindles/disks.
> EG: disk1/tblspc1
>         disk2/tblspc2
>         disk3/tblspc3
>         ...
>         disk99/tblspc99


actually, I find to get best performance most often, stripe all the
disks together and put everything on the same big volume, that way all
IO is evenly distributed.   otherwise you'll find too much IO on some
tables/partitions, and not enoguh on others, so most of the disks are
idle most of the time.


--
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Fwd: postgresql databases disappearing and reappearing and disappearing on localhost - Postgresql x649.3 on Windows 8.1 (64)
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: postgresql databases disappearing and reappearing and disappearing on localhost - Postgresql x649.3 on Windows 8.1 (64)