X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C63A83AA262 for ; Tue, 14 Dec 2004 18:20:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94323-03 for ; Tue, 14 Dec 2004 18:20:12 +0000 (GMT) Received: from mail.logi-track.com (www.logi-track.com [213.239.193.212]) by svr1.postgresql.org (Postfix) with ESMTP id 10EF13AA22E for ; Tue, 14 Dec 2004 18:20:12 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (J2f7a.j.pppool.de [85.74.47.122]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logi-track.com (Postfix) with ESMTP id C985C301A6; Tue, 14 Dec 2004 19:20:12 +0100 (CET) Received: from kingfisher.intern.logi-track.com (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with SMTP id 3B8ECAB0EC; Tue, 14 Dec 2004 19:20:06 +0100 (CET) Date: Tue, 14 Dec 2004 19:20:06 +0100 From: Markus Schaber To: PostgreSQL Performance List Subject: Re: Anything to be gained from a 'Postgres Filesystem'? Message-ID: <20041214192006.7be1a56d@kingfisher.intern.logi-track.com> In-Reply-To: References: <20041104120047.62810c8f@kingfisher.intern.logi-track.com> Organization: logi-track ag, =?ISO-8859-15?Q?z=FCrich?= X-Mailer: Sylpheed-Claws 0.9.12b (GTK+ 1.2.10; i386-pc-linux-gnu) X-Face: Nx5T&>Nj$VrVPv}sC3IL&)TqHHOKCz/|)R$i"*r@w0{*I6w; UNU_hdl1J4NI_m{IMztq=>cmM}1gCLbAF+9\#CGkG8}Y{x%SuQ>1#t:; Z(|\qdd[i]HStki~#w1$TPF}:0w-7"S\Ev|_a$K wrote: > In an attempt to throw the authorities off his trail, schabios@logi-track= .com (Markus Schaber) transmitted: > > We should create a list of those needs, and then communicate those > > to the kernel/fs developers. Then we (as well as other apps) can > > make use of those features where they are available, and use the old > > way everywhere else. >=20 > Which kernel/fs developers did you have in mind? The ones working on > Linux? Or FreeBSD? Or DragonflyBSD? Or Solaris? Or AIX? All of them, and others (e. G. Windows). Once we have a list of those needs, the advocates can talk to the OS developers. Some OS developers will follow, others not. Then the postgres folks (and other application developers that benefit from this capabilities) can point interested users to our benchmarks and tell them that Foox performs 3 times as fast as BaarOs because they provide better support for database needs. > Please keep in mind that many of the PostgreSQL developers are BSD > folk that aren't particularly interested in creating bleeding edge > Linux capabilities. Then this should be motivation to add those things to BSD, maybe as a patch or loadable module so it does not bloat mainstream. I personally would prefer it to appear in BSD first, because in case it really pays of, it won't be long until it appears in Linux as well :-) > Jumping into a customized filesystem that neither hardware nor > software vendors would remotely consider supporting just doesn't look > like a viable strategy to me. I did not vote for a custom filesystem, as the OP did. I did vote for isolating a set of useful capabilities PostgreSQL could exploit, and then try to confince the kernel developers to include this capabilities, so they are likely to be included in the main distributions. I don't know about the BSD market, but I know that Redhat and SuSE often ship their patched versions of the kernels (so then they officially support the extensions), and most of this is likely to be included in main stream later. > > Maybe Reiser4 is a step into the right way, and maybe even a > > postgres plugin for Reiser4 will be worth the effort. Maybe XFS/JFS > > etc. already have such capabilities. Maybe that's completely wrong. >=20 > The capabilities tend to be redundant. They tend to implement vaguely > similar transactional capabilities to what databases have to > implement. The similarities are not close enough to eliminate either > variety of "commit" as redundant. But a speed gain may be possible by coordinating DB and FS tansactions. Thanks, Markus --=20 markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 z=FCrich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com