Separate volumes
| От | Ed Behn |
|---|---|
| Тема | Separate volumes |
| Дата | |
| Msg-id | CAE1kc7VfQVz0VGf4cyjaY5KYSZxrPQjPWMoEsqFTJ41-LkMOHg@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Separate volumes
|
| Список | 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.
В списке pgsql-sql по дате отправления: