Skip site navigation (1) Skip section navigation (2)

Anything to be gained from a 'Postgres Filesystem'?

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Anything to be gained from a 'Postgres Filesystem'?
Date: 2004-10-21 07:58:01
Message-ID: 008601c4b743$aff57f10$8300a8c0@solent (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
I suppose I'm just idly wondering really.  Clearly it's against PG
philosophy to build an FS or direct IO management into PG, but now it's so
relatively easy to plug filesystems into the main open-source Oses, It
struck me that there might be some useful changes to, say, XFS or ext3, that
could be made that would help PG out.

I'm thinking along the lines of an FS that's aware of PG's strategies and
requirements and therefore optimised to make those activities as efiicient
as possible - possibly even being aware of PG's disk layout and treating
files differently on that basis.

Not being an FS guru I'm not really clear on whether this would help much
(enough to be worth it anyway) or not - any thoughts?  And if there were
useful gains to be had, would it need a whole new FS or could an existing
one be modified?

So there might be (as I said, I'm not an FS guru...):
* great append performance for the WAL?
* optimised scattered writes for checkpointing?
* Knowledge that FSYNC is being used for preserving ordering a lot of the
time, rather than requiring actual writes to disk (so long as the writes
eventually happen in order...)?


Matt Clark
Ymogen Ltd
P: 0845 130 4531
M: 0774 870 1584


pgsql-performance by date

Next:From: Alban Medici (NetCentrex)Date: 2004-10-21 08:24:04
Subject: Re: Free PostgreSQL Training, Philadelphia, Oct 30
Previous:From: Joshua D. DrakeDate: 2004-10-21 06:13:32
Subject: Re: create index with substr function

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group