From: Glyn Astill <glynastill@yahoo.co.uk>
To: Koray Eyidoğan <korayey@gmail.com>
To: Thomas SIMON <tsimon@neteven.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Performances issues with SSD volume ?
Date: Mon, 18 May 2015 14:29:01 +0000 (UTC)
Message-ID: <1770498187.1993351.1431959341984.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <CAOrEZuhNQ1qpqMbHDa=iMxtcceQ12GN+T8DijvRghYr2SHq0WA@mail.gmail.com>
References: <CAOrEZuhNQ1qpqMbHDa=iMxtcceQ12GN+T8DijvRghYr2SHq0WA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> From: Koray Eyidoğan <korayey@gmail.com>
>To: Thomas SIMON <tsimon@neteven.com>
>Cc: pgsql-admin@postgresql.org
>Sent: Monday, 18 May 2015, 14:51
>Subject: Re: [ADMIN] Performances issues with SSD volume ?
>
>
>
>Hi Thomas,
>
>
>3.2 kernel may be #1 cause of your I/O load problem:
>
>
>http://www.databasesoup.com/2014/09/why-you-need-to-avoid-linux-kernel-32.html
>
>https://medium.com/postgresql-talk/benchmarking-postgresql-with-different-linux-kernel-versions-on-u...
>
>
>
>Have a nice day.
>
>
>Koray
Likely 3.2 kernel isn't helping, but I think we need much more information before jumping to conclusions.
You say you're IO bound, so some output from sar / iostat / dstat and pg_stat_activity etc before and during the issue would be of use.
Also:
System memory size
SSD Model numbers and how many
Raid controller
Partition allignments and stripe sizes
Kernel options
Filesystem used and mount options
IO Scheduler
Postgresql version and configuration
Connection pool sizing
Perhaps you could thow us the output of some of these:
fdisk -l
cat /etc/mtab
cat /sys/block/<ssd device>/queue/scheduler
sysctl kernel | grep sched
sysctl vm
select * from pg_stat_activity
select name, setting from pg_settings
lspci | grep -E 'RAID|SCSI|IDE|SATA'
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: pgsql-admin@postgresql.org
Cc: glynastill@yahoo.co.uk, korayey@gmail.com, tsimon@neteven.com
Subject: Re: Performances issues with SSD volume ?
In-Reply-To: <1770498187.1993351.1431959341984.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox