Re: Unexpected page allocation behavior on insert-only tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Renner <michael(dot)renner(at)amd(dot)co(dot)at>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Unexpected page allocation behavior on insert-only tables
Date: 2010-05-16 00:16:47
Message-ID: 20352.1273969007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Renner <michael(dot)renner(at)amd(dot)co(dot)at> writes:
> I've written a simple tool to generate traffic on a database [1], which
> did about 30 TX/inserts per second to a table. Upon inspecting the data
> in the table, I noticed the expected grouping of tuples which came from
> a single backend to matching pages [2]. The strange part was that the
> pages weren't completely filled but the backends seemed to jump
> arbitrarily from one page to the next [3]. For the table in question
> this resulted in about 10% wasted space.

Which table would that be? The trigger-driven updates to "auction",
in particular, would certainly guarantee some amount of "wasted" space.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Renner 2010-05-16 00:24:36 Re: Unexpected page allocation behavior on insert-only tables
Previous Message Tom Lane 2010-05-16 00:09:23 Re: [PATCH] Add SIGCHLD catch to psql