]> begriffs open source - ai-pg/blob - full-docs/src/sgml/html/acronyms.html
PG 18 docs from https://ftp.postgresql.org/pub/source/v18.0/postgresql-18.0-docs...
[ai-pg] / full-docs / src / sgml / html / acronyms.html
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>.
5
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
31       Revocation List</a>
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
34       Separated Values</a>
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
41       Administrator</a>
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
46       System</a>
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
57       Saving Time</a>
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
62       SQL</a>
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
65       Questions</a>
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
96       Communication</a>
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
101       Standardization</a>
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
104       Serial Number</a>
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
110       compilation</a>
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
120       Most Common Value
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
129       Visual C</span></a>
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
134       Language Support</a>
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
142       Processing</a>
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
145       Processing</a>
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
165       System Interface</a>
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
171       Comments</a>
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
174       Markup Language</a>
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
189       Shell</a>
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
212       Locator</a>
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
215       Universal Time</a>
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
218       Format</a>
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
230       Language</a>
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>