X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 31BB0D1C9E6 for ; Wed, 17 Mar 2004 23:49:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30160-01 for ; Wed, 17 Mar 2004 19:49:34 -0400 (AST) Received: from auemail1.firewall.lucent.com (auemail1.lucent.com [192.11.223.161]) by svr1.postgresql.org (Postfix) with ESMTP id 3B582D1B560 for ; Wed, 17 Mar 2004 19:49:31 -0400 (AST) Received: from ihmail.ih.lucent.com (h135-1-218-70.lucent.com [135.1.218.70]) by auemail1.firewall.lucent.com (Switch-2.2.8/Switch-2.2.8) with ESMTP id i2HNnTi01087 for ; Wed, 17 Mar 2004 17:49:30 -0600 (CST) Received: from [135.185.171.143] (USS-Excelsior.ih.lucent.com [135.185.171.143]) by ihmail.ih.lucent.com (8.11.7+Sun/EMS-1.5 sol2) id i2HNnSE20191; Wed, 17 Mar 2004 17:49:28 -0600 (CST) Mime-Version: 1.0 X-Sender: slgan@135.1.218.70 Message-Id: Date: Wed, 17 Mar 2004 17:52:13 -0600 To: pgsql-performance@postgresql.org From: Seum-Lim Gan Subject: PostgreSQL Disk Usage and Page Size Cc: ahsaleh@lucent.com Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/250 X-Sequence-Number: 6106 Hi all, we have a question about the pagesize in PostgreSQL: Using different pagesizes: 4K, 8K, 16K, 32K, when we store different record sizes such as in the following example: CREATE TABLE TEST_1 ( F1 VARCHAR(10), F2 VARCHAR(5) ); CREATE TABLE TEST_2 ( F1 VARCHAR(10), F2 VARCHAR(10) ); we're consistently having the following storage behavior: 60 records / 4k_page 120 records / 8k_page 240 records / 16k_page 480 records / 32k_page. So it seems that it doesn't matter whether the record size is 15 bytes or 20 bytes, there's maximum number of records per page as shown above. Any clues if there's any parameter or bug causing that? Gan (for Amgad) -- +--------------------------------------------------------+ | Seum-Lim GAN email : slgan@lucent.com | | Lucent Technologies | | 2000 N. Naperville Road, 6B-403F tel : (630)-713-6665 | | Naperville, IL 60566, USA. fax : (630)-713-7272 | | web : http://inuweb.ih.lucent.com/~slgan | +--------------------------------------------------------+