Results of 1 - 6 of about 6 for roughly (0.002 sec.)
- Working with Huge Databases 11918
- This page contains information for working with huge DuckDB database files. While most DuckDB databases are well below 1 TB, in our 2024 user survey , 1% of respondents used DuckDB files of 2 TB or more (corresponding to roughly 10 TB of CS
... - https://man.mtool.work/duckdb/2.0/guides/performance/working_with_huge_databases...
- Connect 10346
- 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
...es the number of CPU threads, capped at 256. On a 16-core machine, that is 15 worker threads plus 64 asynchronous threads, roughly 80 native threads per database instance. To bound the thread count, set both threads and async_threads when the instance i...new in DuckDB 2.0. Compared to earlier versions, it raises the default per-instance thread count on a 16-core machine from roughly 15 to roughly 80, which makes bounding the number of instances and setting threads and async_threads explicitly more impor... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Deploy as Native Image 9304
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...d libduckdb_java.so_windows_amd64 . Name the one for your target platform explicitly. A wildcard matching all of them adds roughly 260 MB to the executable. This option produces a single self contained file, around 120 MB. The driver extracts the librar... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- Variant Type 9304
- The VARIANT type stores typed, binary data where each row is self-contained with its own type information. This differs from the JSON type , which is physically stored as text. Because type metadata is embedded per-value, VARIANT provides b
...ently. Shredding is only applied to row groups with at least variant_minimum_shredding_size rows (by default, 30,000 rows, roughly one fourth of the default row group size). Setting it to -1 disables shredding: SET variant_minimum_shredding_size = -1; P... - https://man.mtool.work/duckdb/2.0/sql/data_types/variant.html
- CSV Auto Detection 7732
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works roughly
... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Spatial Functions 6160
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...irport)? SELECT st_distance_spheroid( st_point(40.6446, -73.7797), st_point(52.3130, 4.7725) ); ---- 5863418.7459356235 -- Roughly 5863km! ST_Dump Signature STRUCT(geom GEOMETRY, path INTEGER[])[] ST_Dump (geom GEOMETRY) Description Dumps a geometry int... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work