pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Saleh, Amgad H (Amgad) <ahsaleh@lucent.com>
Cc: Seum-Lim Gan <slgan@lucent.com>
Cc: 'srn@commsecure.com.au' <srn@commsecure.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL Disk Usage and Page Size
Date: Thu, 18 Mar 2004 08:56:03 -0800 (PST)
Message-ID: <20040318085310.S50452@megazone.bigpanda.com> (raw)
In-Reply-To: <B2FB6044E0DF474E8CE4128871E616CC0A851618@il0015exch006u.ih.lucent.com>
References: <B2FB6044E0DF474E8CE4128871E616CC0A851618@il0015exch006u.ih.lucent.com>

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.




view thread (5+ messages)  latest in thread

Message-ID: <20040318085310.S50452@megazone.bigpanda.com>
Permalink:  ../20040318085310.S50452@megazone.bigpanda.com/
Also on:    postgresql.org/message-id/20040318085310.S50452@megazone.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sszabo@megazone.bigpanda.com, ahsaleh@lucent.com, slgan@lucent.com, srn@commsecure.com.au
  Subject: Re: PostgreSQL Disk Usage and Page Size
  In-Reply-To: <20040318085310.S50452@megazone.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox