Re: File system performance and pg_xlog

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: mlw <markw(at)mohawksoft(dot)com>, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: File system performance and pg_xlog
Date: 2001-05-07 17:18:50
Message-ID: 20010507191850.A9116@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, May 07, 2001 at 12:12:43PM -0400, Bruce Momjian wrote:
> > If one looks at the FAT file system with an open mind and a clear understanding
> > of how it will be used, some small modifications may make it the functional
> > equivalent of a managed table space volume, at least under Linux.
>
> Can I ask if we are talking FAT16 (DOS) or FAT32 (NT)?

Does not matter. Arhitecture is same. FAT16 is not DOS-only,
and FAT32 is not NT-only. And there is VFAT16 and VFAT32...

Point 1 in this discussion seems to be that for storing WAL
files on a FAT-like fs seems to be better (less overhead) than
ext2/ufs like fs.

Point 2: as vendors do not think of FAT as critical fs, it is
probably not very optimised for things like SMP; also reliability
(this probably comes from FAT design itself (thats why it has
probably less overhead too...)).

Point 3: as FAT-like fs's are probably least-overhead
fs's, could we get any better with a pgfs implementation?

Conclusion: ?

--
marko

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark L. Woodward 2001-05-07 17:24:13 Re: File system performance and pg_xlog
Previous Message Vince Vielhaber 2001-05-07 16:56:03 Re: typo in psql's help