| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: scaling postgres - can child tables be in a different tablespace? |
| Date: | 2015-08-04 13:53:15 |
| Message-ID: | 55C0C3CB.2070300@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-08-04 14:13:48 | Re: Fwd: postgresql databases disappearing and reappearing and disappearing on localhost - Postgresql x649.3 on Windows 8.1 (64) |
| Previous Message | Adrian Klaver | 2015-08-04 13:38:01 | Re: Fwd: postgresql databases disappearing and reappearing and disappearing on localhost - Postgresql x649.3 on Windows 8.1 (64) |