[zeromq-dev] Question about CZMQ threading and Postgres

[Alan Ward]

Hi,
I would like to find out if anyone has successfully run multiple worker
threads created by CZMQ zthread_fork, where each thread is the same and
running Postgres updates to the same database.

My system works fine if I use one worker thread, but if I increase it to
(say) 3, Postgres fails with (undocumented) YE000 errors.

Searching the net finds some instances of this error being reported in 2007
and it relates to problems with concurrent access from multiple threads.

Should I be using zthread_new?

Thanks,
Alan