Subject Re: [firebird-support] [OT] FYI: linux file systems and firebird
Author William L. Thomson Jr.
On Thu, 2005-12-22 at 17:12 -0800, Paulius Pazera wrote:
> Hey guys,
>
>
> I thought I share my experience. Brief conclusion - avoid ext2/ext3 file
> systems for big databases, for example XFS is significantly better

Thanks for doing the leg work on that. I was curious about that myself.
By any chance did you mess around with ext3's block sizes? I believe the
norm is 4k, but there are also 2k and 8k blocks available. Just curious
what it was when you were testing, and if you tried to "tune" ext3 at
all.

However it's some what commonly known that XFS does much better than
ext3 for large files. I was not sure if that had anything to do with Fb
because it's only using the fs to open close connections to db. Correct?
Now with backups, restores, I can totally see where the difference would
come from.

Anyway, thanks again.

--
Sincerely,
William L. Thomson Jr.
Obsidian-Studios, Inc.
http://www.obsidian-studios.com