Results of 1 - 10 of about 15 for checked (0.002 sec.)
- PostgreSQL Extension Connection Pool 14664
- 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
.... When the reaper thread is not running, idle_timeout_millis or max_lifetime_millis values of the connections still can be checked, but they are only checked when a connection is taken from the pool or returned to the pool. Thread-local Cache Idle conne...l (and thread-private) cache instead of the main cache shared between all threads. Warning Thread-local connection are not checked and not cleaned up by the reaper thread. Thread-local cache should be used with caution as cached connections, while not a...illis ( UBIGINT , default: 0 not enforced): maximum number of milliseconds the connection can be kept open. This number is checked when the connection is taken from the pool and returned to the pool. When the connection pool reaper thread is enabled ( p... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- PostgreSQL Extension Functions 10606
- 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
...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 and returned to the pool. When the connection pool reaper thread is enabled ( e...nable_reaper_thread argument), then this number is checked in background periodically. idle_timeout_millis ( UBIGINT ): maximum number of milliseconds the connection can be kept idl...e in the pool. This number is checked when the connection is taken from the pool. When the connection pool reaper thread is enabled ( enable_reaper_thread optio... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Vectors 8673
- 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
...f all values in a vector are valid, this function might return nullptr in which case the validity mask does not need to be checked. Strings String values are stored as a duckdb_string_t . This is a special struct that stores the string inline (if it is...duckdb_list_entry; Note that both list entries itself and any children stored in the lists can also be NULL . This must be checked using the validity mask again. Arrays Arrays are nested types that contain a single child type, repeated exactly array_siz...= n * array_size and always has length = array_size . Note that much like lists, arrays can still be NULL , which must be checked using the validity mask. Examples Below are several full end-to-end examples of how to interact with vectors. Example: Rea... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Catch C/C++ Tests 8673
- While we prefer the sqllogic tests for testing most functionality, for certain tests only SQL is not sufficient. This typically happens when you want to test the C++ API. When using pure SQL is really not an option it might be necessary to
...he test uses the TEST_CASE wrapper to create each test. The database is created and queried using the C++ API. Results are checked using either REQUIRE_FAIL / REQUIRE_NO_FAIL (corresponding to statement ok and statement error) or REQUIRE(CHECK_COLUMN(..... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/catch.html
- Profile and Monitor 8342
- Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information
...is connection-local, so it is read from a *sql.Conn checked out with db.Conn() . Enable profiling on that connection with the enable_profiling setting , run the query to profile, the... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- Connect 8185
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...outines: it manages its own pool of connections and hands each in-flight query a connection of its own. A single *sql.Conn checked out with db.Conn() , and the DuckDB Appender and Arrow handles built on one, are not safe for concurrent use. DuckDB runs... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Appender 8185
- The Appender can be used to load bulk data into a DuckDB database. It is available in the C, C++, Go, Java, Julia, Node.js, Python, and Rust clients. This page describes how the Appender behaves across clients and shows a minimal example in
...iscards any remaining buffered rows. See the Python Appender . Constraints such as NOT NULL , PRIMARY KEY , and UNIQUE are checked when the cache is flushed rather than as each row is added, so a row can be accepted but later fail at flush time. See Han... - https://man.mtool.work/duckdb/2.0/data/appender.html
- Building Configuration 8185
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...ebug symbols that make it possible to step through the execution with line number information and D_ASSERT lines are still checked in this build. Binaries of this build mode are significantly faster than those of the debug mode. reldebug This build is s... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Securing Extensions 8185
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...and setting them according to your attack models. DuckDB Signature Checks DuckDB extensions are checked on every load using the signature of the binaries. There are currently three categories of extensions: Signed with a core... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- Write User Defined Functions 8011
- Overview The Go client can register user-defined functions written in Go: scalar functions that map input rows to a single output value, and table functions that produce a set of rows. It can also register a replacement scan that rewrites a
...n unresolved table name into a query. Scalar and table functions are registered on a connection checked out with db.Conn() , while a replacement scan is registered on a Connector ; in each case the function is then callable fr... - https://man.mtool.work/duckdb/2.0/clients/go/functions.html
DuckDB 2.0 Documentation / man.mtool.work