Looking at that list, I got the feeling that you'd want to push that PG-awareness down into the block-io layer as well, then, so as to be able to optimise for (perhaps) conflicting goals depending on what the app does; for the IO system to be able to read the apps mind it needs to have some knowledge of what the app is / needs / wants and I get the impression that this awareness needs to go deeper than the FS only.
(But you might have time to rewrite Linux/BSD as a PG-OS? just kidding!)
From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org]On Behalf Of Matt Clark
Sent: Thursday, October 21, 2004 9:58 AM
Subject: [PERFORM] Anything to be gained from a 'Postgres Filesystem'?
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...)?
P: 0845 130 4531
M: 0774 870 1584
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
pgsql-performance by date
|Next:||From: Pierre-Frédéric Caillaud||Date: 2004-10-21 08:33:31|
|Subject: Re: Anything to be gained from a 'Postgres Filesystem'?|
|Previous:||From: Alban Medici (NetCentrex)||Date: 2004-10-21 08:24:04|
|Subject: Re: Free PostgreSQL Training, Philadelphia, Oct 30|