Comments (1)
It is not a bug but by design.
DISTINCT ON
clause generates unique results for the specified columns or expressions, however, here is no guarantee on the unspecified fields.
GpuJoin generates the results in different order from the CPU execution, thus Unique
node put different values on the unspecified fields.
=# SET pg_strom.enabled=on;
EXPLAIN SELECT DISTINCT ON (((t2.c0)<=(t1.c0))) t3.c0, t2.c0<=t1.c0 FROM ONLY t2, ONLY t1, ONLY t3 WHERE ((((0.3)>(t2.c0)))OR((t3.c0) BETWEEN (0.6) AND (t2.c0)));
SET
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------
Unique (cost=195449501.36..200573580.16 rows=2 width=33)
-> Sort (cost=195449501.36..198011540.76 rows=1024815760 width=33)
Sort Key: ((t2.c0 <= t1.c0))
-> Custom Scan (GpuJoin) on t3 (cost=60262.60..14049589.60 rows=1024815760 width=33)
GPU Projection: t3.c0, (t2.c0 <= t1.c0)
GPU Join Quals [1]: ((0.3 > t2.c0) OR ((t3.c0 >= 0.6) AND (t3.c0 <= t2.c0))) ... [nrows: 1360 -> 1024816000]
GPU-Direct SQL: enabled (GPU-0)
-> Nested Loop (cost=0.00..23170.60 rows=1849600 width=64)
-> Seq Scan on t1 (cost=0.00..23.60 rows=1360 width=32)
-> Materialize (cost=0.00..30.40 rows=1360 width=32)
-> Seq Scan on t2 (cost=0.00..23.60 rows=1360 width=32)
(11 rows)
from pg-strom.
Related Issues (20)
- GPU-aware pinned-inner-buffer HOT 1
- [JP] nvidia-gdsもバージョンを指定するべき HOT 2
- PG17beta2でインストールエラー HOT 1
- PG17beta2: CREATE EXTENSION pg_strom;でエラー HOT 2
- [idea] SUM(numeric) での浮動小数点誤差
- [VTJ-JP]CUDAバージョンに関する説明 HOT 3
- pg2arrowのdecimal型変換がめっちゃ重い HOT 1
- [JP][docs-issue]RHEL8における設定に翻訳漏れとコマンド記述ミスがある
- [JP][docs-issue] GPUキャッシュドキュメントにPostgreSQL 15以前のバージョン固有の情報がある
- Too much GPU workers startup/terminate if pg_strom.max_async_tasks in postgresql.conf
- [VTJ-JP]Crashed in cpu fallback process(?)(in using ST_Crosses function)
- SELECT DISTINCTの行推定
- PG17: SELECT distinct のEXPLAINのnrowsが実行のたびに変動する
- [VTJ-JP]Fluentdプラグインがビルドできない
- [VTJ-JP]td-agent 4の最終リリース(4.5.2)でFluentdプラグインがインストールできない
- failed on pthread_create by EAGAIN HOT 1
- Over-usage of stack frame in recursive calls HOT 2
- PG17:fallback発生時(?)LIKE条件の絞り込み結果が異なる。 HOT 1
- [VTJ-JP]Subquery does not return correct results.
- [Question] Does PG-Strom work on Ubuntu HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg-strom.