| From: | Claudio Freire <klaussfreire(at)gmail(dot)com> |
|---|---|
| To: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, 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-02-06 13:18:05 |
| Message-ID: | CAGTBQpbe36CUJLvmiVPbZyEEY=7SMkQZr=11mOV9J834bLNqRA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Feb 6, 2018 at 4:35 AM, Kyotaro HORIGUCHI
<horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> wrote:
>> It's starting to look like a timing effect indeed.
>
> It seems to be truncation skip, maybe caused by concurrent
> autovacuum.
Good point, I'll also disable autovacuum on vactst.
> See lazy_truncate_heap() for details. Updates of
> pg_stat_*_tables can be delayed so looking it also can fail. Even
> though I haven't looked the patch closer, the "SELECT
> pg_relation_size()" doesn't seem to give something meaningful
> anyway.
Maybe then "explain (analyze, buffers, costs off, timing off, summary
off) select * from vactst" then.
The point is to check that the relation's heap has 0 pages.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | amul sul | 2018-02-06 13:35:33 | Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key |
| Previous Message | Claudio Freire | 2018-02-06 12:51:45 | Re: [HACKERS] [PATCH] Vacuum: Update FSM more frequently |