| From: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | robertmhaas(at)gmail(dot)com |
| Cc: | michael(dot)paquier(at)gmail(dot)com, bruce(at)momjian(dot)us, sawada(dot)mshk(at)gmail(dot)com, jeff(dot)janes(at)gmail(dot)com, amit(dot)kapila16(at)gmail(dot)com, andres(at)anarazel(dot)de, simon(at)2ndquadrant(dot)com, josh(at)agliodbs(dot)com, masao(dot)fujii(at)gmail(dot)com, alvherre(at)2ndquadrant(dot)com, Jim(dot)Nasby(at)bluetreble(dot)com, petr(at)2ndquadrant(dot)com, stark(at)mit(dot)edu, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Freeze avoidance of very large table. |
| Date: | 2015-12-21 08:27:31 |
| Message-ID: | 20151221.172731.232606621.horiguchi.kyotaro@lab.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
At Fri, 18 Dec 2015 12:09:43 -0500, Robert Haas <robertmhaas(at)gmail(dot)com> wrote in <CA+TgmoZCCFwgKL0PmSi=htfZ2aCOZPoTPD73ecvSA9rhXa0zUw(at)mail(dot)gmail(dot)com>
> On Thu, Dec 17, 2015 at 1:17 AM, Michael Paquier
> <michael(dot)paquier(at)gmail(dot)com> wrote:
> > I am not really getting the meaning of this sentence. Shouldn't this
> > be reworded something like:
> > "Freezing occurs on the whole table once all pages of this relation require it."
>
> That statement isn't remotely true, and I don't think this patch
> changes that. Freezing occurs on the whole table once relfrozenxid is
> old enough that we think there might be at least one page in the table
> that requires it.
I doubt I can explain this accurately, but I took the original
phrase as that if and only if all pages of the table are marked
as "requires freezing" by accident, all pages are frozen. It's
quite obvious but it is what I think "happen to require freezing"
means. Does this make sense?
The phrase might not be necessary if this is correct.
regards,
--
Kyotaro Horiguchi
NTT Open Source Software Center
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2015-12-21 09:02:29 | Re: Combining Aggregates |
| Previous Message | Albe Laurenz | 2015-12-21 08:22:45 | Re: Experimental evaluation of PostgreSQL's query optimizer |