Results of 1 - 7 of about 7 for capacity (0.004 sec.)
- R-Tree Indexes 12814
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...f the R-tree index. For example, to specify the maximum number of entries per node in the R-tree, you can use the max_node_capacity option: CREATE INDEX my_idx ON my_table USING RTREE (geom) WITH (max_node_capacity = 16); The impact tweaking these option...-tree will have to periodically rebalance itself and perform a somewhat costly splitting operation when a node reaches max capacity after an insert, potentially causing additional splits to cascade up the tree. However, when the R-tree index is created o...y_limit configuration parameter. Tuning Depending on you specific workload, you might want to experiment with the max_node_capacity and min_node_capacity options to change the structure of the R-tree and how it responds to insertions and deletions, see t... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Vectors 9851
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...ect(&con); duckdb_close(&db); API Reference Overview duckdb_vector duckdb_create_vector ( duckdb_logical_type type , idx_t capacity ); void duckdb_destroy_vector ( duckdb_vector * vector ); duckdb_logical_type duckdb_vector_get_column_type ( duckdb_vecto...ize ( duckdb_vector vector , idx_t size ); duckdb_state duckdb_list_vector_reserve ( duckdb_vector vector , idx_t required_capacity ); duckdb_vector duckdb_struct_vector_get_child ( duckdb_vector vector , idx_t index ); duckdb_vector duckdb_array_vector_...ust be destroyed with duckdb_destroy_vector . Syntax duckdb_vector duckdb_create_vector ( duckdb_logical_type type , idx_t capacity ); Parameters type : The logical type of the vector. capacity : The capacity of the vector. Return Value The vector. duckd... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- I/O 9487
- 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
...ght to saturate the network. New As of DuckDB 2.0, the size of the HTTP client pool can be tuned with the http_client_pool_capacity setting. By default the capacity is derived automatically from the number of CPU threads and asynchronous threads, bounded...that it tracks the asynchronous pool. To pin the pool to a fixed size, set a positive integer; use RESET http_client_pool_capacity to return to the automatic value. SET http_client_pool_capacity = 8; Synchronizing Writes to Disk When DuckDB persists cha... - https://man.mtool.work/duckdb/2.0/data/io.html
- Write User Defined Functions 9124
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...c.get_bind_data().count; let cursor = &func.get_init_data().cursor; // A chunk holds at most a vector's worth of rows. let capacity = output.flat_vector(0).capacity(); let start = cursor.fetch_add(capacity, Ordering::Relaxed); if start >= count { output....set_len(0); // no more rows: end the scan return Ok(()); } let rows = capacity.min(count - start); let mut v = output.flat_vector(0); let slice = unsafe { v.as_mut_slice_with_len::<i64>(rows) }; for (i... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Complete API 7706
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...db_data_chunk chunk , idx_t size ); Vector Interface duckdb_vector duckdb_create_vector ( duckdb_logical_type type , idx_t capacity ); void duckdb_destroy_vector ( duckdb_vector * vector ); duckdb_logical_type duckdb_vector_get_column_type ( duckdb_vecto...ize ( duckdb_vector vector , idx_t size ); duckdb_state duckdb_list_vector_reserve ( duckdb_vector vector , idx_t required_capacity ); duckdb_vector duckdb_struct_vector_get_child ( duckdb_vector vector , idx_t index ); duckdb_vector duckdb_array_vector_...ust be destroyed with duckdb_destroy_vector . Syntax duckdb_vector duckdb_create_vector ( duckdb_logical_type type , idx_t capacity ); Parameters type : The logical type of the vector. capacity : The capacity of the vector. Return Value The vector. duckd... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Configuration 7343
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...e listed in the reference below and documented in more detail on the I/O page , together with the related http_client_pool_capacity setting. Configuration Reference Configuration options come with different default scopes : GLOBAL and LOCAL . Below is a...4th of a row group. BIGINT 30000 home_directory Sets the home directory of the database instance. VARCHAR http_client_pool_capacity HTTP client pool capacity derived from CPU and async thread counts unless explicitly set BIGINT Derived automatically (max... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Write User Defined Functions 7215
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...function is not expected to. DuckDB calls apply repeatedly, each time passing a fresh output chunk that holds up to output.capacity() rows (2,048 by default). Fill up to that many rows, return how many you wrote, and DuckDB calls apply again for the next...info.getInitData(); long row = 0; // Fill at most one chunk; DuckDB calls apply() again for the rest. for (; row < output.capacity() && cursor.next < cursor.end; row++, cursor.next++) { for (long col = 0; col < output.columnCount(); col++) { DuckDBWrita... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work