X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 147FB475D3B for ; Sun, 23 Mar 2003 03:45:26 -0500 (EST) Received: from relay.icomedias.com (relay.icomedias.com [62.99.232.66]) by postgresql.org (Postfix) with ESMTP id 2DC21474E42 for ; Sun, 23 Mar 2003 03:45:25 -0500 (EST) Received: from loki.icomedias.com ([10.192.17.128]) by relay.icomedias.com (8.12.8/8.12.8) with ESMTP id h2N8jOsl010778 for ; Sun, 23 Mar 2003 09:45:24 +0100 From: Mario Weilguni To: pgsql-performance@postgresql.org Subject: Re: Page Size in Future Releases Date: Sun, 23 Mar 2003 09:46:41 +0100 User-Agent: KMail/1.5 References: <16704.1048292123@sss.pgh.pa.us> In-Reply-To: <16704.1048292123@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200303230946.41441.mweilguni@sime.com> avpresult: 0, ok, ok X-Scanned-By: MIMEDefang 2.16 (www . roaringpenguin . com / mimedefang) X-Spam-Status: No, hits=-19.6 required=5.0 tests=IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES, USER_AGENT autolearn=ham version=2.50-cvs X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50-cvs (1.172-2003-02-14-exp) X-Archive-Number: 200303/155 X-Sequence-Number: 1453 Am Samstag, 22. M=E4rz 2003 01:15 schrieb Tom Lane: > "Kendrick C. Wilson" writes: > > Will a increase in the size of a data page increase performance of a > > database with large records? > > Probably not; in fact the increased WAL overhead could make it a net > loss. But feel free to try changing BLCKSZ to see how it works for you. I've several database with 32KB and 8KB, and though the results are not rea= lly comparable due to slight different hardware, I've the feeling that 8KB = buffers work best in most cases. The only difference I noticed are large ob= jects which seem to work slightly better with larger sizes. Regards, Mario Weilguni