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 315F13ABF27 for ; Thu, 23 Dec 2004 07:00:59 +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 93619-07 for ; Thu, 23 Dec 2004 07:00:55 +0000 (GMT) Received: from relay.icomedias.com (office.icomedias.com [62.99.232.80]) by svr1.postgresql.org (Postfix) with ESMTP id B42703ABFC5 for ; Thu, 23 Dec 2004 07:00:53 +0000 (GMT) Received: from loki.icomedias.com ([10.192.17.128]) by relay.icomedias.com (8.13.1/8.13.0) with ESMTP id iBN70gJL014231; Thu, 23 Dec 2004 08:00:42 +0100 From: Mario Weilguni To: pgsql-performance@postgresql.org Subject: Re: 8rc2 & BLCKSZ Date: Thu, 23 Dec 2004 08:00:41 +0100 User-Agent: KMail/1.7.50 Cc: Tom Lane , Vivek Khera References: <20322.1103749490@sss.pgh.pa.us> In-Reply-To: <20322.1103749490@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200412230800.41210.mweilguni@sime.com> X-Scanned-By: MIMEDefang 2.43 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.174 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_BOGUSMX, DNS_FROM_RFC_POST X-Spam-Level: ** X-Archive-Number: 200412/277 X-Sequence-Number: 9652 Am Mittwoch, 22. Dezember 2004 22:04 schrieb Tom Lane: > Vivek Khera writes: > > One of the suggestions handed to me a long time ago for speeding up PG > > on FreeBSD was to double the default blocksize in PG. I tried it, but > > found not a significant enough speed up to make it worth the trouble > > to remember to patch every version of Pg during the upgrade path (ie, > > 7.4.0 -> 7.4.2 etc.) Forgetting to do that would be disastrous! > > Not really --- the postmaster will refuse to start if the BLCKSZ shown > in pg_control doesn't match what is compiled in. I concur though that > there may be no significant performance gain. For some workloads there > may well be a performance loss from increasing BLCKSZ. I've several databases of the same version 7.2 with rowsizes from 8k and 32k with the same workload (a content management system), and the performance of the 32k variants is slightly better for a few queries, overall responsivness seems to better with 8k (maybe because the 8k variant has 4x more buffers). Regards, Mario Weilguni