Josh, there seems to be an inconsistency in your blog. You say 3.10.X is
safe, but the graph you show with the poor performance seems to be from
3.13.X which as I understand it is a later kernel. Can you clarify which
3.X kernels are good to use and which are not?
Sorry to cut in -
So
On Thu, Apr 9, 2015 at 7:35 AM, Graeme B. Bell g...@skogoglandskap.no wrote:
ext4 settings
ext4, nobarrier
noatime+nodatime,
stripestride aligned between raid10 ext4 correctly.
Some other useful things to know
-- h710p
readahead disabled on H710P
writeback cache enabled on H710P
ext4 settings
ext4, nobarrier
noatime+nodatime,
stripestride aligned between raid10 ext4 correctly.
Some other useful things to know
-- h710p
readahead disabled on H710P
writeback cache enabled on H710P
Direct IO enabled on H710P
-- os filesystem settings
linux readahead enabled (16384),
Hey Mike,
What those graphs are showing is that the new kernel reduces the IO required
for the same DB load. At least, that’s how we’re supposed to interpret it.
I’d be curious to see a measure of the database load for both of those so we
can verify that the new kernel does in fact provide
Can you say how much faster it was?
Przemek Deć
2015-04-09 11:04 GMT+02:00 Graeme B. Bell g...@skogoglandskap.no:
Josh, there seems to be an inconsistency in your blog. You say 3.10.X is
safe, but the graph you show with the poor performance seems to be from
3.13.X which as I
From a measurement I took back when we did the upgrade:
performance with 2.6: (pgbench, size 100, 32 clients)
48 651 transactions per second (read only)
6 504 transactions per second (read-write)
performance with 3.18 (pgbench, size 100, 32 clients)
129 303 transactions per second (read
A tangent to the performance testing thread here, but an important issue that
you will see come up in your work this year or next.
PCIe SSD may include AHCI PCI SSD or NVMe PCI SSD.
AHCI = old style, basically it's faster than SATA3 but quite similar in terms
of how the operating system
Wow, thats huge performance gain.
And it was on ext4?
--
Linux Polska Sp. z o.o.
Przemysław Deć - Senior Solutions Architect
RHCSA, RHCJA, PostgreSQL Professional Certification
mob: +48 519 130 141
email: p...@linuxpolska.pl
www.linuxpolska.pl
