Results of 1 - 10 of about 44 for Maximum (0.004 sec.)
- Configuration 14077
- 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
...Whether strings should be produced by DuckDB in Utf8View format instead of Utf8. VARCHAR 1.0 asof_loop_join_threshold The maximum number of rows we need on the left side of an ASOF join to use a nested loop join. UBIGINT 64 async_threads The number of...e external file cache also caches local files. Remote files are always cached. BOOLEAN false catalog_error_max_schemas The maximum number of schemas in the catalog that the system will scan to generate the "did you mean..." error message. UBIGINT 100 ch...gets folded into the HTTP User-Agent string DuckDB sends on any HTTP request. VARCHAR cli dynamic_or_filter_threshold The maximum amount of OR filters that are generated dynamically from a hash join. UBIGINT 50 enable_external_access Allow the database... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- PostgreSQL Extension Functions 10773
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
..., ignore pool limit), 'wait' (block until available), 'try' (fail immediately if unavailable) max_connections ( UBIGINT ): maximum number of connections that are allowed to be cached in a connection pool for each attached Postgres database. This number...can be temporary exceeded when parallel scans are used. wait_timeout_millis ( UBIGINT ): maximum number of milliseconds to wait when acquiring a connection from a pool where all available connections are already taken....ds and are not made available to other threads, while still taking the place in the pool. max_lifetime_millis ( UBIGINT ): maximum number of milliseconds the connection can be kept open. This number is checked when the connection is taken from the pool... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- PostgreSQL Extension Connection Pool 10342
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...PostgreSQL connections. To prevent this, these parallel queries (for the same table scan) are additionally limited by the maximum number of allowed connection in the connection pool (no more than 32 by default). Even when the connection pool is configu...ce acquire mode), the addtional parallel queries are always use the try mode. If connection for them is not available (the maximum number of connection in the pool is exceeded) - then that worked thread does not participate futher in the processing of t...lable), 'try' (fail immediately if unavailable) pg_pool_max_connections ( UBIGINT , default: 4 <= cpu_count * 1.5 <= 32 ): maximum number of connections that are allowed to be cached in a connection pool for each attached Postgres database. This number... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- Loading JSON 9789
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...(auto-detected) ignore_errors Whether to ignore parse errors (only possible when format is newline_delimited ). BOOL false maximum_sample_files The maximum number of JSON files sampled for auto-detection. BIGINT 32 maximum_object_size The maximum size o...d . read_ndjson_auto(filename) Alias for read_json with parameter format set to newline_delimited . Parameters Besides the maximum_object_size , format , ignore_errors and compression , these functions have additional parameters: Name Description Type D...ill be inferred STRUCT (empty) dateformat Specifies the date format to use when parsing dates. See Date Format VARCHAR iso maximum_depth Maximum nesting depth to which the automatic schema detection detects types. Set to -1 to fully detect nested JSON t... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- Dot Commands 9451
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...manual page (signatures, descriptions and examples) for a SQL function. See the manual section .maxbytes ⟨COUNT⟩ Sets the maximum number of bytes of rows for display ( 0 = all). Only for agent mode .maxcellwidth ⟨COUNT⟩ Sets the maximum number of chara...cters per cell ( 0 = all). Only for agent mode .maxrows ⟨COUNT⟩ Sets the maximum number of rows for display (default: 40 , -1 = all). For duckbox mode and agent mode .maxwidth ⟨COUNT⟩ Sets the maximum wi...d examples of all overloads of FUNCTION. FUNCTION may be qualified: [database.][schema.]function. .maxbytes COUNT Sets the maximum number of bytes of rows for display (0 = all). Only for markdown mode in -agent mode. .maxcellwidth COUNT Sets the maximum... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Information Schema 9344
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...lable, NO if it is known not nullable. VARCHAR 'YES' data_type Data type of the column. VARCHAR 'DECIMAL(18, 2)' character_maximum_length If data_type identifies a character or bit string type, the declared maximum length; NULL for all other data types...or if no maximum length was declared. INTEGER 255 character_octet_length If data_type identifies a character type, the maximum possible len...gth in octets (bytes) of a datum; NULL for all other data types. The maximum octet length depends on the declared character maximum length (see above) and the character encoding. INTEGER 1073741824 n... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Agent Mode 9128
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...are truncated at 500 characters. These limits can be adjusted with dot commands : Dot command Description .maxrows ⟨count⟩ Maximum number of rows to render whole ( -1 for all) .maxbytes ⟨count⟩ Maximum number of bytes of rows to render whole ( 0 for all...) .maxcellwidth ⟨count⟩ Maximum number of characters per cell ( 0 for all) Tips for Agents The .help agent command prints a summary of agent mode. A few t... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Known Issues 9128
- Incorrect Memory Values on Old Linux Distributions and WSL 2 On Windows Subsystem for Linux 2 (WSL2), when querying the max_memory or memory_limit from the duckdb_settings , the values may be inaccurate on certain Ubuntu versions (e.g., 20.
...───────┼────────────┼─────────────────────────────────────────────┼────────────┼─────────┤ │ max_memory │ 1638.3 PiB │ The maximum memory of the system (e.g. 1GB) │ VARCHAR │ GLOBAL │ │ memory_limit │ 1638.3 PiB │ The maximum memory of the system (e.g.... - https://man.mtool.work/duckdb/2.0/clients/cli/known_issues.html
- Relational API 8806
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...m when it detects the column types; VARCHAR is always one of them. * max_line_size : int, str, keyword-only, default: None Maximum line size, in bytes. * ignore_errors : bool, keyword-only, default: None Skip the lines that fail to parse. * store_reject...rary table that holds information on the scans that found faulty lines. * rejects_limit : int, keyword-only, default: None Maximum number of faulty lines stored for each file; 0 means no limit. * force_not_null : list[str], keyword-only, default: None C...* sample_size : int, keyword-only, default: None Number of objects sampled to detect the types; -1 samples all of them. * maximum_depth : int, keyword-only, default: None Maximum nesting depth to which the types are detected; -1 detects all levels. * r... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Spatial Functions 8806
- 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
...interpolating vertices within a range of "M" values ST_M Returns the M coordinate of a point geometry ST_MMax Returns the maximum M coordinate of a geometry ST_MMin Returns the minimum M coordinate of a geometry ST_MakeBox2D Create a BOX2D from two POI...rs. ST_MakePolygon Create a POLYGON from a LINESTRING shell ST_MakeValid Returns a valid representation of the geometry ST_MaximumInscribedCircle Returns the maximum inscribed circle of the input geometry, optionally with a tolerance. ST_MinimumRotatedR...try \"properly\" is contained by the second geometry ST_X Returns the X coordinate of a point geometry ST_XMax Returns the maximum X coordinate of a geometry ST_XMin Returns the minimum X coordinate of a geometry ST_Y Returns the Y coordinate of a point... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
DuckDB 2.0 Documentation / man.mtool.work