agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Bruce Momjian <bruce@momjian.us>
To: Lu Dillon <ludi_1981@hotmail.com>
Cc: Iuri Sampaio <iuri.sampaio@gmail.com>
Cc: Ed Behn <ed.behn@collins.com>
Cc: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: Steve Midgley <science@misuse.org>
Cc: Erik Brandsberg <erik@heimdalldata.com>
Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Subject: Re: 回复: [External] Re: Separate volumes
Date: Fri, 10 Apr 2020 16:04:20 -0400
Message-ID: <20200410200420.GA24987@momjian.us> (raw)
In-Reply-To: <HK2PR02MB4227F498470D5CC93158DF1385C30@HK2PR02MB4227.apcprd02.prod.outlook.com>
References: <CAE1kc7VfQVz0VGf4cyjaY5KYSZxrPQjPWMoEsqFTJ41-LkMOHg@mail.gmail.com>
<CAFcck8FF4T3_PL7Fa+iW5YBkA4iZ3aR2V_jka=GpV9taPph9NQ@mail.gmail.com>
<CAJexoSLSHRVOKzVGD-pDHE=KY9un7bPsxGO6fSKZVgeGsj2t6g@mail.gmail.com>
<5b60ae44-33e0-d9ea-d6e9-c6db9b4c7ef1@sqlexec.com>
<CAE1kc7W=OtwRutn+4p1ShMk+koyvv8W0JunSLiV5wMdL0OVZTw@mail.gmail.com>
<399454FC-D175-421C-AC3A-31B1082E7881@gmail.com>
<HK2PR02MB4227F498470D5CC93158DF1385C30@HK2PR02MB4227.apcprd02.prod.outlook.com>
On Tue, Apr 7, 2020 at 04:31:51PM +0000, Lu Dillon wrote:
> Hi All,
>
> This is a very intersting question. I believe this is not just a best practice
> to PG. We can apply to all RDBMS. In my opinion, I agree with the others: with
> SSD, you don’t separate tables and indexs to different disks. I think the IOPS
> is enough. If you still have a problem of IOPS, you can try NVME device or U2
> device.
If you are mixing magnetic and SSDs for the same database, having
indexes on SSDs can really help, compared to table files on SSDs, where
the benefit is more limited. Also, having current data on SSDs and
archive data on magnetic is also useful, and you usually use
time-based partitioning for such cases.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
view thread (5+ messages) latest in thread
Message-ID: <20200410200420.GA24987@momjian.us>
Permalink: ../20200410200420.GA24987@momjian.us/
Also on: postgresql.org/message-id/20200410200420.GA24987@momjian.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruce@momjian.us, ludi_1981@hotmail.com, iuri.sampaio@gmail.com, ed.behn@collins.com, MichaelDBA@sqlexec.com, science@misuse.org, erik@heimdalldata.com, pgsql-sql@lists.postgresql.org
Subject: Re: 回复: [External] Re: Separate volumes
In-Reply-To: <20200410200420.GA24987@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox