| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Patrick B <patrickbakerbr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: effective_io_concurrency increasing |
| Date: | 2017-06-19 15:49:59 |
| Message-ID: | CAHyXU0xP4LK9TcsNhc-2wtNXZtt2pELKxOFusN7KKGkQ=5WQ8g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jun 19, 2017 at 10:36 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> If you have a RAID, set it to the number of spindles in your RAID and forget
> it. It is usually one of the less interesting knobs to play with. (Unless
> your usage pattern of the database is unusual and exact fits the above
> pattern.)
Isn't that advice obsolete in a SSD world though? I was able to show
values up to 256 for a single device provided measurable gains for a
single S3500. It's true though that the class of queries that this
would help is pretty narrow.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Korot | 2017-06-19 16:02:56 | Remote connection to PostgreSQL |
| Previous Message | Paul Jungwirth | 2017-06-19 15:45:48 | Re: Postgres Data Encryption Using LUKS with dm-crypt ? |