Adding -performance back in so others can learn.
On Apr 26, 2007, at 9:40 AM, Paweł Gruszczyński wrote:
Jim Nasby napisał(a):
On Apr 25, 2007, at 8:51 AM, Paweł Gruszczyński wrote:
where u6 stores Fedora Core 6 operating system, and u0 stores 3
partitions with ext2, ext3 and jfs filesystem.
On Apr 25, 2007, at 8:51 AM, Paweł Gruszczyński wrote:
where u6 stores Fedora Core 6 operating system, and u0 stores 3
partitions with ext2, ext3 and jfs filesystem.
Keep in mind that drives have a faster data transfer rate at the
outer-edge than they do at the inner edge, so if you've got
[mailto:[EMAIL PROTECTED]
Sent: Thursday, April 26, 2007 03:53 AM Eastern Standard Time
To: Pawel Gruszczynski
Cc: pgsql-performance@postgresql.org
Subject:Re: [PERFORM] What`s wrong with JFS configuration?
On Apr 25, 2007, at 8:51 AM, Pawel Gruszczynski wrote:
where u6 stores
Jim Nasby wrote:
On Apr 25, 2007, at 8:51 AM, Paweł Gruszczyński wrote:
where u6 stores Fedora Core 6 operating system, and u0 stores 3
partitions with ext2, ext3 and jfs filesystem.
Keep in mind that drives have a faster data transfer rate at the
outer-edge than they do at the inner edge
Paweł Gruszczyński wrote:
To test I use pgBench with default database schema, run for 25, 50, 75
users at one time. Every test I run 5 time to take average.
Unfortunetly my result shows that ext is fastest, ext3 and jfs are very
simillar. I can understand that ext2 without jurnaling is faster
On 25-Apr-07, at 4:54 AM, Heikki Linnakangas wrote:
Paweł Gruszczyński wrote:
To test I use pgBench with default database schema, run for 25,
50, 75 users at one time. Every test I run 5 time to take average.
Unfortunetly my result shows that ext is fastest, ext3 and jfs are
very simillar.
Alexander Staubo napisał(a):
On 4/25/07, Paweł Gruszczyński [EMAIL PROTECTED] wrote:
I have strange situation. I`m testing performance of PostgreSQL database
at different filesystems (ext2,ex3,jfs) and I cant say that JFS is as
much faster as it is said.
I don't know about 40-60% faster, but
[EMAIL PROTECTED] (Paweł Gruszczyński) writes:
To test I use pgBench with default database schema, run for 25, 50, 75
users at one time. Every test I run 5 time to take average.
Unfortunetly my result shows that ext is fastest, ext3 and jfs are
very simillar. I can understand that ext2 without
On Wed, 25 Apr 2007, Pawe?~B Gruszczy?~Dski wrote:
I was just reading some informations on the web (for example:
http://www.nabble.com/a-comparison-of-ext3,-jfs,-and-xfs-on-hardware-raid-t144738.html).
You were doing your tests with a database scale of 50. As Heikki already
pointed out,
