Comments (4)
@soerenwolfers thanks for this issue. On Linux (running in Docker), I get this:
duckdb(n=200000, sorted=False) took 1.31s and used 0.0441GiB
where size of join was: 8.02e+07rows (~2.39GiB)
duckdb(n=205000, sorted=False) took 2.09s and used 2.89GiB
where size of join was: 8.42e+07rows (~2.51GiB)
duckdb(n=200000, sorted=True) took 0.714s and used 0.00505GiB
where size of join was: 8.02e+07rows (~2.39GiB)
duckdb(n=205000, sorted=True) took 0.672s and used 0.00216GiB
where size of join was: 8.42e+07rows (~2.51GiB)
On MacOS (M2 Pro), I get:
duckdb(n=200000, sorted=False) took 1.28s and used 0.00197GiB
where size of join was: 8.02e+07rows (~2.39GiB)
duckdb(n=205000, sorted=False) took 1.61s and used 0.0136GiB
where size of join was: 8.42e+07rows (~2.51GiB)
duckdb(n=200000, sorted=True) took 0.653s and used 0.00102GiB
where size of join was: 8.02e+07rows (~2.39GiB)
duckdb(n=205000, sorted=True) took 0.626s and used 0.00639GiB
where size of join was: 8.42e+07rows (~2.51GiB)
So this likely has something to do with the different allocators used. Are you running on AMD64 or arm64?
from duckdb.
AMD64, specifically:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 140
model name : 11th Gen Intel(R) Core(TM) i5-1135G7 @ 2.40GHz
stepping : 1
microcode : 0xb4
cpu MHz : 2400.000
cache size : 8192 KB
physical id : 0
siblings : 8
core id : 0
cpu cores : 4
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 27
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc art arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf tsc_known_freq pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch cpuid_fault epb cat_l2 invpcid_single cdp_l2 ssbd ibrs ibpb stibp ibrs_enhanced tpr_shadow vnmi flexpriority ept vpid ept_ad fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdt_a avx512f avx512dq rdseed adx smap avx512ifma clflushopt clwb intel_pt avx512cd sha_ni avx512bw avx512vl xsaveopt xsavec xgetbv1 xsaves split_lock_detect dtherm ida arat pln pts hwp hwp_notify hwp_act_window hwp_epp hwp_pkg_req avx512vbmi umip pku ospke avx512_vbmi2 gfni vaes vpclmulqdq avx512_vnni avx512_bitalg avx512_vpopcntdq rdpid movdiri movdir64b fsrm avx512_vp2intersect md_clear flush_l1d arch_capabilities
vmx flags : vnmi preemption_timer posted_intr invvpid ept_x_only ept_ad ept_1gb flexpriority apicv tsc_offset vtpr mtf vapic ept vpid unrestricted_guest vapic_reg vid ple pml ept_mode_based_exec tsc_scaling
bugs : spectre_v1 spectre_v2 spec_store_bypass swapgs eibrs_pbrsb gds
bogomips : 4838.40
clflush size : 64
cache_alignment : 64
address sizes : 39 bits physical, 48 bits virtual
power management:
from duckdb.
Thanks!
from duckdb.
On 1.0.0, the memory usage is >1GB for all n (even for smaller n than the ones used in the repro in the OP). I can now run slightly higher n
(400_000 works, but 500_000 runs OOM) but not enough to not consider this a bug anymore IMO.
duckdb(n=200000, sorted=False) took 3.95s and used 2.51GiB
where size of join was: 8.02e+07rrows (~2.39GiB)
duckdb(n=205000, sorted=False) took 4.53s and used 1.17GiB
where size of join was: 8.42e+07rrows (~2.51GiB)
duckdb(n=400000, sorted=False) took 12.1s and used 9.02GiB
where size of join was: 3.2e+08rrows (~9.55GiB)
from duckdb.
Related Issues (20)
- Python UDFs marked as side_effects = False are not having results cached/deduplicated when called from SELECT HOT 6
- DuckDB returns different results on different OS HOT 5
- CSV Buffer not available to reconstruct CSV Line HOT 2
- Attemped it dereference unique_ptr that is null HOT 1
- Incorrect correlation aggregate computation for constant X HOT 3
- Namespace resolution for VIEW does not work for views from ATTACH-ed database HOT 1
- Structured errors and exceptions HOT 2
- Unexpected result after creating index on varchar column HOT 1
- CSV import swallows some lines for large CSVs. HOT 2
- InvalidInputException: Attempting to execute an unsuccessful or closed pending query result HOT 2
- normalize_names does not work properly with `/dev/stdin` HOT 8
- Top-N is much slower than Sort operator
- TransactionContext Error: Failed to commit: DistinctStats called without distinct_stats HOT 1
- Python's `con.table` can deadlock if it triggers other calls to `con` mid-call HOT 5
- "Table with name [...] does not exist" when reading file that exists HOT 4
- Misleading error message when importing JSON with upper/lowercased keys HOT 1
- Unable to download duckdb extension using Github Action HOT 5
- Internal error with unnest and cross join
- Unexpected result when using `IN` with `TIME` values HOT 6
- [Test] C-API Populate ListVector test issue
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 duckdb.