Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 90E879FA154 for ; Mon, 8 Oct 2007 17:51:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 04562-06 for ; Mon, 8 Oct 2007 17:51:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id BA1C49FA219 for ; Mon, 8 Oct 2007 17:50:57 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-220-98-36.bk9-dsl.surnet.cl [201.220.98.36]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l98Kob6i015872; Mon, 8 Oct 2007 13:50:38 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id CAE3247C70; Mon, 8 Oct 2007 16:50:35 -0400 (CLT) Date: Mon, 8 Oct 2007 16:50:35 -0400 From: Alvaro Herrera To: Bruce Momjian Cc: Tom Lane , Simon Riggs , Josh Berkus , pgsql-hackers@postgresql.org, Mija Lee Subject: Re: PG on NFS may be just a bad idea Message-ID: <20071008205035.GF6000@alvh.no-ip.org> References: <20071001234651.GD9430@alvh.no-ip.org> <200710082046.l98KkQj28574@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200710082046.l98KkQj28574@momjian.us> User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV 0.91.1/4502/Sun Oct 7 18:52:34 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Mon, 08 Oct 2007 13:50:38 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/259 X-Sequence-Number: 108627 Bruce Momjian wrote: > Alvaro Herrera wrote: > > Tom Lane wrote: > > > Simon Riggs writes: > > > > http://blogs.netapp.com/dave/2007/08/oracle-optimize.html > > > > > > Not a whole lot of technical content there, but pretty interesting > > > nonetheless. I *think* that the issues we're seeing are largely in the > > > NFS client-side kernel code, so bypassing that stack as Oracle is doing > > > might eliminate the problem. Of course, there's a sizable amount of > > > code to be written to do that ... > > > > Yeah. Next step we will be writing our own malloc. > > I assume there should be a ;-) in there because we already have our own > malloc (palloc). Yeah, some sort of smiley should be there. But what I'm talking about is rewriting the underlying memory allocation mechanism, just like we would be rewriting the NFS client. palloc uses malloc underneath. My thought is to replace that with sbrk, mmap or something like that. Not very portable though, a lot of work, and most likely not nearly enough benefits. -- Alvaro Herrera http://www.PlanetPostgreSQL.org/ "Nadie esta tan esclavizado como el que se cree libre no siendolo" (Goethe)