Re: [HACKERS] Vacuum: allow usage of more than 1GB of work mem

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se>, Andres Freund <andres(at)anarazel(dot)de>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>, Anastasia Lubennikova <lubennikovaav(at)gmail(dot)com>, PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Vacuum: allow usage of more than 1GB of work mem
Date: 2018-01-25 21:21:14
Message-ID: CAEepm=0VepApX_+1v5J9mQJgc9mqS_pi6hAbXLR5+XOzHbn8pA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jan 26, 2018 at 9:38 AM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
> I had the tests running in a loop all day long, and I cannot reproduce
> that variance.
>
> Can you share your steps to reproduce it, including configure flags?

Here are two build logs where it failed:

https://travis-ci.org/postgresql-cfbot/postgresql/builds/332968819
https://travis-ci.org/postgresql-cfbot/postgresql/builds/332592511

Here's one where it succeeded:

https://travis-ci.org/postgresql-cfbot/postgresql/builds/333139855

The full build script used is:

./configure --enable-debug --enable-cassert --enable-coverage
--enable-tap-tests --with-tcl --with-python --with-perl --with-ldap
--with-icu && make -j4 all contrib docs && make -Otarget -j3
check-world

This is a virtualised 4 core system. I wonder if "make -Otarget -j3
check-world" creates enough load on it to produce some weird timing
effect that you don't see on your development system.

--
Thomas Munro
http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2018-01-25 21:27:28 Re: reducing isolation tests runtime
Previous Message Tom Lane 2018-01-25 20:58:04 Re: reducing isolation tests runtime