Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Too much GPU workers startup/terminate if pg_strom.max_async_tasks in postgresql.conf #811

Open
kaigai opened this issue Jul 18, 2024 · 0 comments
Labels
attention to be solved with higher priority

Comments

@kaigai
Copy link
Contributor

kaigai commented Jul 18, 2024

postgresql.conf に pg_strom.max_async_tasks の設定値を書き込んでしまうと、
バックグラウンドワーカーの起動時にいったんデフォルト12に値をセットして、
それを20に再設定するという挙動を見せるため、それに引っ張られて、ワーカー
スレッドが短時間のうちにstartup/terminateしてしまう。

2024-07-18 12:55:52.043 JST [459737] LOG:  GPU0 workers - 0 startup, 8 terminate
2024-07-18 12:55:52.043 JST [459737] LOG:  GPU0 workers - 8 startup, 0 terminate
2024-07-18 12:55:52.312 JST [459737] LOG:  GPU0 workers - 0 startup, 8 terminate
2024-07-18 12:55:52.312 JST [459737] LOG:  GPU0 workers - 8 startup, 0 terminate

SET pg_strom.max_async_tasks だけで制御するのはデザインミス。
別途、制御用のSQL関数を用意するなど。

@kaigai kaigai added the attention to be solved with higher priority label Jul 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
attention to be solved with higher priority
Projects
None yet
Development

No branches or pull requests

1 participant