Comments (3)
bd172cd964557176b49f849b55350d250a9bdb9c
にて修正しています。
ただし、これは長大可変長データを触ろうとしたために CPU Fallback が発生し、
その CPU Fallback の実装に問題があったためのエラーです。
#641も同じく CPU Fallback 関連のもので、こちらは GpuPreAgg が起点になっているので
少し異なります。明日、その辺は修正します。
from pg-strom.
最新版で、当クエリのエラーが発生しなくなったことを確認しました。
CPU fallbackが起きたことがNOTICEメッセージで分かるのが良いですね。
sakaitest_nvme5=# SELECT geom, COUNT(*)
FROM japan_cities
WHERE geom IS NOT NULL
GROUP BY geom
LIMIT 10;
NOTICE: (xpu_postgis.cu:397) CPU fallback due to geometry datum is compressed or external [xpu_geometry_datum_ref]
geom | count
------------------------------------+---------
(snip)
(10 rows)
確認バージョン:
sakaitest_nvme5=# SELECT pgstrom.githash();
githash
------------------------------------------
bd172cd964557176b49f849b55350d250a9bdb9c
from pg-strom.
SET pg_strom.cpu_fallback = on;
でNOTICEは抑止できます。
SET pg_strom.cpu_fallback = off;
ならエラーで止めます。
という感じですね。基本的には、CPU Fallbackが発生するのはあまり良い状況ではないのですが…。
from pg-strom.
Related Issues (20)
- [Error Bug] SELECT MIN(<column>) FROM table GROUP BY <column> HAVING CAST((MIN('1')) AS BOOLEAN) Brings Errors HOT 2
- [Error Bug] SELECT MAX(<column>) FROM table GROUP BY <column> HAVING <column> < MIN(<column>) Brings Errors HOT 4
- [GPU Error Bug] SELECT <column> FROM table GROUP BY <column> HAVING NOT (MIN(integer > 65535 ))::BOOLEAN Brings GPU Errors HOT 2
- [GPU Logic Bug] SELECT MIN(1) FROM table GROUP BY <column> HAVING NOT (MIN(1))::BOOLEAN Brings Errors HOT 2
- [GPU Logic Bug] A Sepcial SQL Brings Errors ( SELECT MIN(<column>) FROM table LEFT OUTER JOIN (SELECT <column> FROM table) AS sub0 ON (<column> > 0) GROUP BY (<column>) HAVING TRUE; ) HOT 2
- (VTJ-JP)Error occured at checking null in geom column HOT 4
- [GPU ERROR Bug] A Sepcial SQL Brings GPU Errors ( SELECT (length(<column>) IN (<decimal>, <decimal>))::INT FROM <table> CROSS JOIN <table> WHERE length(<column>) IN (<column>) ) HOT 1
- [ERROR Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> LEFT OUTER JOIN <table> ON FALSE CROSS JOIN (SELECT * FROM <table> WHERE TRUE ORDER BY <column> ASC, <column> DESC) AS sub ) HOT 1
- [ERROR Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> RIGHT OUTER JOIN <table> ON (<column>::INT) IS NULL ) HOT 1
- [ERROR Bug] A Sepcial SQL Brings Errors ( SELECT ((<column> BETWEEN SYMMETRIC <integer> AND <integer>)OR((<decimal>::MONEY) IN (CAST(<decimal> AS MONEY), CAST(<decimal> AS MONEY)))) FROM <table> WHERE (<column>) BETWEEN SYMMETRIC (<integer>) AND (<column>) ) HOT 2
- [GPU ERROR Bug] A Sepcial SQL Brings Errors ( SELECT ('<interval>'::int4range), <column>::INT FROM <table> WHERE (<column>!=<column>) ) HOT 2
- [GPU Logic Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> WHERE (<column> IS NOT DISTINCT FROM <column>) IS TRUE ) HOT 2
- [GPU Logic Bug] A Sepcial SQL Brings Errors ( SELECT <column> FROM <table> WHERE <column> BETWEEN SYMMETRIC <column> AND (<decimal>::MONEY) ) HOT 4
- [Logic Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> WHERE <column> BETWEEN <column> AND (CAST(<decimal> AS MONEY)) ) HOT 1
- [Logic Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> WHERE ( (<column> is null )::INT IS NOT DISTINCT FROM <column>) OR <column> ) HOT 1
- Compile ERROR HOT 7
- (VTJ-JP) heterodb-extra 5.xで旧製品のライセンスが無効化されてGDSが利用できなくなる HOT 6
- (VTJ-JP) PG-Strom 5.x + PostgreSQL 16 Not working
- (VTJ-JP)Crash on select count, max, min, sum HOT 15
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.