1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>Appendix L. Acronyms</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="limits.html" title="Appendix K. PostgreSQL Limits" /><link rel="next" href="glossary.html" title="Appendix M. Glossary" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">Appendix L. Acronyms</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="limits.html" title="Appendix K. PostgreSQL Limits">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="appendixes.html" title="Part VIII. Appendixes">Up</a></td><th width="60%" align="center">Part VIII. Appendixes</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="glossary.html" title="Appendix M. Glossary">Next</a></td></tr></table><hr /></div><div class="appendix" id="ACRONYMS"><div class="titlepage"><div><div><h2 class="title">Appendix L. Acronyms</h2></div></div></div><p>
3 This is a list of acronyms commonly used in the <span class="productname">PostgreSQL</span>
4 documentation and in discussions about <span class="productname">PostgreSQL</span>.
6 </p><div class="variablelist"><dl class="variablelist"><dt><span class="term"><acronym class="acronym">AIO</acronym></span></dt><dd><p>
7 <a class="link" href="glossary.html#GLOSSARY-AIO" title="Asynchronous I/O">Asynchronous <acronym class="acronym">I/O</acronym></a>
8 </p></dd><dt><span class="term"><acronym class="acronym">ACL</acronym></span></dt><dd><p>
9 <a class="ulink" href="https://en.wikipedia.org/wiki/Access-control_list" target="_top">Access Control List</a>
10 </p></dd><dt><span class="term"><acronym class="acronym">AM</acronym></span></dt><dd><p>
11 <a class="link" href="glossary.html#GLOSSARY-AM" title="Access Method">Access Method</a>
12 </p></dd><dt><span class="term"><acronym class="acronym">ANSI</acronym></span></dt><dd><p>
13 <a class="ulink" href="https://en.wikipedia.org/wiki/American_National_Standards_Institute" target="_top">
14 American National Standards Institute</a>
15 </p></dd><dt><span class="term"><acronym class="acronym">API</acronym></span></dt><dd><p>
16 <a class="ulink" href="https://en.wikipedia.org/wiki/API" target="_top">Application Programming Interface</a>
17 </p></dd><dt><span class="term"><acronym class="acronym">ASCII</acronym></span></dt><dd><p>
18 <a class="ulink" href="https://en.wikipedia.org/wiki/ASCII" target="_top">American Standard
19 Code for Information Interchange</a>
20 </p></dd><dt><span class="term"><acronym class="acronym">BKI</acronym></span></dt><dd><p>
21 <a class="link" href="bki.html" title="Chapter 68. System Catalog Declarations and Initial Contents">Backend Interface</a>
22 </p></dd><dt><span class="term"><acronym class="acronym">CA</acronym></span></dt><dd><p>
23 <a class="ulink" href="https://en.wikipedia.org/wiki/Certificate_authority" target="_top">Certificate Authority</a>
24 </p></dd><dt><span class="term"><acronym class="acronym">CIDR</acronym></span></dt><dd><p>
25 <a class="ulink" href="https://en.wikipedia.org/wiki/Classless_Inter-Domain_Routing" target="_top">Classless
26 Inter-Domain Routing</a>
27 </p></dd><dt><span class="term"><acronym class="acronym">CPAN</acronym></span></dt><dd><p>
28 <a class="ulink" href="https://www.cpan.org/" target="_top">Comprehensive Perl Archive Network</a>
29 </p></dd><dt><span class="term"><acronym class="acronym">CRL</acronym></span></dt><dd><p>
30 <a class="ulink" href="https://en.wikipedia.org/wiki/Certificate_revocation_list" target="_top">Certificate
32 </p></dd><dt><span class="term"><acronym class="acronym">CSV</acronym></span></dt><dd><p>
33 <a class="ulink" href="https://en.wikipedia.org/wiki/Comma-separated_values" target="_top">Comma
35 </p></dd><dt><span class="term"><acronym class="acronym">CTE</acronym></span></dt><dd><p>
36 <a class="link" href="queries-with.html" title="7.8. WITH Queries (Common Table Expressions)">Common Table Expression</a>
37 </p></dd><dt><span class="term"><acronym class="acronym">CVE</acronym></span></dt><dd><p>
38 <a class="ulink" href="https://cve.mitre.org/" target="_top">Common Vulnerabilities and Exposures</a>
39 </p></dd><dt><span class="term"><acronym class="acronym">DBA</acronym></span></dt><dd><p>
40 <a class="ulink" href="https://en.wikipedia.org/wiki/Database_administrator" target="_top">Database
42 </p></dd><dt><span class="term"><acronym class="acronym">DBI</acronym></span></dt><dd><p>
43 <a class="ulink" href="https://dbi.perl.org/" target="_top">Database Interface (Perl)</a>
44 </p></dd><dt><span class="term"><acronym class="acronym">DBMS</acronym></span></dt><dd><p>
45 <a class="ulink" href="https://en.wikipedia.org/wiki/Database#Database_management_system" target="_top">Database Management
47 </p></dd><dt><span class="term"><acronym class="acronym">DDL</acronym></span></dt><dd><p>
48 <a class="ulink" href="https://en.wikipedia.org/wiki/Data_definition_language" target="_top">Data
49 Definition Language</a>, SQL commands such as <code class="command">CREATE
50 TABLE</code>, <code class="command">ALTER USER</code>
51 </p></dd><dt><span class="term"><acronym class="acronym">DML</acronym></span></dt><dd><p>
52 <a class="ulink" href="https://en.wikipedia.org/wiki/Data_manipulation_language" target="_top">Data
53 Manipulation Language</a>, SQL commands such as <code class="command">INSERT</code>,
54 <code class="command">UPDATE</code>, <code class="command">DELETE</code>
55 </p></dd><dt><span class="term"><acronym class="acronym">DST</acronym></span></dt><dd><p>
56 <a class="ulink" href="https://en.wikipedia.org/wiki/Daylight_saving_time" target="_top">Daylight
58 </p></dd><dt><span class="term"><acronym class="acronym">ECPG</acronym></span></dt><dd><p>
59 <a class="link" href="ecpg.html" title="Chapter 34. ECPG — Embedded SQL in C">Embedded C for PostgreSQL</a>
60 </p></dd><dt><span class="term"><acronym class="acronym">ESQL</acronym></span></dt><dd><p>
61 <a class="ulink" href="https://en.wikipedia.org/wiki/Embedded_SQL" target="_top">Embedded
63 </p></dd><dt><span class="term"><acronym class="acronym">FAQ</acronym></span></dt><dd><p>
64 <a class="ulink" href="https://en.wikipedia.org/wiki/FAQ" target="_top">Frequently Asked
66 </p></dd><dt><span class="term"><acronym class="acronym">FSM</acronym></span></dt><dd><p>
67 <a class="link" href="storage-fsm.html" title="66.3. Free Space Map">Free Space Map</a>
68 </p></dd><dt><span class="term"><acronym class="acronym">GEQO</acronym></span></dt><dd><p>
69 <a class="link" href="geqo.html" title="Chapter 61. Genetic Query Optimizer">Genetic Query Optimizer</a>
70 </p></dd><dt><span class="term"><acronym class="acronym">GIN</acronym></span></dt><dd><p>
71 <a class="link" href="gin.html" title="65.4. GIN Indexes">Generalized Inverted Index</a>
72 </p></dd><dt><span class="term"><acronym class="acronym">GiST</acronym></span></dt><dd><p>
73 <a class="link" href="gist.html" title="65.2. GiST Indexes">Generalized Search Tree</a>
74 </p></dd><dt><span class="term"><acronym class="acronym">Git</acronym></span></dt><dd><p>
75 <a class="ulink" href="https://en.wikipedia.org/wiki/Git" target="_top">Git</a>
76 </p></dd><dt><span class="term"><acronym class="acronym">GMT</acronym></span></dt><dd><p>
77 <a class="ulink" href="https://en.wikipedia.org/wiki/Greenwich_Mean_Time" target="_top">Greenwich Mean Time</a>
78 </p></dd><dt><span class="term"><acronym class="acronym">GSSAPI</acronym></span></dt><dd><p>
79 <a class="ulink" href="https://en.wikipedia.org/wiki/Generic_Security_Services_Application_Program_Interface" target="_top">Generic
80 Security Services Application Programming Interface</a>
81 </p></dd><dt><span class="term"><acronym class="acronym">GUC</acronym></span></dt><dd><p>
82 <a class="link" href="config-setting.html" title="19.1. Setting Parameters">Grand Unified Configuration</a>,
83 the <span class="productname">PostgreSQL</span> subsystem that handles server configuration
84 </p></dd><dt><span class="term"><acronym class="acronym">HBA</acronym></span></dt><dd><p>
85 <a class="link" href="auth-pg-hba-conf.html" title="20.1. The pg_hba.conf File">Host-Based Authentication</a>
86 </p></dd><dt><span class="term"><acronym class="acronym">HOT</acronym></span></dt><dd><p>
87 <a class="link" href="storage-hot.html" title="66.7. Heap-Only Tuples (HOT)">Heap-Only Tuples</a>
88 </p></dd><dt><span class="term"><acronym class="acronym">IEC</acronym></span></dt><dd><p>
89 <a class="ulink" href="https://en.wikipedia.org/wiki/International_Electrotechnical_Commission" target="_top">International
90 Electrotechnical Commission</a>
91 </p></dd><dt><span class="term"><acronym class="acronym">IEEE</acronym></span></dt><dd><p>
92 <a class="ulink" href="https://standards.ieee.org/" target="_top">Institute of Electrical and
93 Electronics Engineers</a>
94 </p></dd><dt><span class="term"><acronym class="acronym">IPC</acronym></span></dt><dd><p>
95 <a class="ulink" href="https://en.wikipedia.org/wiki/Inter-process_communication" target="_top">Inter-Process
97 </p></dd><dt><span class="term"><acronym class="acronym">I/O</acronym></span></dt><dd><p>
98 <a class="link" href="glossary.html#GLOSSARY-IO" title="Input/Output">Input/Output</a>
99 </p></dd><dt><span class="term"><acronym class="acronym">ISO</acronym></span></dt><dd><p>
100 <a class="ulink" href="https://www.iso.org/home.html" target="_top">International Organization for
102 </p></dd><dt><span class="term"><acronym class="acronym">ISSN</acronym></span></dt><dd><p>
103 <a class="ulink" href="https://en.wikipedia.org/wiki/ISSN" target="_top">International Standard
105 </p></dd><dt><span class="term"><acronym class="acronym">JDBC</acronym></span></dt><dd><p>
106 <a class="ulink" href="https://en.wikipedia.org/wiki/Java_Database_Connectivity" target="_top">Java
107 Database Connectivity</a>
108 </p></dd><dt><span class="term"><acronym class="acronym">JIT</acronym></span></dt><dd><p>
109 <a class="ulink" href="https://en.wikipedia.org/wiki/Just-in-time_compilation" target="_top">Just-in-Time
111 </p></dd><dt><span class="term"><acronym class="acronym">JSON</acronym></span></dt><dd><p>
112 <a class="ulink" href="https://www.json.org" target="_top">JavaScript Object Notation</a>
113 </p></dd><dt><span class="term"><acronym class="acronym">LDAP</acronym></span></dt><dd><p>
114 <a class="ulink" href="https://en.wikipedia.org/wiki/Lightweight_Directory_Access_Protocol" target="_top">Lightweight
115 Directory Access Protocol</a>
116 </p></dd><dt><span class="term"><acronym class="acronym">LSN</acronym></span></dt><dd><p>
117 <a class="glossterm" href="glossary.html#GLOSSARY-LOG-SEQUENCE-NUMBER"><em class="glossterm"><a class="glossterm" href="glossary.html#GLOSSARY-LOG-SEQUENCE-NUMBER" title="Log sequence number">Log Sequence Number</a></em></a>
118 </p></dd><dt><span class="term"><acronym class="acronym">MCF</acronym></span></dt><dd><p>
119 Most Common Frequency, that is the frequency associated with some
121 </p></dd><dt><span class="term"><acronym class="acronym">MCV</acronym></span></dt><dd><p>
122 Most Common Value, one of the values appearing most often within a
123 particular table column
124 </p></dd><dt><span class="term"><acronym class="acronym">MITM</acronym></span></dt><dd><p>
125 <a class="ulink" href="https://en.wikipedia.org/wiki/Man-in-the-middle_attack" target="_top">
126 Man-in-the-middle attack</a>
127 </p></dd><dt><span class="term"><acronym class="acronym">MSVC</acronym></span></dt><dd><p>
128 <a class="ulink" href="https://en.wikipedia.org/wiki/Microsoft_Visual_C%2B%2B" target="_top"><span class="productname">Microsoft
130 </p></dd><dt><span class="term"><acronym class="acronym">MVCC</acronym></span></dt><dd><p>
131 <a class="link" href="mvcc.html" title="Chapter 13. Concurrency Control">Multi-Version Concurrency Control</a>
132 </p></dd><dt><span class="term"><acronym class="acronym">NLS</acronym></span></dt><dd><p>
133 <a class="ulink" href="https://en.wikipedia.org/wiki/Internationalization_and_localization" target="_top">National
135 </p></dd><dt><span class="term"><acronym class="acronym">ODBC</acronym></span></dt><dd><p>
136 <a class="ulink" href="https://en.wikipedia.org/wiki/Open_Database_Connectivity" target="_top">Open
137 Database Connectivity</a>
138 </p></dd><dt><span class="term"><acronym class="acronym">OID</acronym></span></dt><dd><p>
139 <a class="link" href="datatype-oid.html" title="8.19. Object Identifier Types">Object Identifier</a>
140 </p></dd><dt><span class="term"><acronym class="acronym">OLAP</acronym></span></dt><dd><p>
141 <a class="ulink" href="https://en.wikipedia.org/wiki/Online_analytical_processing" target="_top">Online Analytical
143 </p></dd><dt><span class="term"><acronym class="acronym">OLTP</acronym></span></dt><dd><p>
144 <a class="ulink" href="https://en.wikipedia.org/wiki/Online_transaction_processing" target="_top">Online Transaction
146 </p></dd><dt><span class="term"><acronym class="acronym">ORDBMS</acronym></span></dt><dd><p>
147 <a class="ulink" href="https://en.wikipedia.org/wiki/Object%E2%80%93relational_database" target="_top">Object-Relational
148 Database Management System</a>
149 </p></dd><dt><span class="term"><acronym class="acronym">PAM</acronym></span></dt><dd><p>
150 <a class="ulink" href="https://en.wikipedia.org/wiki/Pluggable_authentication_module" target="_top">Pluggable
151 Authentication Modules</a>
152 </p></dd><dt><span class="term"><acronym class="acronym">PGSQL</acronym></span></dt><dd><p>
153 <a class="link" href="index.html" title="PostgreSQL 18.0 Documentation"><span class="productname">PostgreSQL</span></a>
154 </p></dd><dt><span class="term"><acronym class="acronym">PGXS</acronym></span></dt><dd><p>
155 <a class="link" href="extend-pgxs.html" title="36.18. Extension Building Infrastructure"><span class="productname">PostgreSQL</span> Extension System</a>
156 </p></dd><dt><span class="term"><acronym class="acronym">PID</acronym></span></dt><dd><p>
157 <a class="ulink" href="https://en.wikipedia.org/wiki/Process_identifier" target="_top">Process Identifier</a>
158 </p></dd><dt><span class="term"><acronym class="acronym">PITR</acronym></span></dt><dd><p>
159 <a class="link" href="continuous-archiving.html" title="25.3. Continuous Archiving and Point-in-Time Recovery (PITR)">Point-In-Time
160 Recovery</a> (Continuous Archiving)
161 </p></dd><dt><span class="term"><acronym class="acronym">PL</acronym></span></dt><dd><p>
162 <a class="link" href="server-programming.html" title="Part V. Server Programming">Procedural Languages (server-side)</a>
163 </p></dd><dt><span class="term"><acronym class="acronym">POSIX</acronym></span></dt><dd><p>
164 <a class="ulink" href="https://en.wikipedia.org/wiki/POSIX" target="_top">Portable Operating
166 </p></dd><dt><span class="term"><acronym class="acronym">RDBMS</acronym></span></dt><dd><p>
167 <a class="ulink" href="https://en.wikipedia.org/wiki/Relational_database#RDBMS" target="_top">Relational
168 Database Management System</a>
169 </p></dd><dt><span class="term"><acronym class="acronym">RFC</acronym></span></dt><dd><p>
170 <a class="ulink" href="https://en.wikipedia.org/wiki/Request_for_Comments" target="_top">Request For
172 </p></dd><dt><span class="term"><acronym class="acronym">SGML</acronym></span></dt><dd><p>
173 <a class="ulink" href="https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language" target="_top">Standard Generalized
175 </p></dd><dt><span class="term"><acronym class="acronym">SNI</acronym></span></dt><dd><p>
176 <a class="ulink" href="https://en.wikipedia.org/wiki/Server_Name_Indication" target="_top">
177 Server Name Indication</a>,
178 <a class="ulink" href="https://datatracker.ietf.org/doc/html/rfc6066#section-3" target="_top">RFC 6066</a>
179 </p></dd><dt><span class="term"><acronym class="acronym">SPI</acronym></span></dt><dd><p>
180 <a class="link" href="spi.html" title="Chapter 45. Server Programming Interface">Server Programming Interface</a>
181 </p></dd><dt><span class="term"><acronym class="acronym">SP-GiST</acronym></span></dt><dd><p>
182 <a class="link" href="spgist.html" title="65.3. SP-GiST Indexes">Space-Partitioned Generalized Search Tree</a>
183 </p></dd><dt><span class="term"><acronym class="acronym">SQL</acronym></span></dt><dd><p>
184 <a class="ulink" href="https://en.wikipedia.org/wiki/SQL" target="_top">Structured Query Language</a>
185 </p></dd><dt><span class="term"><acronym class="acronym">SRF</acronym></span></dt><dd><p>
186 <a class="link" href="xfunc-c.html#XFUNC-C-RETURN-SET" title="36.10.9. Returning Sets">Set-Returning Function</a>
187 </p></dd><dt><span class="term"><acronym class="acronym">SSH</acronym></span></dt><dd><p>
188 <a class="ulink" href="https://en.wikipedia.org/wiki/Secure_Shell" target="_top">Secure
190 </p></dd><dt><span class="term"><acronym class="acronym">SSL</acronym></span></dt><dd><p>
191 <a class="ulink" href="https://en.wikipedia.org/wiki/Transport_Layer_Security#SSL_1.0,_2.0,_and_3.0" target="_top">Secure Sockets Layer</a>
192 </p></dd><dt><span class="term"><acronym class="acronym">SSPI</acronym></span></dt><dd><p>
193 <a class="ulink" href="https://msdn.microsoft.com/en-us/library/aa380493%28VS.85%29.aspx" target="_top">Security
194 Support Provider Interface</a>
195 </p></dd><dt><span class="term"><acronym class="acronym">SYSV</acronym></span></dt><dd><p>
196 <a class="ulink" href="https://en.wikipedia.org/wiki/UNIX_System_V" target="_top">Unix System V</a>
197 </p></dd><dt><span class="term"><acronym class="acronym">TCP/IP</acronym></span></dt><dd><p>
198 <a class="ulink" href="https://en.wikipedia.org/wiki/Transmission_Control_Protocol" target="_top">Transmission
199 Control Protocol (TCP) / Internet Protocol (IP)</a>
200 </p></dd><dt><span class="term"><acronym class="acronym">TID</acronym></span></dt><dd><p>
201 <a class="link" href="datatype-oid.html" title="8.19. Object Identifier Types">Tuple Identifier</a>
202 </p></dd><dt><span class="term"><acronym class="acronym">TLS</acronym></span></dt><dd><p>
203 <a class="ulink" href="https://en.wikipedia.org/wiki/Transport_Layer_Security" target="_top">
204 Transport Layer Security</a>
205 </p></dd><dt><span class="term"><acronym class="acronym">TOAST</acronym></span></dt><dd><p>
206 <a class="link" href="storage-toast.html" title="66.2. TOAST">The Oversized-Attribute Storage Technique</a>
207 </p></dd><dt><span class="term"><acronym class="acronym">TPC</acronym></span></dt><dd><p>
208 <a class="ulink" href="http://www.tpc.org/" target="_top">Transaction Processing
209 Performance Council</a>
210 </p></dd><dt><span class="term"><acronym class="acronym">URL</acronym></span></dt><dd><p>
211 <a class="ulink" href="https://en.wikipedia.org/wiki/URL" target="_top">Uniform Resource
213 </p></dd><dt><span class="term"><acronym class="acronym">UTC</acronym></span></dt><dd><p>
214 <a class="ulink" href="https://en.wikipedia.org/wiki/Coordinated_Universal_Time" target="_top">Coordinated
216 </p></dd><dt><span class="term"><acronym class="acronym">UTF</acronym></span></dt><dd><p>
217 <a class="ulink" href="https://www.unicode.org/" target="_top">Unicode Transformation
219 </p></dd><dt><span class="term"><acronym class="acronym">UTF8</acronym></span></dt><dd><p>
220 <a class="ulink" href="https://en.wikipedia.org/wiki/UTF-8" target="_top">Eight-Bit Unicode
221 Transformation Format</a>
222 </p></dd><dt><span class="term"><acronym class="acronym">UUID</acronym></span></dt><dd><p>
223 <a class="link" href="datatype-uuid.html" title="8.12. UUID Type">Universally Unique Identifier</a>
224 </p></dd><dt><span class="term"><acronym class="acronym">WAL</acronym></span></dt><dd><p>
225 <a class="link" href="wal.html" title="Chapter 28. Reliability and the Write-Ahead Log">Write-Ahead Log</a>
226 </p></dd><dt><span class="term"><acronym class="acronym">XID</acronym></span></dt><dd><p>
227 <a class="link" href="datatype-oid.html" title="8.19. Object Identifier Types">Transaction Identifier</a>
228 </p></dd><dt><span class="term"><acronym class="acronym">XML</acronym></span></dt><dd><p>
229 <a class="ulink" href="https://en.wikipedia.org/wiki/XML" target="_top">Extensible Markup
231 </p></dd></dl></div><p>
232 </p></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="limits.html" title="Appendix K. PostgreSQL Limits">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="appendixes.html" title="Part VIII. Appendixes">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="glossary.html" title="Appendix M. Glossary">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Appendix K. <span class="productname">PostgreSQL</span> Limits </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="40%" align="right" valign="top"> Appendix M. Glossary</td></tr></table></div></body></html>