Results of 1 - 7 of about 7 for blocking (0.001 sec.)
- Tuning Workloads 12759
- DuckDB aims to perform well out of the box, so most workloads do not require any tuning. When tuning is worthwhile, there is no single configuration or magic number that is optimal for every workload: the right settings depend on what you a
...ectory can be changed using the temp_directory configuration option , e.g.: SET temp_directory = '/path/to/temp_dir.tmp/'; Blocking Operators Some operators cannot output a single row until the last row of their input has been seen. These are called bloc...re their entire input to be buffered, and are the most memory-intensive operators in relational database systems. The main blocking operators are the following: grouping: GROUP BY joining: JOIN sorting: ORDER BY windowing: OVER ... (PARTITION BY ... ORDE...s complete workloads even if they are larger-than-memory. That said, there are some limitations at the moment: If multiple blocking operators appear in the same query, DuckDB may still throw an out-of-memory exception due to the complex interplay of thes... - https://man.mtool.work/duckdb/2.0/guides/performance/how_to_tune_workloads.html
- I/O 10087
- Warning DuckDB ships with safe defaults. The configuration options described on this page are advanced options, so proceed with caution when changing them. Asynchronous I/O New Asynchronous I/O was introduced in DuckDB 2.0. Starting with v2
....0, DuckDB supports asynchronous I/O. Instead of blocking a worker thread until requested data arrives, DuckDB issues reads in the background and keeps multiple requests in flight...prioritize query processing but can also perform I/O tasks when idle. The asynchronous pool contains threads dedicated to blocking I/O. As these threads spend most of their time waiting for responses (e.g., HTTP requests), there are more of them than CP... - https://man.mtool.work/duckdb/2.0/data/io.html
- Out of Memory Errors 9415
- DuckDB has a state of the art out-of-core query engine that can spill to disk for larger-than-memory processing. We continuously strive to improve DuckDB's scalability and prevent out of memory errors whenever possible. That said, you may s
...till experience out-of-memory errors if you run queries with multiple blocking operators , certain aggregate functions (such as string_agg() or aggregates with an ORDER BY clause ), or if you have very... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/oom_errors.html
- Quack on WebAssembly 8742
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...ast-1.amazonaws.com/quack.yaml \ --region us-east-2 Wait approx. 2 minutes for the deployment to complete (this command is blocking): aws cloudformation wait stack-create-complete \ --stack-name my-quack-demo \ --region us-east-2 Consult the auto-generat... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- C++ API 8070
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...etion and returns a QueryResult that retains the result in memory, so it can be read repeatedly. To submit a query without blocking, use Submit() . // create a table con.Query("CREATE TABLE integers (i INTEGER, j INTEGER)"); // insert three rows into the... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Connect 7742
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...pool is independent of the JVM's threads: a single Statement.executeQuery() call can occupy every thread in the pool, and blocking JDBC calls from many application threads do not increase DuckDB's parallelism. The pool belongs to the database instance ,...ads - external_threads background threads. In addition, DuckDB 2.0 runs a second pool of asynchronous threads dedicated to blocking I/O, such as HTTP requests to object storage (see Asynchronous I/O ). Its size is set by the async_threads option, which d... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Window Functions 6725
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work