Re: PostgreSQL Disk Usage and Page Size - Mailing list pgsql-performance

From Stephan Szabo
Subject Re: PostgreSQL Disk Usage and Page Size
Date
Msg-id 20040318095213.C51797@megazone.bigpanda.com
Whole thread Raw
In response to PostgreSQL Disk Usage and Page Size  (Seum-Lim Gan <slgan@lucent.com>)
List pgsql-performance
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.


pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] fsync method checking
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] fsync method checking