Re: Freeze avoidance of very large table.

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Petr Jelinek <petr(at)2ndquadrant(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-08-06 18:14:48
Message-ID: CANP8+jJA9wXkZV0bor-0_MaYuJA0VFh3Xss-JCabeuEpgwmD1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5 August 2015 at 18:46, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:

>
> What do others think?

Wow, everything moves when you blink, eh? Sorry I was wasn't watching this.
Mainly because I was working on some other related thoughts, separate post
coming.

1. Most importantly, it needs to be somewhere where we can use the function
in a regression test. As I said before, I would not commit this without a
formal proof of correctness.

2. I'd also like to be able to make checks on this while we're in
production, to ensure we have no bugs. I was trying to learn from earlier
mistakes and make sure we are ready with diagnostic tools to allow run-time
checks and confirm everything is good. If people feel that means I've asked
for something in the wrong place, I am happy to skip that request and place
it wherever requested.

--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2015-08-06 18:19:33 cache invalidation skip logic
Previous Message Andreas Seltenreich 2015-08-06 18:02:34 [sqlsmith] Failed assertion in analyzejoins.c