From: | babak houman <babak(dot)houman(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Optimal SSD based RAID 0 config |
Date: | 2018-08-02 07:50:43 |
Message-ID: | CAOb7zCgrGKE_nNfJoxyY7Yx_y58wvezp_Mxn8moCA=ZfGhH4MQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I would like to ask the community for their kind support.
I'm looking for the optimal configuration of postgresql
under the following assumptions:
# Database usage scenario:
```
* daily bulk upload of several million rows of financial transaction data
* Statistical analysis (possibly machine learning) using pl/R and pl/python
```
# My hardware spec:
```
* ASUS WS X299 PRO/SE LGA2066 ATX
* SAMSUNG 850 PRO SSD 256GB intern SED 6,4cm 2,5Zoll SATA 6Gb/s
* INTEL Core i9-7900X 3,30GHz LGA2066 13,75MB Cache Boxed CPU 10K
* 128GB DDR4-3000 CL15
* 2x HGST ULTRASTAR SN260 SSD HH-HL 3200GB PCIe MLC RI 15NM HUSMR7632BHP301
```
Operating system is Linux (preferably debian jessie or gentoo).
I would like to use the 2x ULTRASTAR SSD PCIe in raid 0 mode to maximize
the I/O throughput.
In particular I'm looking for the the allignment of the following
parameters:
```
* postgresql block size
* Kernel PAGESIZE
* RAID stripe size
```
Best regards and many thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Pardi | 2018-08-02 08:05:46 | Re: postgres port 5434 not being allowed when remote server is accessing |
Previous Message | Nelson Gonzaga | 2018-08-01 18:34:46 | Re: Grant on lo_export() |