Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1

From: Marinos Yannikos <mjy(at)geizhals(dot)at>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1
Date: 2011-04-22 21:43:58
Message-ID: 4DB1F69E.1000305@geizhals.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Am 19.04.2011 11:15, schrieb Laurent Laborde:
> Soft RAID1 (md)
> ext3

We have experimented a bit with Postgres and ext3 (with and without Linux
software RAID1) and have found that since somewhere after 2.6.18, it has been
prohibitively slow and causing high latencies during buffer flushes. You will
probably see a significant improvement with ext4 (mkfs.ext4, not just remount as
ext4, which is also possible).

Also, you need to make sure that your blocks are properly aligned with SSDs,
that might explain low random I/O performance. See
http://www.nuclex.org/blog/personal/80-aligning-an-ssd-on-linux and
http://www.ocztechnologyforum.com/forum/showthread.php?54379-Linux-Tips-tweaks-and-alignment&p=373226&viewfull=1#post373226
for example.

Regards,
Marinos

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2011-04-22 23:19:19 Re: oom_killer
Previous Message Cédric Villemain 2011-04-22 19:18:49 Re: oom_killer