Index

A

aggregate, Aggregate Functions
alias
for table name in query, Joins Between Tables
Australian time zones, General Operation
authentication methods
ident-based authentication, Ident-Based Authentication
overview, Authentication Methods
password authentication, Password Authentication
autocommit
disabling, Disable Autocommit
automatic encoding translation
summary, Automatic Encoding Translation Between Server and Client
average, Aggregate Functions

B

backend interface
commands, BKI Commands
file format, BKI File Format
overview, BKI Backend Interface
backend internals
overview, PostgreSQL Backend Internals Overview
base tables
given in view definition, The Path of a Query
BKI
commands, BKI Commands
file format, BKI File Format
overview, BKI Backend Interface
bootstrap mode
and BKI files, BKI Backend Interface

C

catalog cluster
creating, Creating a Database Cluster
CHECKPOINT_SEGMENTS
WAL configuration parameter, Write-Ahead Logging (WAL)
CHECKPOINT_TIMEOUT
WAL configuration parameter, Write-Ahead Logging (WAL)
chromosomes
and genetic algorithms, Genetic Algorithms (GA)
client authentication
controlled by pg_hba.conf file, The pg_hba.conf File
overview, Client Authentication
client/server model, How Connections are Established
cluster, Concepts
column, Concepts
COMMIT_DELAY
WAL configuration parameter, Write-Ahead Logging (WAL)
COMMIT_SIBLINGS
WAL configuration parameter, Write-Ahead Logging (WAL)
concurrency control
in PostgreSQL, Transactions and Locks
configuration parameters
-B, Short Options
-d, Short Options
-F, Short Options
-fh, Short Options
-fi, Short Options
-fm, Short Options
-fn, Short Options
-fs, Short Options
-ft, Short Options
-h, Short Options
-i, Short Options
-k, Short Options
-l, Short Options
-N, Short Options
-p, Short Options
CHECKPOINT_SEGMENTS, Write-Ahead Logging (WAL)
CHECKPOINT_TIMEOUT, Write-Ahead Logging (WAL)
COMMIT_DELAY, Write-Ahead Logging (WAL)
COMMIT_SIBLINGS, Write-Ahead Logging (WAL)
DEADLOCK_TIMEOUT, General Operation
debug level, Short Options
enable_hashjoin, Short Options
enable_indexscan, Short Options
enable_mergejoin, Short Options
enable_nestloop, Short Options
enable_seqscan, Short Options
enable_tidscan, Short Options
FSYNC, General Operation, Short Options
KRB_SERVER_KEYFILE, General Operation
MAX_CONNECTIONS, General Operation, Short Options
MAX_EXPR_DEPTH, General Operation
PORT, General Operation, Short Options
set from command line, Runtime Configuration
set from postgresql.conf, Runtime Configuration
shared buffers, Short Options
SHARED_BUFFERS, General Operation
short options, Short Options
SILENT_MODE, General Operation
SORT_MEM, General Operation
SQL_INHERITANCE, General Operation
SSL, General Operation, Short Options
TCPIP_SOCKET, General Operation, Short Options
UNIX_SOCKET_DIRECTORY, General Operation, Short Options
UNIX_SOCKET_GROUP, General Operation
UNIX_SOCKET_PERMISSIONS, General Operation
VIRTUAL_HOST, General Operation, Short Options
WAL_BUFFERS, Write-Ahead Logging (WAL)
WAL_DEBUG, Write-Ahead Logging (WAL)
WAL_FILES, Write-Ahead Logging (WAL)
WAL_SYNC_METHOD, Write-Ahead Logging (WAL)
connections
overview, How Connections are Established
COPY, Populating a Table With Rows
COPY FROM
using, Use COPY FROM
count, Aggregate Functions
CPU_INDEX_TUPLE_COST
planner/optimizer tuning, Planner and Optimizer Tuning
CPU_OPERATOR_COST
planner/optimizer tuning, Planner and Optimizer Tuning
CPU_TUPLE_COST
planner/optimizer tuning, Planner and Optimizer Tuning
CREATE TABLE, Creating a New Table
createdb, Creating a Database
reference pages, createdb
createlang
reference pages, createlang
createuser
reference pages, createuser
Cyrillic recode support
setting, Single-byte Character Set Recoding

D

data consistency checks
overview, Data Consistency Checks at the Application Level
database
creating, Creating a Database
database backup
chunking output, Large Databases
compressed dumps, Large Databases
file system level backup, File System Level Backup
large databases, Large Databases
limitations, Caveats
SQL dump, SQL Dump
using a custom dump format, Large Databases
using pg_dumpall, Using pg_dumpall
using split, Large Databases
database cluster
creating, Creating a Database Cluster
database dumps
and customized template1, Restoring the Dump
between servers, Restoring the Dump
creating empty database from template0, Restoring the Dump
database passwords
and pg_dumpall limitations, Using pg_dumpall
database recovery
using WAL, Database Recovery with WAL
database restore
restoring the dump, Restoring the Dump
SQL dump, SQL Dump
database server
starting, Starting the Database Server
database storage area
creating, Creating a Database Cluster
database user names
separate from Linux user names, Client Authentication
database users
groups, Groups
overview, Database Users
privileges, Privileges
user attributes, User Attributes
databases
accessing, Accessing a Database
creating, Creating a Database
creating in new locations, Alternative Locations
creating the first, Creating a Database
destroying, Destroying a Database
managing, Managing Databases
populating, Populating a Database
deadlocks, Deadlocks
DEADLOCK_TIMEOUT
configuration parameter, General Operation
debug level
configuration parameter, Short Options
debug levelfsync
configuration parameter, Short Options
debugging
DEBUG_ASSERTIONS, Logging and Debugging
DEBUG_LEVEL, Logging and Debugging
DEBUG_PRETTY_PRINT, Logging and Debugging
DEBUG_PRINT_PARSE, Logging and Debugging
DEBUG_PRINT_PLAN, Logging and Debugging
DEBUG_PRINT_QUERY, Logging and Debugging
DEBUG_PRINT_REWRITTEN, Logging and Debugging
HOSTNAME_LOOKUP, Logging and Debugging
LOG_CONNECTIONS, Logging and Debugging
LOG_PID, Logging and Debugging
LOG_TIMESTAMP, Logging and Debugging
SHOW_EXECUTOR_STATS, Logging and Debugging
SHOW_PARSER_STATS, Logging and Debugging
SHOW_PLANNER_STATS, Logging and Debugging
SHOW_QUERY_STATS, Logging and Debugging
SHOW_SOURCE_PORT, Logging and Debugging
SYSLOG, Logging and Debugging
SYSLOG_FACILITY, Logging and Debugging
SYSLOG_IDENT, Logging and Debugging
TRACE_NOTIFY, Logging and Debugging
DEBUG_ASSERTIONS
logging/debugging, Logging and Debugging
DEBUG_LEVEL
logging/debugging, Logging and Debugging
DEBUG_PRETTY_PRINT
logging/debugging, Logging and Debugging
DEBUG_PRINT_PARSE
logging/debugging, Logging and Debugging
DEBUG_PRINT_PLAN
logging/debugging, Logging and Debugging
DEBUG_PRINT_QUERY
logging/debugging, Logging and Debugging
DEBUG_PRINT_REWRITTEN
logging/debugging, Logging and Debugging
DELETE, Deletions
device full warning
using ipcclean, ipcclean
dirty reads, Transaction Isolation
disk space, Recovering Disk Space
DISTINCT, Querying a Table
DROP TABLE, Creating a New Table
dropdb
reference pages, dropdb
droplang
reference pages, droplang
dropuser
reference pages, dropuser
duplicate, Querying a Table
dynamic loading, General Operation
dynamic_library_path, General Operation

E

ecpg
reference pages, ecpg
EFFECTIVE_CACHE_SIZE
planner/optimizer tuning, Planner and Optimizer Tuning
enable_hashjoin
configuration parameter, Short Options
planner/optimizer tuning, Planner and Optimizer Tuning
enable_indexscan
configuration parameter, Short Options
planner/optimizer tuning, Planner and Optimizer Tuning
enable_mergejoin
configuration parameter, Short Options
planner/optimizer tuning, Planner and Optimizer Tuning
enable_nestloop
configuration parameter, Short Options
planner/optimizer tuning, Planner and Optimizer Tuning
enable_seqscan
configuration parameter, Short Options
planner/optimizer tuning, Planner and Optimizer Tuning
ENABLE_SORT
planner/optimizer tuning, Planner and Optimizer Tuning
enable_tidscan
configuration parameter, Short Options
planner/optimizer tuning, Planner and Optimizer Tuning
encoding
enabling automatic, Automatic Encoding Translation Between Server and Client
encoding system
overriding with createdb, Multibyte Support
executor
overview, Executor
steps through plan tree, The Path of a Query
EXPLAIN
using, Using EXPLAIN

F

fitness
and genetic algorithms, Genetic Algorithms (GA)
foreign key, Foreign Keys
frontend/backend protocol
authentication phase, Start-up
backend start-up phase, Backend Start-up
canceling a query, Canceling Requests in Progress
Function Call cycle, Function Call
message data types, Message Data Types
message flow, Protocol
message formats, Message Formats
notification responses, Notification Responses
overview, Frontend/Backend Protocol
Query cycle, Query
termination, Termination
FSYNC
configuration parameter, General Operation
functions
overview, Functions and Triggers

G

GA (genetic algorithms)
overview, Genetic Algorithms (GA)
gene
and genetic algorithms, Genetic Algorithms (GA)
genetic algorithms
overview, Genetic Algorithms (GA)
genetic query optimization
in PostgreSQL, Genetic Query Optimization (GEQO) in PostgreSQL
overview, Genetic Query Optimization (GEQO)
GEQO
in PostgreSQL, Genetic Query Optimization (GEQO) in PostgreSQL
overview, Genetic Query Optimization (GEQO)
planner/optimizer tuning, Planner and Optimizer Tuning
GEQO_EFFORT
planner/optimizer tuning, Planner and Optimizer Tuning
GEQO_GENERATIONS
planner/optimizer tuning, Planner and Optimizer Tuning
GEQO_POOL_SIZE
planner/optimizer tuning, Planner and Optimizer Tuning
GEQO_RANDOM_SEED
planner/optimizer tuning, Planner and Optimizer Tuning
GEQO_SELECTION_BIAS
planner/optimizer tuning, Planner and Optimizer Tuning
GEQO_THRESHOLD
planner/optimizer tuning, Planner and Optimizer Tuning
GNU Readline
supported by psql, GNU Readline
gram.y
defines parser, The Parser Stage
GROUP BY, Aggregate Functions
groups
creating, Groups

H

hash join
and planner/optimizer, Generating Possible Plans
HAVING, Aggregate Functions
hierarchical database, Concepts
HOSTNAME_LOOKUP
logging/debugging, Logging and Debugging

I

ident-based authentication
overview, Ident-Based Authentication
index optimizations
affected by locale, Benefits
indexes
removing, Remove Indexes
inheritance, Inheritance
initdb
do not run as root, Description
reference pages, initdb
sets default encoding, Setting the Encoding
uses BKI files, BKI Backend Interface
initlocation
reference pages, initlocation
INSERT, Populating a Table With Rows
installing
procedural languages, Installing Procedural Languages
procedural languages, manually, Installing Procedural Languages
ipcclean
reference pages, ipcclean
IS NULL, General Operation
isolation levels, Transaction Isolation
data consistency checks, Data Consistency Checks at the Application Level
locking and tables, Locking and Tables
Read Committed, Read-Committed Isolation Level
read serializable, Serializable Isolation Level

J

join, Joins Between Tables
outer, Joins Between Tables
self, Joins Between Tables
joins
hash join, Generating Possible Plans
merge sort join, Generating Possible Plans
nested iteration join, Generating Possible Plans

K

KRB_SERVER_KEYFILE
configuration parameter, General Operation
KSQO
planner/optimizer tuning, Planner and Optimizer Tuning

L

LANG
sets locale, Overview
large databases
backups, Large Databases
lexer
defined by scan.l, Parser
libpg
in user applications, How Connections are Established
libpq
sets \encoding, Automatic Encoding Translation Between Server and Client
locale
set by LANG, Overview
locale support
effects, Benefits
enabling, Locale Support
troubleshooting, Troubleshooting
localization
overview, Localization
locking and indexes
overview, Locking and Indexes
locking and tables
deadlocks, Deadlocks
overview, Locking and Tables
row-level locks, Row-Level Locks
log files, Log File Maintenance
logging
DEBUG_ASSERTIONS, Logging and Debugging
DEBUG_LEVEL, Logging and Debugging
DEBUG_PRETTY_PRINT, Logging and Debugging
DEBUG_PRINT_PARSE, Logging and Debugging
DEBUG_PRINT_PLAN, Logging and Debugging
DEBUG_PRINT_QUERY, Logging and Debugging
DEBUG_PRINT_REWRITTEN, Logging and Debugging
HOSTNAME_LOOKUP, Logging and Debugging
LOG_CONNECTIONS, Logging and Debugging
LOG_PID, Logging and Debugging
LOG_TIMESTAMP, Logging and Debugging
SHOW_EXECUTOR_STATS, Logging and Debugging
SHOW_PARSER_STATS, Logging and Debugging
SHOW_PLANNER_STATS, Logging and Debugging
SHOW_QUERY_STATS, Logging and Debugging
SHOW_SOURCE_PORT, Logging and Debugging
SYSLOG, Logging and Debugging
SYSLOG_FACILITY, Logging and Debugging
SYSLOG_IDENT, Logging and Debugging
TRACE_NOTIFY, Logging and Debugging
LOG_CONNECTIONS
logging/debugging, Logging and Debugging
LOG_PID
logging/debugging, Logging and Debugging
LOG_TIMESTAMP
logging/debugging, Logging and Debugging

M

max, Aggregate Functions
MAX_CONNECTIONS
configuration parameter, General Operation, Short Options
MAX_EXPR_DEPTH
configuration parameter, General Operation
MD5 authentication, Password Authentication
merge sort join
and planner/optimizer, Generating Possible Plans
min, Aggregate Functions
multi-version concurrency control
in PostgreSQL, Transactions and Locks
multibyte support
enabling, Enabling Multibyte Support
overview, Multibyte Support
setting the encoding, Setting the Encoding
mutation
and genetic algorithms, Genetic Algorithms (GA)

N

nested iteration join
and planner/optimizer, Generating Possible Plans
non-repeatable reads, Transaction Isolation

O

object-oriented database, Concepts
optimizer tuning
CPU_INDEX_TUPLE_COST, Planner and Optimizer Tuning
CPU_OPERATOR_COST, Planner and Optimizer Tuning
CPU_TUPLE_COST, Planner and Optimizer Tuning
EFFECTIVE_CACHE_SIZE, Planner and Optimizer Tuning
ENABLE_HASHJOIN, Planner and Optimizer Tuning
ENABLE_INDEXSCAN, Planner and Optimizer Tuning
ENABLE_MERGEJOIN, Planner and Optimizer Tuning
ENABLE_NESTLOOP, Planner and Optimizer Tuning
ENABLE_SEQSCAN, Planner and Optimizer Tuning
ENABLE_SORT, Planner and Optimizer Tuning
ENABLE_TIDSCAN, Planner and Optimizer Tuning
GEQO, Planner and Optimizer Tuning
GEQO_EFFORT, Planner and Optimizer Tuning
GEQO_GENERATIONS, Planner and Optimizer Tuning
GEQO_POOL_SIZE, Planner and Optimizer Tuning
GEQO_RANDOM_SEED, Planner and Optimizer Tuning
GEQO_SELECTION_BIAS, Planner and Optimizer Tuning
GEQO_THRESHOLD, Planner and Optimizer Tuning
KSQO, Planner and Optimizer Tuning
RANDOM_PAGE_COST, Planner and Optimizer Tuning
ORDER BY, Benefits, Querying a Table

P

parser
overview, Parser
transformation process, Transformation Process
parser stage
creates query tree, The Path of a Query
overview, The Parser Stage
password authentication
overview, Password Authentication
passwords
and pg_dumpall limitations, Using pg_dumpall
paths
input to executor, The Path of a Query
pattern matching
affected by locale, Benefits
performance
index creation strategies, Remove Indexes
overview, Performance Tips
table insertion strategies, Populating a Database
pgaccess
reference pages, pgaccess
PGCLIENTENCODING
sets encoding, Automatic Encoding Translation Between Server and Client
pgtclsh
reference pages, pgtclsh
pgtksh
reference pages, pgtksh
pg_aggregate
stores aggregate function data, pg_aggregate
pg_attrdef
stores column default values, pg_attrdef
pg_attribute
stores table column data, pg_attribute
pg_class
catalogs tables, pg_class
stores index information, pg_class
pg_config
reference pages, pg_config
pg_ctl
reference pages, pg_ctl
pg_database
stores database information, pg_database
pg_description
stores database object descriptions, pg_description
pg_dump
limitations, Caveats
performs SQL dump, SQL Dump
reference pages, pg_dump
restoring the dump, Restoring the Dump
pg_dumpall
limitations, Using pg_dumpall, Caveats
performs SQL dump, Using pg_dumpall
reference pages, pg_dumpall
pg_group
defines groups, pg_group
pg_hba.conf file
controls client authentication, The pg_hba.conf File
example, The pg_hba.conf File
format, The pg_hba.conf File
pg_ident.conf
holds ident maps, Ident-Based Authentication
pg_ident.conf file
example, Ident-Based Authentication
pg_index
stores index information, pg_index
pg_inherits
stores table inheritance data, pg_inherits
pg_language
stores call interfaces, pg_language
pg_operator
column descriptions, pg_operator
pg_passwd
reference pages, pg_passwd
pg_proc
stores function information, pg_proc
pg_relcheck
stores table CHECK constraints, pg_relcheck
pg_restore
reference pages, pg_restore
pg_shadow
stores database user information, pg_shadow
pg_type
column descriptions, pg_type
phantom reads, Transaction Isolation
planner tuning
CPU_INDEX_TUPLE_COST, Planner and Optimizer Tuning
CPU_OPERATOR_COST, Planner and Optimizer Tuning
CPU_TUPLE_COST, Planner and Optimizer Tuning
EFFECTIVE_CACHE_SIZE, Planner and Optimizer Tuning
ENABLE_HASHJOIN, Planner and Optimizer Tuning
ENABLE_INDEXSCAN, Planner and Optimizer Tuning
ENABLE_MERGEJOIN, Planner and Optimizer Tuning
ENABLE_NESTLOOP, Planner and Optimizer Tuning
ENABLE_SEQSCAN, Planner and Optimizer Tuning
ENABLE_SORT, Planner and Optimizer Tuning
ENABLE_TIDSCAN, Planner and Optimizer Tuning
GEQO, Planner and Optimizer Tuning
GEQO_EFFORT, Planner and Optimizer Tuning
GEQO_GENERATIONS, Planner and Optimizer Tuning
GEQO_POOL_SIZE, Planner and Optimizer Tuning
GEQO_RANDOM_SEED, Planner and Optimizer Tuning
GEQO_SELECTION_BIAS, Planner and Optimizer Tuning
GEQO_THRESHOLD, Planner and Optimizer Tuning
KSQO, Planner and Optimizer Tuning
RANDOM_PAGE_COST, Planner and Optimizer Tuning
planner/optimizer
generating possible plans, Generating Possible Plans
overview, Planner/Optimizer
population
and genetic algorithms, Genetic Algorithms (GA)
PORT
configuration parameter, General Operation, Short Options
postgres
reference pages, postgres
postgres user, The Postgres User Account
PostgreSQL
query rewrite system, The Rewrite System
rule system, The PostgreSQL Rule System
PostgreSQL internals
overview, Overview of PostgreSQL Architecture and Internals
postgresql.conf
sets configuration parameters, Runtime Configuration
postmaster, Architectural Fundamentals
listens to UNIX or TCP/IP port, How Connections are Established
reference pages, postmaster
procedural languages
adding, Procedural Languages
installing, Installing Procedural Languages
manually installing, Installing Procedural Languages
ps
to monitor activity, Standard Linux Tools
psql, Accessing a Database
client process, How Connections are Established
reference pages, psql
\encoding command, Automatic Encoding Translation Between Server and Client

Q

query, Querying a Table
overview, The Path of a Query
query plan
made from query tree, The Path of a Query
query rewrite system
overview, The Rewrite System
query tree
created by parser, The Path of a Query

R

RANDOM_PAGE_COST
planner/optimizer tuning, Planner and Optimizer Tuning
range table, Query Trees
Read-committed isolation level
overview, Read-Committed Isolation Level
recombination
and genetic algorithms, Genetic Algorithms (GA)
referential integrity, Foreign Keys
relation, Concepts
relational database, Concepts
rewrite system
between parser and optimizer, The PostgreSQL Rule System
modifies query tree, The Path of a Query
row, Concepts
row-level locks
and isolation levels, Row-Level Locks
rules, The Rule System
and views, Views and the Rule System, Views and the Rule System
run-time configuration
overview, Runtime Configuration

S

scan.l
defines lexer, Parser
defines parser, The Parser Stage
schema dependencies
and database backup, Caveats
SELECT, Querying a Table
selection
and genetic algorithms, Genetic Algorithms (GA)
semaphores
ensure data integrity, How Connections are Established
Serializable isolation level
overview, Serializable Isolation Level
SET CLIENT_ENCODING TO
sets encoding, Automatic Encoding Translation Between Server and Client
shared buffers
configuration parameter, Short Options
SHARED_BUFFERS
configuration parameter, General Operation
SHOW_EXECUTOR_STATS
logging/debugging, Logging and Debugging
SHOW_PARSER_STATS
logging/debugging, Logging and Debugging
SHOW_PLANNER_STATS
logging/debugging, Logging and Debugging
SHOW_QUERY_STATS
logging/debugging, Logging and Debugging
SHOW_SOURCE_PORT
logging/debugging, Logging and Debugging
SIGHUP, The pg_hba.conf File, Ident-Based Authentication
SILENT_MODE
configuration parameter, General Operation
single-byte character set recoding
overview, Single-byte Character Set Recoding
sort order
affected by locale, Benefits
SORT_MEM
configuration parameter, General Operation
special columns
overview, Special Columns
SQL dump
to database restore, SQL Dump
SQL_INHERITANCE
configuration parameter, General Operation
SSL
configuration parameter, General Operation, Short Options
statistics, Statistics Collector
subquery, Aggregate Functions
sum, Aggregate Functions
superuser, Accessing a Database
SYSLOG
logging/debugging, Logging and Debugging
SYSLOG_FACILITY
logging/debugging, Logging and Debugging
SYSLOG_IDENT
logging/debugging, Logging and Debugging
system catalogs
overview, System Catalogs
store parser rules, The Path of a Query
system-defined columns
overview, Special Columns

T

table, Concepts
TCPIP_SOCKET
configuration parameter, General Operation, Short Options
timeout
authentication, General Operation
token
from SQL keywords, Parser
tokens
in BKI files, BKI File Format
to_char
affected by locale, Benefits
TRACE_NOTIFY
logging/debugging, Logging and Debugging
transaction ID
wraparound, Preventing Transaction ID Wraparound Failures
transaction isolation level, General Operation
transactions, Transactions
isolation, Transaction Isolation
locking, Transactions and Locks
triggers
overview, Functions and Triggers
TSP
traveling salesman problem, Genetic Query Optimization (GEQO) in PostgreSQL
tuples
retrieved by executor, The Path of a Query

U

Unicode
overview, About Unicode
UNIX_SOCKET_DIRECTORY
configuration parameter, General Operation, Short Options
UNIX_SOCKET_GROUP
configuration parameter, General Operation
UNIX_SOCKET_PERMISSIONS
configuration parameter, General Operation
UPDATE, Updates
user names
database user vs. Linux user, Client Authentication

V

vacuum, Routine Vacuuming
vacuumdb
reference pages, vacuumdb
version, Accessing a Database
view, Views
virtual table, The Path of a Query
view definition
sets base tables, The Path of a Query
views
updating, Updating Views
virtual table
view, The Path of a Query
VIRTUAL_HOST
configuration parameter, General Operation, Short Options

W

WAL
benefits, Benefits of WAL
configuration, WAL Configuration
database recovery, Database Recovery with WAL
implementation, Implementation
overview, General Description
WAL configuration parameters
CHECKPOINT_SEGMENTS, Write-Ahead Logging (WAL)
CHECKPOINT_TIMEOUT, Write-Ahead Logging (WAL)
COMMIT_DELAY, Write-Ahead Logging (WAL)
COMMIT_SIBLINGS, Write-Ahead Logging (WAL)
WAL_BUFFERS, Write-Ahead Logging (WAL)
WAL_DEBUG, Write-Ahead Logging (WAL)
WAL_FILES, Write-Ahead Logging (WAL)
WAL_SYNC_METHOD, Write-Ahead Logging (WAL)
WAL_BUFFERS
WAL configuration parameter, Write-Ahead Logging (WAL)
WAL_DEBUG
WAL configuration parameter, Write-Ahead Logging (WAL)
WAL_FILES
WAL configuration parameter, Write-Ahead Logging (WAL)
WAL_SYNC_METHOD
WAL configuration parameter, Write-Ahead Logging (WAL)
write ahead logging
benefits, Benefits of WAL
configuration, WAL Configuration
database recovery, Database Recovery with WAL
implementation, Implementation
overview, General Description

Z

zlib compression library
and database backups, Large Databases