Re: Postgresql on file system EXT2 or EXT3

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>