Postgres Pro
Downloads
Home   >   mailing lists

effective_io_concurrency with an SSD SAN? - Mailing list pgsql-general

From Evan D. Hoffman
Subject effective_io_concurrency with an SSD SAN?
Date
Msg-id CABRB-LuN1M+fqGR=EGrMhSSNupqTdiVFcuq0U2a7atPGOcpY_A@mail.gmail.com
Whole thread Raw
Responses Re: effective_io_concurrency with an SSD SAN?  (Samrat Revagade <revagade.samrat@gmail.com>)
List pgsql-general
Tree view 
Given a system with 32 cores, an SSD SAN with 48x drives, and 2x 8Gbps
paths from the server to the SAN, what would be a good starting point
to set effective_io_concurrency?  I currently have it set to 32, but I
kind of feel like the right setting would be "2" since we have two
paths.  We don't often saturate both links but it does happen from
time to time.

pgsql-general by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Handling of tz-aware literals in non-tz-aware fields
Next
From: Adrian Klaver
Date:
Subject: Re: Handling of tz-aware literals in non-tz-aware fields