pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedfsync 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