pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
fsync tests
3+ messages / 3 participants
[nested] [flat]

* fsync tests
@ 2010-06-06 23:07 RBN <rbn.ggl@gmail.com>
  2010-06-10 22:15 ` Re: fsync tests Bruce Momjian <bruce@momjian.us>
  2010-06-11 04:27 ` Re: fsync tests Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: RBN @ 2010-06-06 23:07 UTC (permalink / raw)
  To: pgsql-admin

I ran test_fsync on a local ext 3 partition and on a raid jfs SSD array
8x32GB RAID10.  The local disk returned quickly and gave what looks like
acceptable results.  However, the RAID looks pretty bad.  Any one have any
idea why fsync would take so long on an SSD RAID 10.


LOCAL DISK
Simple write timing:
    write                    0.005460

Compare fsync times on write() and non-write() descriptor:
(If the times are similar, fsync() can sync data written
 on a different descriptor.)
    write, fsync, close      0.072429
    write, close, fsync      0.075627

Compare one o_sync write to two:
    (o_sync unavailable)
    (o_dsync unavailable)
    write, fdatasync         0.075907
    write, fsync,            0.076320

Compare file sync methods with 2 8k writes:
    (o_dsync unavailable)
    write, fdatasync         0.108367
    write, fsync,            0.108659



RAID 10 SSD jfs
Simple write timing:
    write                    0.004843

Compare fsync times on write() and non-write() descriptor:
(If the times are similar, fsync() can sync data written
 on a different descriptor.)
    write, fsync, close     95.546382
    write, close, fsync     51.407276

Compare one o_sync write to two:
    (o_sync unavailable)
    (o_dsync unavailable)
    write, fdatasync        10.999764
    write, fsync,           80.696959

Compare file sync methods with 2 8k writes:
    (o_dsync unavailable)
    write, fdatasync       111.931881
    write, fsync,           99.329298

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: fsync tests
  2010-06-06 23:07 fsync tests RBN <rbn.ggl@gmail.com>
@ 2010-06-10 22:15 ` Bruce Momjian <bruce@momjian.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2010-06-10 22:15 UTC (permalink / raw)
  To: RBN <rbn.ggl@gmail.com>; +Cc: pgsql-admin

RBN wrote:
> I ran test_fsync on a local ext 3 partition and on a raid jfs SSD array
> 8x32GB RAID10.  The local disk returned quickly and gave what looks like
> acceptable results.  However, the RAID looks pretty bad.  Any one have any
> idea why fsync would take so long on an SSD RAID 10.

As the original author of the test, all I can say is that those numbers
look bad.  :-(

---------------------------------------------------------------------------

> 
> 
> LOCAL DISK
> Simple write timing:
>     write                    0.005460
> 
> Compare fsync times on write() and non-write() descriptor:
> (If the times are similar, fsync() can sync data written
>  on a different descriptor.)
>     write, fsync, close      0.072429
>     write, close, fsync      0.075627
> 
> Compare one o_sync write to two:
>     (o_sync unavailable)
>     (o_dsync unavailable)
>     write, fdatasync         0.075907
>     write, fsync,            0.076320
> 
> Compare file sync methods with 2 8k writes:
>     (o_dsync unavailable)
>     write, fdatasync         0.108367
>     write, fsync,            0.108659
> 
> 
> 
> RAID 10 SSD jfs
> Simple write timing:
>     write                    0.004843
> 
> Compare fsync times on write() and non-write() descriptor:
> (If the times are similar, fsync() can sync data written
>  on a different descriptor.)
>     write, fsync, close     95.546382
>     write, close, fsync     51.407276
> 
> Compare one o_sync write to two:
>     (o_sync unavailable)
>     (o_dsync unavailable)
>     write, fdatasync        10.999764
>     write, fsync,           80.696959
> 
> Compare file sync methods with 2 8k writes:
>     (o_dsync unavailable)
>     write, fdatasync       111.931881
>     write, fsync,           99.329298

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: fsync tests
  2010-06-06 23:07 fsync tests RBN <rbn.ggl@gmail.com>
@ 2010-06-11 04:27 ` Scott Marlowe <scott.marlowe@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Scott Marlowe @ 2010-06-11 04:27 UTC (permalink / raw)
  To: RBN <rbn.ggl@gmail.com>; +Cc: pgsql-admin

On Sun, Jun 6, 2010 at 5:07 PM, RBN <rbn.ggl@gmail.com> wrote:
>
>
> I ran test_fsync on a local ext 3 partition and on a raid jfs SSD array
> 8x32GB RAID10.  The local disk returned quickly and gave what looks like
> acceptable results.  However, the RAID looks pretty bad.  Any one have any
> idea why fsync would take so long on an SSD RAID 10.

Are you just running 1 loop?  Those numbers are worse than bad if
you're running one loop.

How are the SSD drives attached to your machine?  HW RAID, JBOD HW
Caching, direct HBA?



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2010-06-11 04:27 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-06 23:07 fsync tests RBN <rbn.ggl@gmail.com>
2010-06-10 22:15 ` Bruce Momjian <bruce@momjian.us>
2010-06-11 04:27 ` Scott Marlowe <scott.marlowe@gmail.com>

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