Separate volumes

Ed Behn <ed.behn@collins.com>

From: Ed Behn <ed.behn@collins.com>
To: pgsql-sql@lists.postgresql.org
Date: 2020-04-06T11:51:15Z
Lists: pgsql-sql
I was once told that it's best practice to store tables and indexes in
separate tablespaces located on separate physical drives. It seemed logical
that this should improve performance because the read-head wouldn't need to
jump back and forth between a table and its index.

However, I can't seem to find this advice anywhere online. Is it indeed
best practice? Is it worth the hassle?

          -Ed

Ed Behn | Senior Systems Engineer | Avionics

COLLINS ÆROSPACE

2551 Riva Road, Annapolis, MD 21401 USA

Tel: +1 410 266 4426 | Mobile: +1 240 696 7443

ed.behn@collins.com | collinsaerospace.com

CONFIDENTIALITY WARNING: This message may contain proprietary and/or
privileged information of Collins Aerospace and its affiliated companies.
If you are not the intended recipient, please 1) Do not disclose, copy,
distribute or use this message or its contents. 2) Advise the sender by
return email. 3) Delete all copies (including all attachments) from your
computer. Your cooperation is greatly appreciated.