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 B402DD1B8F5 for ; Thu, 18 Mar 2004 16:56:12 +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 35061-04 for ; Thu, 18 Mar 2004 12:56:05 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id DBA6BD1EB9B for ; Thu, 18 Mar 2004 12:56:00 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 5218C35762; Thu, 18 Mar 2004 08:56:03 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 508AE35441; Thu, 18 Mar 2004 08:56:03 -0800 (PST) Date: Thu, 18 Mar 2004 08:56:03 -0800 (PST) From: Stephan Szabo To: "Saleh, Amgad H (Amgad)" Cc: Seum-Lim Gan , "'srn@commsecure.com.au'" , pgsql-performance@postgresql.org Subject: Re: PostgreSQL Disk Usage and Page Size In-Reply-To: Message-ID: <20040318085310.S50452@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/254 X-Sequence-Number: 6110 On Thu, 18 Mar 2004, Saleh, Amgad H (Amgad) wrote: > Stephan / Stephen > > We know about the overhead and do understand the math you've provided. > This is not the question we're asking. We've just provided the table definitions as > examples. > > The real question was, even with the 52 & 56 (assuming right),' I wouldn't get > the same number of records per page for all 4k, 8k, 16k, and 32k pages. On my system, I don't using your tests, IIRC I got 134 with TEST_1 and like 128 or so on TEST_2 when I used strings of maximum length for the columns. > > To make it more clear to you here's an example: > > For an 8k-page: we've got 120 records/page for both tables and other tables such as > > CREATE TABLE TEST_3 ( > F1 VARCHAR(10), > F2 VARCHAR(12) ); Are you storing the same data in all three tables or different data in all three tables? That's important because there's no difference in length between varchar(5) and varchar(12) when storing the same 5 character string.