Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AE0699FB1E5 for ; Mon, 30 Apr 2007 12:31:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 56812-10 for ; Mon, 30 Apr 2007 12:31:42 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 53C279FA617 for ; Mon, 30 Apr 2007 12:31:43 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l3UFVX3t043471 for ; Mon, 30 Apr 2007 12:31:33 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l3UFMSTR042492 for pgsql-admin@postgresql.org; Mon, 30 Apr 2007 12:22:28 -0300 (ADT) (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: Fwd: File systems linux !!! Date: Mon, 30 Apr 2007 17:22:34 +0200 Organization: Hub.Org Networking Services Lines: 18 Message-ID: <463609BA.9010607@theendofthetunnel.de> References: <69f2062a0704280602i3404565o1f9cab9a1a1aa3c8@mail.gmail.com> <69f2062a0704300544x1d67ae51o43972acc7569950d@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: jose fuenmayor User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) In-Reply-To: <69f2062a0704300544x1d67ae51o43972acc7569950d@mail.gmail.com> To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/255 X-Sequence-Number: 25319 Excluding warehousing setups, where XFS might give some benefit, any modern file system on Linux should perform OK. I'd use what I'm comfortable with. In case your data set fits in RAM, it will stay in OS buffers all the time anyway. My choice is XFS, but I wouldn't recommend XFS to anyone unsure to what FS to use. There is far to much someone new XFS can do wrong. jose fuenmayor wrote: > Hi all, i need to install a database in postgres with high reading rates, > which is the best file system to do that , I am working on linux. > thanks in advance !!!! -- Best regards, Hannes Dorbath