Search PostgreSQL documentation

Installation from Source CodeManual ChaptersPG18Chapter 17. Installation from Source Code This chapter describes the installation of PostgreSQL using the source code distribution. If you are installing a pre-packaged distribution, such as…Installation from Source Code Installation LocationsManual ChaptersPG1817.3.3.1. Installation Locations These options control where make install will put the files. The --prefix option is sufficient for most cases. If you have special needs, you can customize t…Installation Locations Installation LocationsManual ChaptersPG1817.4.3.1. Installation Locations These options control where ninja install (or meson install) will put the files. The --prefix option (example Section 17.4.1) is sufficient for most cases. I…Installation Locations Installation on Fedora, RHEL, and DerivativesManual ChaptersPG18J.2.1. Installation on Fedora, RHEL, and Derivatives To install the required packages, use: yum install docbook-dtds docbook-style-xsl libxslt fopInstallation on Fedora, RHEL, and Derivatives Installation on FreeBSDManual ChaptersPG18J.2.2. Installation on FreeBSD To install the required packages with pkg, use: pkg install docbook-xml docbook-xsl libxslt fop When building the documentation from the doc directory you'll n…Installation on FreeBSD Installation ProcedureManual ChaptersPG1817.3.2. Installation Procedure Configuration The first step of the installation procedure is to configure the source tree for your system and choose the options you would like. This is done …Installation Procedure Installation ProcedureManual ChaptersPG1817.4.2. Installation Procedure Configuration The first step of the installation procedure is to configure the build tree for your system and choose the options you would like. To create and …Installation Procedure Installation TargetsManual ChaptersPG1817.4.4.4. Installation Targets install # Install postgres, excluding documentation install-docs # Install documentation in multi-page HTML and man page formats install-html # Install documen…Installation Targets Installing Extensions Using Update ScriptsManual ChaptersPG1836.17.5. Installing Extensions Using Update Scripts An extension that has been around for awhile will probably exist in several versions, for which the author will need to write update scrip…Installing Extensions Using Update Scripts Installing Procedural LanguagesManual ChaptersPG1840.1. Installing Procedural Languages A procedural language must be “installed” into each database where it is to be used. But procedural languages installed in the database template1 are au…Installing Procedural Languages Insufficient Stack DepthManual ChaptersPG1831.2.6. Insufficient Stack Depth If the errors test results in a server crash at the select infinite_recurse() command, it means that the platform's limit on process stack size is smaller th…Insufficient Stack Depth intFunctionsPG18int ( number ) → integer Casts to integer. int(5.4 + 3.8) → 9pgbench › Notes › Built-In Functions int4multirangeData TypesPG18int4range — Range of integer, int4multirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types int4rangeData TypesPG18int4range — Range of integer, int4multirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types int8multirangeData TypesPG18int8range — Range of bigint, int8multirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types int8rangeData TypesPG18int8range — Range of bigint, int8multirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types intaggExtensionsPG18F.18. intagg — integer aggregator and enumerator The intagg module provides an integer aggregator and an enumerator. intagg is now obsolete, because there are built-in functions that provide…intagg — integer aggregator and enumerator intagg — integer aggregator and enumeratorManual ChaptersPG18F.18. intagg — integer aggregator and enumerator The intagg module provides an integer aggregator and an enumerator. intagg is now obsolete, because there are built-in functions that provide…intagg — integer aggregator and enumerator intarrayExtensionsPG18F.19. intarray — manipulate arrays of integers The intarray module provides a number of useful functions and operators for manipulating null-free arrays of integers. There is also support fo…intarray — manipulate arrays of integers intarray Functions and OperatorsManual ChaptersPG18F.19.1. intarray Functions and Operators The functions provided by the intarray module are shown in Table F.8, the operators in Table F.9. Table F.8. intarray Functions Function Description …intarray Functions and Operators intarray — manipulate arrays of integersManual ChaptersPG18F.19. intarray — manipulate arrays of integers The intarray module provides a number of useful functions and operators for manipulating null-free arrays of integers. There is also support fo…intarray — manipulate arrays of integers integerData TypesPG18integer int, int4 signed four-byte integerData Types Integer TypesManual ChaptersPG188.1.1. Integer Types The types smallint, integer, and bigint store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the a…Integer Types integer_datetimesConfigurationReferenceinteger_datetimes Preset Options 10 Reports whether PostgreSQL was built with support for 64-bit-integer dates and times. As of PostgreSQL 10, this is always on. 11 12 13 14 15 16 17 18 19 2…Configuration · Preset Options interconnectExtensionsExtensionsOne advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database. ai big-data c cloudberry data-analysis data-warehouse databas…Analytics · Extensions Interface FunctionsManual ChaptersPG1845.1. Interface FunctionsInterface Functions Interface Support FunctionsManual ChaptersPG1845.2. Interface Support Functions The functions described here provide an interface for extracting information from result sets returned by SPI_execute and other SPI functions. All functions…Interface Support Functions Interfacing Extensions to IndexesManual ChaptersPG1836.16. Interfacing Extensions to Indexes The procedures described thus far let you define new types, new functions, and new operators. However, we cannot yet define an index on a column of a…Interfacing Extensions to Indexes Interleaving Result Processing and Query DispatchManual ChaptersPG1832.5.1.4. Interleaving Result Processing and Query Dispatch To avoid deadlocks on large pipelines the client should be structured around a non-blocking event loop using operating system faci…Interleaving Result Processing and Query Dispatch internalData TypesPG18internal Indicates that a function accepts or returns a server-internal data type.Pseudo-Types Internal FunctionsManual ChaptersPG1836.9. Internal Functions Internal functions are functions written in C that have been statically linked into the PostgreSQL server. The “body” of the function definition specifies the C-lang…Internal Functions InternalsManual ChaptersPG1834.17. Internals This section explains how ECPG works internally. This information can occasionally be useful to help users understand how to use ECPG. The first four lines written by ecpg t…Internals InternalsManual ChaptersPG18Part VII. Internals This part contains assorted information that might be of use to PostgreSQL developers.Internals Interpreting ResultsManual ChaptersPG18Interpreting Results Good results will show most (>90%) individual timing calls take less than one microsecond. Average per loop overhead will be even lower, below 100 nanoseconds. This exam…Interpreting Results INTERSECTSQL CommandsPG187.4. Combining Queries (UNION, INTERSECT, EXCEPT) # The results of two queries can be combined using the set operations union, intersection, and difference. The syntax is query1 UNION [ALL] …Combining Queries (UNION, INTERSECT, EXCEPT) INTERSECT ClauseManual ChaptersPG18INTERSECT Clause The INTERSECT clause has this general form: select_statement INTERSECT [ ALL | DISTINCT ] select_statement select_statement is any SELECT statement without an ORDER BY, LIMI…INTERSECT Clause intervalData TypesPG18interval [ fields ] [ (p) ] time spanData Types intervalManual ChaptersPG1834.4.4.2.2. interval The handling of the interval type is also similar to the timestamp and date types. It is required, however, to allocate memory for an interval type value explicitly. In …interval Interval InputManual ChaptersPG188.5.4. Interval Input interval values can be written using the following verbose syntax: [@] quantity unit [quantity unit...] [direction] where quantity is a number (possibly signed); unit i…Interval Input Interval OutputManual ChaptersPG188.5.5. Interval Output As previously explained, PostgreSQL stores interval values as months, days, and microseconds. For output, the months field is converted to years and months by dividing…Interval Output