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

Re: Anything to be gained from a 'Postgres Filesystem'?

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: matt(at)ymogen(dot)net, pgsql-performance(at)postgresql(dot)org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: 2004-10-21 08:33:31
Message-ID: opsf7op5j1cq72hf@musicbox (view raw or flat)
Thread:
Lists: pgsql-performance
	Reiser4 ?

On Thu, 21 Oct 2004 08:58:01 +0100, Matt Clark <matt(at)ymogen(dot)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(at)postgresql(dot)org)
>



In response to

pgsql-performance by date

Next:From: Matt ClarkDate: 2004-10-21 08:38:40
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Previous:From: Leeuw van der, TimDate: 2004-10-21 08:27:22
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?

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