pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedfilesystems benchmark
3+ messages / 3 participants
[nested] [flat]
* filesystems benchmark
@ 2008-12-15 06:46 Adrian Moisey <adrian@careerjunction.co.za>
2008-12-15 12:02 ` Re: filesystems benchmark Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
2008-12-15 17:31 ` Re: filesystems benchmark Greg Smith <gsmith@gregsmith.com>
0 siblings, 2 replies; 3+ messages in thread
From: Adrian Moisey @ 2008-12-15 06:46 UTC (permalink / raw)
To: pgsql-performance
Hi
I'm trying to compare different filesystems for postgres using pgbench.
The problem I've seen is that my IO wait is very very low. Is there a
way I can get pgbench to do more to push that up a little?
--
Adrian Moisey
Acting Systems Designer | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za
Phone: +27 21 818 8621 | Mobile: +27 82 858 7830 | Fax: +27 21 818 8855
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: filesystems benchmark
2008-12-15 06:46 filesystems benchmark Adrian Moisey <adrian@careerjunction.co.za>
@ 2008-12-15 12:02 ` Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Vladimir Sitnikov @ 2008-12-15 12:02 UTC (permalink / raw)
To: Adrian Moisey <adrian@careerjunction.co.za>; +Cc: pgsql-performance
>
> I'm trying to compare different filesystems for postgres using pgbench.
> The problem I've seen is that my IO wait is very very low. Is there a way
> I can get pgbench to do more to push that up a little?
Why do you expect to see high IO wait?
Does your database fit in system memory? If you do not modify the data and
it is not large enough, it is unlikely you will hit IO wait.
Do you have write cache enabled for the file system/device? Even if you have
some DML statements, it would not be that easy to saturate write cache
enabled storage (especially, when it fits in memory).
Regards,
Vladimir Sitnikov
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: filesystems benchmark
2008-12-15 06:46 filesystems benchmark Adrian Moisey <adrian@careerjunction.co.za>
@ 2008-12-15 17:31 ` Greg Smith <gsmith@gregsmith.com>
1 sibling, 0 replies; 3+ messages in thread
From: Greg Smith @ 2008-12-15 17:31 UTC (permalink / raw)
To: Adrian Moisey <adrian@careerjunction.co.za>; +Cc: pgsql-performance
On Mon, 15 Dec 2008, Adrian Moisey wrote:
> I'm trying to compare different filesystems for postgres using pgbench. The
> problem I've seen is that my IO wait is very very low. Is there a way I can
> get pgbench to do more to push that up a little?
Increase the database scale until the wait is what you expect. See
http://www.westnet.com/~gsmith/gregsmith/content/postgresql/pgbench-scaling.htm
for details.
The latest filesystem performance comparison I'm aware of is at
http://www.baconandtech.com/files/filesystem_io.pdf
You might also take a look at that to make sure you're not re-mapping
territory that's already been explored.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-12-15 17:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-15 06:46 filesystems benchmark Adrian Moisey <adrian@careerjunction.co.za>
2008-12-15 12:02 ` Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
2008-12-15 17:31 ` Greg Smith <gsmith@gregsmith.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