Re: pgbnech: allow to cancel queries during benchmark

From: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pgbnech: allow to cancel queries during benchmark
Date: 2023-08-10 03:32:44
Message-ID: 20230810123244.bcd44ab06ce2ae1e89458706@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 9 Aug 2023 11:18:43 +0200 (CEST)
Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> wrote:

>
> I forgot, about the test:
>
> I think that it should be integrated in the existing
> "001_pgbench_with_server.pl" script, because a TAP script is pretty
> expensive as it creates a cluster, starts it… before running the test.

Ok. I'll integrate the test into 001.

> I'm surprise that IPC::Run does not give any access to the process number.
> Anyway, its object interface seems to allow sending signal:
>
> $h->signal("...")
>
> So the code could be simplified to use that after a small delay.

Thank you for your information.

I didn't know $h->signal() and I mimicked the way of
src/bin/psql/t/020_cancel.pl to send SIGINT to a running program. I don't
know why the psql test doesn't use the interface, I'll investigate whether
this can be used in our purpose, anyway.

Regards,
Yugo Nagata

>
> --
> Fabien.

--
Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2023-08-10 03:52:40 Re: [PoC] pg_upgrade: allow to upgrade publisher node
Previous Message Yugo NAGATA 2023-08-10 03:23:11 Re: pgbnech: allow to cancel queries during benchmark