Re: Postgresql on file system EXT2 or EXT3

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql on file system EXT2 or EXT3
Date: 2003-11-27 17:10:22
Message-ID: Pine.LNX.4.56.0311270909230.14524@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keith C. Perry 2003-11-27 17:45:06 Re: Happy Thanksgiving!
Previous Message Rich Shepard 2003-11-27 17:09:04 Re: Open source data modeling tools for PostgreSQL