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 32E93D1C9EA for ; Thu, 18 Mar 2004 17:58:01 +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 57371-03 for ; Thu, 18 Mar 2004 13:57:50 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 5D322D1C4EB for ; Thu, 18 Mar 2004 13:57:45 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 1F4DD357C4; Thu, 18 Mar 2004 09:57:50 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 1DC7235762; Thu, 18 Mar 2004 09:57:50 -0800 (PST) Date: Thu, 18 Mar 2004 09:57:50 -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: <20040318095213.C51797@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/257 X-Sequence-Number: 6113 On Thu, 18 Mar 2004, Saleh, Amgad H (Amgad) wrote: > > Stephan: > > In each table we're storing the max. string length. > > For example: > > for TEST_1, we're storing 'abcdefghjk' and 'lmnop' > for TEST_2, we're storing 'abcdefghjk' and 'lmnopqrstu' > for TEST_3, we're storing 'abcdefghjk' and 'lmnopqrstuvw' Hmm, on my machine it seemed like I was getting slightly different row count per page results for the first two cases. The last two aren't going to be different due to padding if the machine pads to 4 byte boundaries.