pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Arthurs <tarthurs@jobflash.com>
To: pgsql-performance@postgresql.org
Subject: PG block sizes
Date: Sun, 27 Feb 2005 14:32:01 -0800
Message-ID: <42224A61.3080707@jobflash.com> (raw)

Hi, All

I'm trying to tune a software RAID 0 (striped) on a solaris 9, sparc box.  Currently I'm using a raid 1 (mirrored) array on two discs for the data area,
and I put in 4 new drives last night (all are f-cal).  On the new array I have a width of 4, and used the default interleave factor of 32k.  I believe
a smaller interleave factor may get me better read performance (I'm seeing a bulk load performance increase of about 35% but a 7-8x worse read performance
between the two RAID setups.)

Conventional wisdom is  using an interleave factor < = db default block size gives the best read performance.  I would like to try that (though this testing
is burning a lot of daylight, since I'll have to reload the db every time I remake the RAID.)

Question:  what't the best block size to use for postgresql on solaris?  (I'm using 7.4.5)



Message-ID: <42224A61.3080707@jobflash.com>
Permalink:  ../42224A61.3080707@jobflash.com/
Also on:    postgresql.org/message-id/42224A61.3080707@jobflash.com

 · 

reply

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-performance@postgresql.org
  Cc: tarthurs@jobflash.com
  Subject: Re: PG block sizes
  In-Reply-To: <42224A61.3080707@jobflash.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