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 <br...@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 + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers