Skip site navigation (1) Skip section navigation (2)

Re: Performance increase with elevator=deadline

From: Enrico Sirola <enrico(dot)sirola(at)gmail(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Matthew <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance increase with elevator=deadline
Date: 2008-04-18 14:38:05
Message-ID: 544D07A2-EB3F-4D91-A749-0C4D5D38AB80@gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

Il giorno 11/apr/08, alle ore 20:03, Craig Ringer ha scritto:
>
> Speaking of I/O performance with PostgreSQL, has anybody here done  
> any testing to compare results with LVM to results with the same  
> filesystem on a conventionally partitioned or raw volume? I'd  
> probably use LVM even at a performance cost because of its admin  
> benefits, but I'd be curious if there is any known cost for use with  
> Pg. I've never been able to measure one with other workloads.

I performed some tests some time ago. LVM is significantly slower.
The disk subsystem is a HP P400/512MB battery-backed controller with 4  
disks in raid 10.
See the tests:


ext3 tests:

bonnie++ -s 16000 -u 0 -f -b
= 
= 
= 
= 
= 
= 
= 
========================================================================

Version  1.03       ------Sequential Output------ --Sequential Input-  
--Random-
                     -Per Chr- --Block-- -Rewrite- -Per Chr- --Block--  
--Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec  
%CP  /sec %CP
              16000M           153637  50 78895  17           204124   
17 700.6   1
                     ------Sequential Create------ --------Random  
Create--------
                     -Create-- --Read--- -Delete-- -Create-- --Read---  
-Delete--
               files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec  
%CP  /sec %CP
                  16  2233  10 +++++ +++  2606   8  2255  10 +++++ ++ 
+  2584   7
16000M,,,153637,50,78895,17,,,204124,17,700.6,1,16,2233,10,+++++,+++, 
2606,8,2255,10,+++++,+++,2584,7


bonnie++ -s 16000 -u 0 -f
= 
= 
= 
= 
= 
= 
= 
========================================================================

Version  1.03       ------Sequential Output------ --Sequential Input-  
--Random-
                     -Per Chr- --Block-- -Rewrite- -Per Chr- --Block--  
--Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec  
%CP  /sec %CP
              16000M           162223  51 77277  17           207055   
17 765.3   1
                     ------Sequential Create------ --------Random  
Create--------
                     -Create-- --Read--- -Delete-- -Create-- --Read---  
-Delete--
               files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec  
%CP  /sec %CP
                  16 +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++  
+++++ +++
16000M,,,162223,51,77277,17,,,207055,17,765.3,1,16,+++++,+++,+++++,+++, 
+++++,+++,+++++,+++,+++++,+++,+++++,+++

= 
= 
= 
= 
= 
= 
= 
========================================================================

LVM tests:

bonnie++ -u 0 -f -s 16000 -b
Version  1.03       ------Sequential Output------ --Sequential Input-  
--Random-
                     -Per Chr- --Block-- -Rewrite- -Per Chr- --Block--  
--Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec  
%CP  /sec %CP
              16000M           153768  52 53420  13           177414   
15 699.8   1
                     ------Sequential Create------ --------Random  
Create--------
                     -Create-- --Read--- -Delete-- -Create-- --Read---  
-Delete--
               files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec  
%CP  /sec %CP
                  16  2158   9 +++++ +++  2490   7  2177   9 +++++ ++ 
+  2460   7
16000M,,,153768,52,53420,13,,,177414,15,699.8,1,16,2158,9,+++++,+++, 
2490,7,2177,9,+++++,+++,2460,7

bonnie++ -u 0 -f -s 16000
Version  1.03       ------Sequential Output------ --Sequential Input-  
--Random-
                     -Per Chr- --Block-- -Rewrite- -Per Chr- --Block--  
--Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec  
%CP  /sec %CP
              16000M           161476  53 54904  13           171693   
14 774.3   1
                     ------Sequential Create------ --------Random  
Create--------
                     -Create-- --Read--- -Delete-- -Create-- --Read---  
-Delete--
               files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec  
%CP  /sec %CP
                  16 +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++  
+++++ +++
16000M,,,161476,53,54904,13,,,171693,14,774.3,1,16,+++++,+++,+++++,+++, 
+++++,+++,+++++,+++,+++++,+++,+++++,+++

Bye,
e.


In response to

Responses

pgsql-performance by date

Next:From: Jeffrey BakerDate: 2008-04-18 16:35:42
Subject: 3-days-long vacuum of 20GB table
Previous:From: MatthewDate: 2008-04-18 11:01:11
Subject: Re: Strange behavior: pgbench and new Linux kernels

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group