Re: pgbench with libevent?

2023-08-14 Thread Tatsuo Ishii
> It could be refactored to support a different subset of event types -- > maybe just sockets, no latches and obviously no 'postmaster death'. Ok. > But figuring out how to make latches work between threads might also > be interesting for future projects... Maybe. Some people are working on

Re: pgbench with libevent?

2023-08-14 Thread Fabien COELHO
4. libevent development seems slugish, last bugfix was published 3 years ago, version 2.2 has been baking for years, but the development seems lively (+100 contributors). Ugh, I would stay away from something like that. Would we become hostage to an undelivering group? No thanks.

Re: pgbench with libevent?

2023-08-14 Thread Fabien COELHO
Interesting. In my understanding this also needs to make Latch frontend-friendly? It could be refactored to support a different subset of event types -- maybe just sockets, no latches and obviously no 'postmaster death'. But figuring out how to make latches work between threads might also be

Re: pgbench with libevent?

2023-08-14 Thread Fabien COELHO
Hello Thomas, Pgbench is managing clients I/Os manually with select or poll. Much of this could be managed by libevent. Or maybe libuv (used by nodejs?). From preliminary testing libevent seems not too good at fine grain time management which are used for throttling, whereas libuv

Re: pgbench with libevent?

2023-08-14 Thread Alvaro Herrera
On 2023-Aug-13, Fabien COELHO wrote: > 4. libevent development seems slugish, last bugfix was published 3 years ago, > version >2.2 has been baking for years, but the development seems lively (+100 > contributors). Ugh, I would stay away from something like that. Would we become hostage

Re: pgbench with libevent?

2023-08-14 Thread Thomas Munro
On Mon, Aug 14, 2023 at 6:07 PM Tatsuo Ishii wrote: > Interesting. In my understanding this also needs to make Latch > frontend-friendly? It could be refactored to support a different subset of event types -- maybe just sockets, no latches and obviously no 'postmaster death'. But figuring out

Re: pgbench with libevent?

2023-08-14 Thread Tatsuo Ishii
> On Mon, Aug 14, 2023 at 12:35 PM Fabien COELHO wrote: >> > Pgbench is managing clients I/Os manually with select or poll. Much of this >> > could be managed by libevent. >> >> Or maybe libuv (used by nodejs?). >> >> From preliminary testing libevent seems not too good at fine grain time >>

Re: pgbench with libevent?

2023-08-13 Thread Thomas Munro
On Mon, Aug 14, 2023 at 12:35 PM Fabien COELHO wrote: > > Pgbench is managing clients I/Os manually with select or poll. Much of this > > could be managed by libevent. > > Or maybe libuv (used by nodejs?). > > From preliminary testing libevent seems not too good at fine grain time > management

Re: pgbench with libevent?

2023-08-13 Thread Fabien COELHO
Pgbench is managing clients I/Os manually with select or poll. Much of this could be managed by libevent. Or maybe libuv (used by nodejs?). From preliminary testing libevent seems not too good at fine grain time management which are used for throttling, whereas libuv advertised that it is