From: | Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org> |
---|---|
To: | mlw <markw(at)mohawksoft(dot)com> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Hackers List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Re: New Linux xfs/reiser file systems |
Date: | 2001-05-03 12:23:02 |
Message-ID: | Pine.LNX.4.30.0105031316200.20478-100000@sphinx.mythic-beasts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, 3 May 2001, mlw wrote:
> I would bet it is a huge amount of work to use a "table space" system
> and no one wants that.
From some stracing of 7.1, the most common syscall issued by
postgres is an lseek() to the end of the file, presumably to
find its length, which seems to happen up to about a dozen
times per (pgbench) transaction.
Tablespaces would solve this (not that lseek is a particularly
expensive operation, of course).
> Perhaps we can convince the Linux community to create a "dbfs" which
> is a stripped down simple no nonsense file system designed for
> applications like databases?
Sync-metadata ext2 should be fine. Filesystems fsck pretty
quick when they contain only a few large files.
Otherwise, something like "smugfs" (now obsolete) might do.
Matthew.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-03 13:07:30 | Re: \c connects as another user instead I want in psql |
Previous Message | mlw | 2001-05-03 12:09:01 | Re: New Linux xfs/reiser file systems |