Search PostgreSQL documentation

CopyFileCopyWait EventsReferenceCopyFileCopy IO 18 Waiting for a file copy operation. 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion operation at the obs…Wait Events · IO CopyFileReadWait EventsReferenceCopyFileRead IO 10 Waiting for a read during a file copy operation. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocati…Wait Events · IO CopyFileWriteWait EventsReferenceCopyFileWrite IO 10 Waiting for a write during a file copy operation. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, alloca…Wait Events · IO CopyFromReadWait EventsReferenceCopyFromRead IO 19 Waiting to read data from a pipe, a file or a program during COPY FROM. 20Wait Events · IO Copying CollationsManual ChaptersPG1823.2.2.3.3. Copying Collations The command CREATE COLLATION can also be used to create a new collation from an existing collation, which can be useful to be able to use operating-system-inde…Copying Collations Copying TypesManual ChaptersPG1841.3.3. Copying Types name table.column%TYPE name variable%TYPE %TYPE provides the data type of a table column or a previously-declared PL/pgSQL variable. You can use this to declare variabl…Copying Types CopyToWriteWait EventsReferenceCopyToWrite IO 19 Waiting to write data to a pipe, a file or a program during COPY TO. 20Wait Events · IO corrFunctionsReferencecorr Aggregate Functions 10 correlation coefficient corr ( Y, X ) → double precision correlation coefficient 11 12 13 Computes the correlation coefficient. corr ( Y double precision, X doubl…Functions · Aggregate Functions cosFunctionsReferencecos Mathematical Functions And Operators 10 cosine cos ( x ) cosine 11 12 13 Cosine, argument in radians cos ( double precision ) → double precision Cosine, argument in radians 14 15 16 17 1…Functions · Mathematical Functions And Operators cos_fdwExtensionsExtensionsTencentDB PostgreSQL foreign data wrapper for reading CSV data from Tencent Cloud Object Storage (COS). cos fdw object-storage tiered-storage cos_fdw Foreign data wrappersForeign data wrappers · Extensions cosdFunctionsReferencecosd Mathematical Functions And Operators 10 cosine cosd ( x ) cosine 11 12 13 Cosine, argument in degrees cosd ( double precision ) → double precision Cosine, argument in degrees 14 15 16 1…Functions · Mathematical Functions And Operators coshFunctionsReferencecosh Mathematical Functions And Operators 12 hyperbolic cosine cosh ( x ) hyperbolic cosine 13 Hyperbolic cosine cosh ( double precision ) → double precision Hyperbolic cosine 14 15 16 17 18…Functions · Mathematical Functions And Operators Cost Estimation OptionsManual ChaptersPG18F.38.1.3. Cost Estimation Options postgres_fdw retrieves remote data by executing queries against remote servers, so ideally the estimated cost of scanning a foreign table should be whatever…Cost Estimation Options Cost-based Vacuum DelayManual ChaptersPG1819.10.2. Cost-based Vacuum Delay During the execution of VACUUM and ANALYZE commands, the system maintains an internal counter that keeps track of the estimated cost of the various I/O opera…Cost-based Vacuum Delay cost_guardExtensionsExtensionsPlanner-hook guard that rejects statements whose estimated cost exceeds a configured threshold. planner cost guard resource-control cost_guard AdministrationAdministration · Extensions cotFunctionsReferencecot Mathematical Functions And Operators 10 cotangent cot ( x ) cotangent 11 12 13 Cotangent, argument in radians cot ( double precision ) → double precision Cotangent, argument in radians 1…Functions · Mathematical Functions And Operators cotdFunctionsReferencecotd Mathematical Functions And Operators 10 cotangent cotd ( x ) cotangent 11 12 13 Cotangent, argument in degrees cotd ( double precision ) → double precision Cotangent, argument in degree…Functions · Mathematical Functions And Operators couchdb_fdwExtensionsExtensionsForeign data wrapper for querying CouchDB from PostgreSQL. couchdb fdw json sql-med couchdb_fdw Foreign data wrappersForeign data wrappers · Extensions countFunctionsReferencecount Aggregate Functions 10 number of input rows count ( * ) → bigint number of input rows count ( expression ) → bigint number of input rows for which the value of expression is not null 1…Functions · Aggregate Functions count_charExtensionsExtensionsaggregates and functions for PostgreSQL Server aggregates c custom-aggregates extension functions postgresql postgresql-extension count_char Functions and aggregatesFunctions and aggregates · Extensions count_distinctExtensionsExtensionsAn alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate pgdg-flaw count_distinct Functions and aggregatesFunctions and aggregates · Extensions count_nullsExtensionsExtensionsCount the number of null arguments count nulls null count nulls count_nulls Functions and aggregatesFunctions and aggregates · Extensions countnullsExtensionsExtensionsSimple function to count the number of NULL arguments countnulls Functions and aggregatesFunctions and aggregates · Extensions countriesExtensionsExtensionsPure-SQL package that creates and seeds a public.countries reference table. countries reference-data countries FeaturesFeatures · Extensions countryExtensionsExtensionsCountry data type, ISO 3166-1 pg_country Data typesData types · Extensions covar_popFunctionsReferencecovar_pop Aggregate Functions 10 population covariance covar_pop ( Y, X ) → double precision population covariance 11 12 13 Computes the population covariance. covar_pop ( Y double precision…Functions · Aggregate Functions covar_sampFunctionsReferencecovar_samp Aggregate Functions 10 sample covariance covar_samp ( Y, X ) → double precision sample covariance 11 12 13 Computes the sample covariance. covar_samp ( Y double precision, X doubl…Functions · Aggregate Functions Coverage with Autoconf and MakeManual ChaptersPG1831.5.1. Coverage with Autoconf and Make A typical workflow looks like this: ./configure --enable-coverage ... OTHER OPTIONS ... make make check # or other test suite make coverage-html Then …Coverage with Autoconf and Make Coverage with MesonManual ChaptersPG1831.5.2. Coverage with Meson A typical workflow looks like this: meson setup -Db_coverage=true ... OTHER OPTIONS ... builddir/ meson compile -C builddir/ meson test -C builddir/ cd builddir/ …Coverage with Meson cpgExtensionsExtensionsDépôt relatif aux journées de hacking sur PostgreSQL cpg FeaturesFeatures · Extensions cpu_index_tuple_costConfigurationReferencecpu_index_tuple_cost Query Tuning 10 Sets the planner's estimate of the cost of processing each index entry during an index scan. The default is 0.005. 11 12 13 14 15 16 17 18 19 20 9.0 9.1 …Configuration · Query Tuning cpu_operator_costConfigurationReferencecpu_operator_cost Query Tuning 10 Sets the planner's estimate of the cost of processing each operator or function executed during a query. The default is 0.0025. 11 12 13 14 15 16 17 18 19 2…Configuration · Query Tuning cpu_tuple_costConfigurationReferencecpu_tuple_cost Query Tuning 10 Sets the planner's estimate of the cost of processing each row during a query. The default is 0.01. 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3 9.4 9.5 9.6 c…Configuration · Query Tuning crangesExtensionsExtensionsClosed forms of PostgreSQL discrete built-in ranges closed-range date-range integer-range cranges Data typesData types · Extensions crankshaftExtensionsExtensionsArchived CARTO spatial-analysis functions for clustering, segmentation, and spatial statistics. spatial-analysis clustering segmentation cartodb crankshaft GeospatialGeospatial · Extensions crc32FunctionsReferencecrc32 Binary String Functions And Operators 18 Computes the CRC-32 value of the binary string. crc32 ( bytea ) → bigint Computes the CRC-32 value of the binary string. 19 20Functions · Binary String Functions And Operators crc32cFunctionsReferencecrc32c Binary String Functions And Operators 18 Computes the CRC-32C value of the binary string. crc32c ( bytea ) → bigint Computes the CRC-32C value of the binary string. 19 20Functions · Binary String Functions And Operators crdv_pg_coordinatorExtensionsExtensionsSecure Conflict-free Replicated Data Views with MPC-backed private values. crdv_pg_coordinator SecuritySecurity · Extensions CREATE ACCESS METHODManual ChaptersPG18CREATE ACCESS METHOD CREATE ACCESS METHOD — define a new access method Synopsis CREATE ACCESS METHOD name TYPE access_method_type HANDLER handler_functionCREATE ACCESS METHOD CREATE ACCESS METHODSQL CommandsReferenceCREATE ACCESS METHOD Extensions & Access Methods 10 define a new access method CREATE ACCESS METHOD name TYPE access_method_type HANDLER handler_function CREATE ACCESS METHOD creates a new a…SQL Commands · Extensions & Access Methods