Re: Postgresql on file system EXT2 or EXT3 - Mailing list pgsql-general

From Rich Shepard
Subject Re: Postgresql on file system EXT2 or EXT3
Date
Msg-id Pine.LNX.4.56.0311270909230.14524@salmo.appl-ecosys.com
Whole thread Raw
In response to Postgresql on file system EXT2 or EXT3  ("Carmen Wai" <wai_carmen@hotmail.com>)
Responses Re: Postgresql on file system EXT2 or EXT3  ("Craig O'Shannessy" <craig@ucw.com.au>)
List pgsql-general
On Thu, 27 Nov 2003, Carmen Wai wrote:

> I would like to know whether there is any different in installing Postgresql
> on the Linux system with file system of EXT2 or EXT3. I have two machines
> with idential OS (Red Hat 7.3 install with postgresql 7.3.4) but with
> different file system, 1 is EXT2 and the other is EXT3. When I insert 10,000
> records to the two machines, I found that the machine with EXT2 insert much
> quicker than the other with EXT3.
>
> Is postgresqk perform better with EXT2 file system?

Carmen,

  Consider the overhead in having the security of a journaling file system
when you make your comparisons.

Rich

--
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
<http://www.appl-ecosys.com>

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Open source data modeling tools for PostgreSQL
Next
From: "Keith C. Perry"
Date:
Subject: Re: Happy Thanksgiving!