Postgres Pro
Downloads
Home   >   mailing lists

Raid 10 settings for optimal postgres performance? - Mailing list pgsql-general

From Chris Barnes
Subject Raid 10 settings for optimal postgres performance?
Date
Msg-id BLU149-W120737FB4D917745198AEDD43A0@phx.gbl
Whole thread Raw
Responses Re: Raid 10 settings for optimal postgres performance?  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Tree view
I have just configured our disks to raid10 from raid5.
The raid 10 is now 6 drives giving us 750G use by OS and postgres.
 
What is the preferred setup for postgres concerning cache settings on the controller and disks and the preferred block size allocated for the disks when postgres uses block size 8192?
 
df -h
/dev/sda3             750G   65G  647G  10% /
/dev/sda1             496M   17M  454M   4% /boot

show all;
server_version        | 8.4.2
block_size            | 8192
 
 
Controller settings
Read-cache mode - Enabled
Write-cache mode - Enabled (write-back)
Write-cache setting - Enabled (write-back) when protected by battery
Stripe-unit size                         : 256 KB
 
Disk setting
Write Cache                        : Disabled (write-through)
 
Postgresql.conf
fsync = on                              # turns forced synchronization on or off
#synchronous_commit = on                # immediate fsync at commit
wal_sync_method = fsync         # the default is the first option
 
Logical drive number 1
   Logical drive name                       : RAID10
   RAID level                               : 10
   Status of logical drive                  : Okay
   Size                                     : 858000 MB
   Read-cache mode                          : Enabled
   Write-cache mode                         : Enabled (write-back)
   Write-cache setting                      : Enabled (write-back) when protected by battery
   Partitioned                              : Yes
   Number of segments                       : 6
   Stripe-unit size                         : 256 KB
   Stripe order (Channel,Device)            : 0,0 0,1 0,2 0,3 0,4 0,5
   Defunct segments                         : No
   Defunct stripes                          : No

 
      Device #0
         Device is a Hard drive
         State                              : Online
         Supported                          : Yes
         Transfer Speed                     : SAS 3.0 Gb/s
         Reported Channel,Device            : 0,0
         Vendor                             : IBM-ESXS
         Model                              : ST3300655SS
         Firmware                           : BA26
         World-wide name                    : 5000C5000A42EFAC
         Size                               : 286102 MB
         Write Cache                        : Disabled (write-through)
         FRU                                : None
         PFA
 
Sincerely,
 
Chris
 

Stay in touch. Get Messenger on your phone now.

pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: stopping processes, preventing connections
Next
From: Brad Nicholson
Date:
Subject: Work Mem Allocation Questions