public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kaixi Luo <[email protected]>
To: Mark Kirkwood <[email protected]>
Cc: [email protected]
Subject: Re: Tuning guidelines for server with 256GB of RAM and SSDs?
Date: Thu, 7 Jul 2016 09:49:58 +0200
Message-ID: <CAHo5iygNZ7UnaYh7hwLK+3T6e-g55wRpmTT8qdrrjfHfKRGD3Q@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
It's a Crucial CT250MX200SSD1 and a Samsung MZ7LM480HCHP-00003.
Regards,
Kaixi
On Thu, Jul 7, 2016 at 6:59 AM, Mark Kirkwood <[email protected]
> wrote:
> On 06/07/16 07:17, Mkrtchyan, Tigran wrote:
>
>> Hi,
>>
>> We had a similar situation and the best performance was with 64MB
>> background_bytes and 512 MB dirty_bytes.
>>
>> Tigran.
>>
>> On Jul 5, 2016 16:51, Kaixi Luo <[email protected]> wrote:
>>
>>
>> Here are my server specs:
>>
>> RAID1 - 2x480GB Samsung SSD with power loss protection (will be used
>> to
>> store the PostgreSQL database)
>> RAID1 - 2x240GB Crucial SSD with power loss protection. (will be
>> used to
>> store PostgreSQL transactions logs)
>>
>>
> Can you tell the exact model numbers for the Samsung and Crucial SSD's? It
> typically matters! E.g I have some Crucial M550 that have capacitors and
> (originally) claimed to be power off safe, but with testing have been shown
> to be not really power off safe at all. I'd be dubious about Samsungs too.
>
> The Intel Datacenter range (S3700 and similar) are known to have power off
> safety that does work.
>
> regards
>
> Mark
>
>
>
> --
> Sent via pgsql-performance mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Tuning guidelines for server with 256GB of RAM and SSDs?
In-Reply-To: <CAHo5iygNZ7UnaYh7hwLK+3T6e-g55wRpmTT8qdrrjfHfKRGD3Q@mail.gmail.com>
* 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