Re: Disk tests for a new database server

Поиск
Список
Период
Сортировка
От Rory Campbell-Lange
Тема Re: Disk tests for a new database server
Дата
Msg-id 20051208225620.GA14485@campbell-lange.net
обсуждение исходный текст
Ответ на Re: Disk tests for a new database server  (Steve Poe <spoe@sfnet.cc>)
Список pgsql-performance
Hi Steve

On 08/12/05, Steve Poe (spoe@sfnet.cc) wrote:
> Rory,
>
> While I don't have my specific stats with my from my tests with XFS and
> bonnie for our company's db server, I do recall vividly that seq. output
> did not increase dramatically until I had 8+ discs in a RAID10
> configuration on an LSI card. I was not using LVM. If I had less than 8
> discs, seq. output was about equal regardless of file system being uses
> (EXT3,JFS,or XFS).

Thanks for the information. I certainly had not appreciated this fact.

Regards,
Rory

> On Thu, 2005-12-08 at 12:12 +0000, Rory Campbell-Lange wrote:
> > We are testing disk I/O on our new server (referred to in my recent
> > questions about LVM and XFS on this list) and have run bonnie++ on the
> > xfs partition destined for postgres; results noted below.
> >
> > I haven't been able to find many benchmarks showing desirable IO stats.
> > As far as I can tell the sequential input (around 110000K/sec) looks
> > good while the sequential output (around 50000K/sec) looks fairly
> > average.
> >
> > Advice and comments gratefully received.
> > Suggested Parameters for running pg_bench would be great!
> >
> > Thanks,
> > Rory
...
> > 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
> > mas          13000M 52655  99 52951  10 32246   7 41441  72 113438  12 590.0   0
> > mas          13000M 49306  83 51967   9 32269   7 42442  70 115427  12 590.5   1
> > mas          13000M 53449  89 51982  10 32625   7 42819  71 111829  11 638.3   0
> > mas          13000M 51818  88 51639   9 33127   7 42377  70 108585  11 556.5   0
...
> >                     ------Sequential Create------ --------Random Create--------
> >                     -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
> > files:max:min        /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP
> > mas              16  7970  36 +++++ +++  7534  34  7918  36 +++++ +++  4482  22
> > mas              16  7945  33 +++++ +++  7483  30  7918  42 +++++ +++  4438  20
> > mas              16  8481  48 +++++ +++  7468  31  7870  39 +++++ +++  4385  23
> > mas              16  7915  36 +++++ +++  7498  33  7930  41 +++++ +++  4619  23
> > mas              16  8553  35 +++++ +++  8312  38  8613  37 +++++ +++  4513  24
> > mas              16  8498  40 +++++ +++  8215  33  8570  43 +++++ +++  4858  26

В списке pgsql-performance по дате отправления:

Предыдущее
От: Amit V Shah
Дата:
Сообщение: Re: Joining 2 tables with 300 million rows
Следующее
От: David Lang
Дата:
Сообщение: Re: opinion on disk speed