Re: Anything to be gained from a 'Postgres Filesystem'?
От | Pierre-Frédéric Caillaud |
---|---|
Тема | Re: Anything to be gained from a 'Postgres Filesystem'? |
Дата | |
Msg-id | opsf7op5j1cq72hf@musicbox обсуждение исходный текст |
Ответ на | Anything to be gained from a 'Postgres Filesystem'? ("Matt Clark" <matt@ymogen.net>) |
Список | 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 по дате отправления: