Re: Physical append-only tables - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Physical append-only tables
Date
Msg-id 20161124012616.GA1668@momjian.us
Whole thread Raw
In response to Re: Physical append-only tables  (Greg Stark <stark@mit.edu>)
Responses Re: Physical append-only tables  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On Mon, Nov 14, 2016 at 08:43:12PM +0000, Greg Stark wrote:
> That said, I don't think the "maintain clustering a bit better using
> BRIN" is a bad idea. It's just the bit about turning a table
> append-only to deal with update-once data that I think is overreach.

What if we used BRIN to find heap pages where the new row was in the
page BRIN min/max range, and the heap page had free space.  Only if that
fails do we put is somewhere else in the heap.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [bugfix] commit timestamps ERROR on lookup of FrozenTransactionId
Next
From: Alvaro Herrera
Date:
Subject: Re: patch: function xmltable