On Mon, Oct 17, 2016 at 10:04 PM, Kevin Grittner wrote:
> On Sun, Oct 16, 2016 at 9:26 PM, Masahiko Sawada
> wrote:
>
>> When I set old_snapshot_threshold = 0 I got error at step #3, which
>> means that the error is occurred without table pruning.
>
> The "snapshot too old" error can happen with
On Wed, Oct 19, 2016 at 11:11 AM, Bruce Momjian wrote:
> On Wed, Oct 19, 2016 at 11:08:28AM -0500, Kevin Grittner wrote:
>> On Wed, Oct 19, 2016 at 10:04 AM, Bruce Momjian wrote:
>>
>>> Slide 10 of this presentation has an example showing
>>> old_snapshot_threshold set to '1min':
>>>
>>>
On Wed, Oct 19, 2016 at 11:08:28AM -0500, Kevin Grittner wrote:
> On Wed, Oct 19, 2016 at 10:04 AM, Bruce Momjian wrote:
>
> > Slide 10 of this presentation has an example showing
> > old_snapshot_threshold set to '1min':
> >
> > http://momjian.us/main/writings/pgsql/features.pdf
>
> If
On Wed, Oct 19, 2016 at 10:04 AM, Bruce Momjian wrote:
> Slide 10 of this presentation has an example showing
> old_snapshot_threshold set to '1min':
>
> http://momjian.us/main/writings/pgsql/features.pdf
If the presentation is intending to show reasonable values for
production use, that
On Mon, Oct 17, 2016 at 08:04:43AM -0500, Kevin Grittner wrote:
> > We have regression test for this feature but it sets
> > old_snapshot_threshold = 0, I doubt about we can test it properly.
> > Am I missing something?
>
> This is a hard feature to test properly, and certainly hard to test
> with
On Sun, Oct 16, 2016 at 9:26 PM, Masahiko Sawada wrote:
> When I set old_snapshot_threshold = 0 I got error at step #3, which
> means that the error is occurred without table pruning.
The "snapshot too old" error can happen without pruning, but only
because there is no way to tell the difference
On Fri, Oct 14, 2016 at 11:29 PM, Kevin Grittner wrote:
> On Fri, Oct 14, 2016 at 8:53 AM, Amit Kapila wrote:
>> On Fri, Oct 14, 2016 at 1:40 PM, Masahiko Sawada
>> wrote:
>
>>> For example, I set old_snapshot_threshold = 1min and prepare a table
>>> and two terminals.
>>> And I did the followi
On Fri, Oct 14, 2016 at 8:53 AM, Amit Kapila wrote:
> On Fri, Oct 14, 2016 at 1:40 PM, Masahiko Sawada
> wrote:
>> For example, I set old_snapshot_threshold = 1min and prepare a table
>> and two terminals.
>> And I did the followings steps.
>>
>> 1. [Terminal 1] Begin transaction and get snapsh
On Fri, Oct 14, 2016 at 1:40 PM, Masahiko Sawada wrote:
> Hi all,
>
> I have a question about behavior of snapshot too old feature.
>
> For example, I set old_snapshot_threshold = 1min and prepare a table
> and two terminals.
> And I did the followings steps.
>
> 1. [Terminal 1] Begin transaction
