|From:||Michael Renner <michael(dot)renner(at)amd(dot)co(dot)at>|
|Subject:||Unexpected page allocation behavior on insert-only tables|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
While preparing a replication test setup with 9.0beta1 I noticed strange
page allocation patterns which Andrew Gierth found interesting enough to
I've written a simple tool to generate traffic on a database , 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 . The strange part was that the
pages weren't completely filled but the backends seemed to jump
arbitrarily from one page to the next . For the table in question
this resulted in about 10% wasted space.
After issuing a VACUUM on the table the free space map got updated (or
initialized?) and the backends used the remaining space in the pages,
though the spurious page allocation continued.
Optimal usage seems to be 136 tuples per page for the table in question.
|Next Message||Robert Haas||2010-05-15 23:58:49||Re: [PATCH] Add SIGCHLD catch to psql|
|Previous Message||David Fetter||2010-05-15 23:46:07||Re: [PATCH] Add SIGCHLD catch to psql|