Search Result: tweaking - DuckDB 2.0 全文検索

Out-of-Memory Issues 11228: Configuration Options If you are experiencing out-of-memory issues with DuckDB, try tweaking the following configuration options: Reduce the number of threads using the SET threads = ... command. Setting the memory limit lower than the defa ...; https://man.mtool.work/duckdb/2.0/guides/performance/oom.html

R-Tree Indexes 7485: 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 ... the max_node_capacity option: CREATE INDEX my_idx ON my_table USING RTREE (geom) WITH (max_node_capacity = 16); The impact tweaking these options will have on performance is highly dependent on the system setup DuckDB is running on, the spatial distribut ...; https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work