Postgres is blocking ?

[foremtehan]

Check List

• Provide a clear title and detailed description of your question.
• I have searched the existing discussions and documentation to see if my question has already been answered.
• Include any relevant code snippets or examples to help us understand your question better.
• We encourage you to help others in the community by answering questions or providing feedback on existing discussions. This helps us build a strong and supportive community around Hypervel.
• Please be respectful and considerate in your interactions with others in the community.

Content

I'm using the latest hyperf docker image:

FROM hyperf/hyperf:8.4-alpine-vedge-swoole-slim-v6.0.2
...

with composer.json:

"hyperf/database-pgsql": "^3.1",

But is totally block the event loop:

go(fn() => dump('Should dump immediately BUT WAIT FOR 5 SECOND'));

DB::select('SELECT pg_sleep(5)');

Do i need extra extension or library? i heard that swoole has built-in support but i don't see its extension here:

Swoole => enabled
Author => Swoole Team <[email protected]>
Version => 6.0.2
Built => Apr 25 2025 10:59:56
coroutine => enabled with boost asm context
epoll => enabled
eventfd => enabled
signalfd => enabled
cpu_affinity => enabled
spinlock => enabled
rwlock => enabled
openssl => OpenSSL 3.5.0 8 Apr 2025
dtls => enabled
http2 => enabled
json => enabled
curl-native => enabled
curl-version => 8.13.0
zlib => 1.3.1
brotli => E16781312/D16781312
mutex_timedlock => enabled
pthread_barrier => enabled

Directive => Local Value => Master Value
swoole.enable_library => On => On
swoole.enable_fiber_mock => Off => Off
swoole.enable_preemptive_scheduler => Off => Off
swoole.display_errors => On => On
swoole.use_shortname => Off => Off
swoole.unixsock_buffer_size => 8388608 => 8388608