Re: Freeze avoidance of very large table.

From: Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Stark <stark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Subject: Re: Freeze avoidance of very large table.
Date: 2015-07-16 11:51:09
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-hackers

On Wed, Jul 15, 2015 at 3:07 AM, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com> wrote:
> On Wed, Jul 15, 2015 at 12:55 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>> On 10 July 2015 at 15:11, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com> wrote:
>>> Oops, I had forgotten to add new file heapfuncs.c.
>>> Latest patch is attached.
>> I think we've established the approach is desirable and defined the way
>> forwards for this, so this is looking good.
> If we want to move stuff like pg_stattuple, pg_freespacemap into core,
> we could move them into heapfuncs.c.
>> Some of my requests haven't been actioned yet, so I personally would not
>> commit this yet. I am happy to continue as reviewer/committer unless others
>> wish to take over.
>> The main missing item is pg_upgrade support, which won't happen by end of
>> CF1, so I am marking this as Returned With Feedback. Hopefully we can review
>> this again before CF2.
> I appreciate your reviewing.
> Yeah, the pg_upgrade support and regression test for VFM patch is
> almost done now, I will submit the patch in this week after testing it
> .

Attached patch is latest v9 patch.

I added:
- regression test for visibility map (visibilitymap.sql and
visibilitymap.out files)
- pg_upgrade support (rewriting vm file to vfm file)
- regression test for pg_upgrade

Please review it.


Masahiko Sawada

Attachment Content-Type Size
000_add_frozen_bit_into_visibilitymap_v9.patch text/x-patch 73.8 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2015-07-16 11:51:57 Re: multivariate statistics / patch v7
Previous Message Petr Jelinek 2015-07-16 11:04:17 Re: TABLESAMPLE patch is really in pretty sad shape