Re: Anything to be gained from a 'Postgres Filesystem'? - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: Anything to be gained from a 'Postgres Filesystem'?
Date
Msg-id opsf7op5j1cq72hf@musicbox
Whole thread Raw
In response to Anything to be gained from a 'Postgres Filesystem'?  ("Matt Clark" <matt@ymogen.net>)
List pgsql-performance
    Reiser4 ?

On Thu, 21 Oct 2004 08:58:01 +0100, Matt Clark <matt@ymogen.net> wrote:

> 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
>
>
>
> Matt Clark
> Ymogen Ltd
> P: 0845 130 4531
> W: https://ymogen.net/
> 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@postgresql.org)
>



pgsql-performance by date:

Previous
From: "Leeuw van der, Tim"
Date:
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Next
From: "Matt Clark"
Date:
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?