From juniorlist@yahoo.com.br Wed Aug 6 20:39:16 2003 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1A280D1C91A for ; Wed, 6 Aug 2003 20:39:16 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 68575-09 for ; Wed, 6 Aug 2003 17:37:55 -0300 (ADT) Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com [216.136.174.114]) by svr1.postgresql.org (Postfix) with SMTP id AA14DD1C4BF for ; Wed, 6 Aug 2003 17:39:04 -0300 (ADT) Received: from unknown (HELO notebook) (juniorlist@200.180.192.112 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 6 Aug 2003 20:39:05 -0000 Message-ID: <034201c35c5a$d5f3c2c0$70c0b4c8@notebook> From: "Wilson A. Galafassi Jr." To: Subject: ext3 block size Date: Wed, 6 Aug 2003 17:34:39 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0337_01C35C41.037A1D30" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_60_70 X-Spam-Level: X-Archive-Number: 200308/115 X-Sequence-Number: 2932 This is a multi-part message in MIME format. ------=_NextPart_000_0337_01C35C41.037A1D30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hello. my database size is 5GB. what is the block size recommend? thanks wilson ------=_NextPart_000_0337_01C35C41.037A1D30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hello.
my database size is 5GB. what is the block= size=20 recommend?
thanks
wilson
 
------=_NextPart_000_0337_01C35C41.037A1D30-- From scott.marlowe@ihs.com Wed Aug 6 20:51:59 2003 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2582CD1C96A for ; Wed, 6 Aug 2003 20:51:59 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 76414-02 for ; Wed, 6 Aug 2003 17:50:38 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id DA02DD1C7F5 for ; Wed, 6 Aug 2003 17:51:47 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.9/8.12.9) with ESMTP id h76Kp9bS002033; Wed, 6 Aug 2003 14:51:09 -0600 (MDT) Date: Wed, 6 Aug 2003 14:37:34 -0600 (MDT) From: "scott.marlowe" To: "Wilson A. Galafassi Jr." Cc: Subject: Re: ext3 block size In-Reply-To: <034201c35c5a$d5f3c2c0$70c0b4c8@notebook> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-MailScanner: Found to be clean X-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/117 X-Sequence-Number: 2934 On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote: > hello. > my database size is 5GB. what is the block size recommend? Well, the biggest block size currently supported by stock linux distros is 4k, so I'd go with that. Postgresql's default block size of 8k is fine also. Note that linux page/system/file block sizes are NOT related to Postgresql block sizes.