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 07:11:22
Message-ID: CAEepm=0rifp5cfM8a+pT=vkkcAGFzway8wubxBOm4q-RYoAVcQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jan 18, 2018 at 9:17 AM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
> Huh. That was simpler than I thought.
>
> Attached rebased versions.

Hi Claudio,

FYI the regression test seems to have some run-to-run variation.
Though it usually succeeds, recently I have seen a couple of failures
like this:

========= Contents of ./src/test/regress/regression.diffs
*** /home/travis/build/postgresql-cfbot/postgresql/src/test/regress/expected/vacuum.out
2018-01-24 01:41:28.200454371 +0000
--- /home/travis/build/postgresql-cfbot/postgresql/src/test/regress/results/vacuum.out
2018-01-24 01:51:07.970049937 +0000
***************
*** 128,134 ****
SELECT pg_relation_size('vactst', 'main');
pg_relation_size
------------------
! 0
(1 row)

SELECT count(*) FROM vactst;
--- 128,134 ----
SELECT pg_relation_size('vactst', 'main');
pg_relation_size
------------------
! 8192
(1 row)

SELECT count(*) FROM vactst;
======================================================================

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2018-01-25 07:26:00 Re: [PATCH] Logical decoding of TRUNCATE
Previous Message Andres Freund 2018-01-25 07:02:54 Re: JIT compiling with LLVM v9.0