Installed, but Not Showing Up in the Query Plan #878
ysys143
started this conversation in
Questions & Reports
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I have verified that all GUC parameters are correctly set, and the NVIDIA toolkit is functioning properly. The pg_strom.enabled parameter is set to 'ON'. However, when I execute a sample query with a JOIN, GPU acceleration is not triggered. Additionally, I do not see any PostgreSQL-related processes in nvidia-smi. Are there any possible solutions for this issue? Thank you so much!
(venv) aisjs@wdl-taichi:~$ which nvcc
/usr/local/cuda/bin/nvcc
(venv) aisjs@wdl-taichi:~$ nvcc --version
nvcc: NVIDIA (R) Cuda compiler driver
Copyright (c) 2005-2025 NVIDIA Corporation
Built on Wed_Jan_15_19:20:09_PST_2025
Cuda compilation tools, release 12.8, V12.8.61
Build cuda_12.8.r12.8/compiler.35404655_0
EXPLAIN ANALYZE
SELECT
d1.wiki_id AS cat,
COUNT(*) AS count_docs,
AVG(d2.views) AS avg_views
FROM
documents d1
JOIN documents d2 ON d1.wiki_id = d2.wiki_id
JOIN documents d3 ON d1.wiki_id = d3.wiki_id
GROUP BY d1.wiki_id;
Any solutions?
Beta Was this translation helpful? Give feedback.
All reactions