Re: pgbench -f and vacuum

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: masao(dot)fujii(at)gmail(dot)com
Cc: Jim(dot)Nasby(at)bluetreble(dot)com, dgrowleyml(at)gmail(dot)com, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgbench -f and vacuum
Date: 2014-12-21 14:58:32
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> On Sun, Dec 14, 2014 at 11:43 AM, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
>>> If we care enough about that case to attempt the vacuum anyway then we
>>> need to do something about the error message; either squelch it or
>>> check for the existence of the tables before attempting to
>>> vacuum. Since there's no way to squelch in the server logfile, I think
>>> checking for the table is the right answer.
>> Fair enough. I will come up with "checking for table before vacuum"
>> approach.
> +1 for this approach.

Here is the patch I promised.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan

Attachment Content-Type Size
pgbench-f-noexit-v2.patch text/x-patch 2.7 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-12-21 15:03:54 Re: PrivateRefCount patch has got issues
Previous Message Tomas Vondra 2014-12-21 13:38:24 Re: PATCH: decreasing memory needlessly consumed by array_agg