Index
A
- actions
- performing, on many tables / Performing actions on many tables, How to do it...
- working / How it works..., There's more...
- active query, running
- verifying / What are they running?, How to do it...
- alter.tablealter.table
- about / There's more...
- ANALYZE command
- about / Introduction
- Archiver process
- about / How it works...
- auto freezing
- automatic database maintenance
- controlling / Controlling automatic database maintenance
- Autovacuum
- about / How it works...
- autovacuum
- about / Controlling automatic database maintenance
- enabling / How to do it...
- working / How it works...
B
- Background writer process
- about / How it works...
- backup/recovery options
- about / Planning backups
- backup/restore performance
- improving / Improving performance of backup/restore, How to do it...
- backup performance
- backups
- planning / Planning backups, How to do it...
- basic server configuration checklist
- bloated tables and indexes
- boxes_position_excl / How to do it...
- BSD (Berkeley Distribution Software) license / Getting PostgreSQL
- bug
- reporting / See also, How it works...
- investigating / See also, How it works...
C
- Cacti
- about / Monitoring is important
- causes, for slow SQL statement
- excess data, processing / Too much data is processed
- less memory / Too little of the data fits in the memory
- excess data, returning by query / The query returns too much data
- locking problems / Locking problems
- CentOS
- database server files, locating / How to do it...
- database server message log, locating / How to do it...
- change logs
- saving, to another database / Collecting changes using triggers and saving them to another database using dblink or plproxy
- checkpoint_segments / How to do it...
- checkpoint_timeout / How to do it...
- check_postgres plugins / There's more...
- check_postgres_bloat / There's more...
- column datatypes
- changing / Changing datatype of a column, How to do it..., There's more...
- columns, of data table
- adding/removing / Adding/Removing the columns of a table, How it works...
- complex SQL
- simplifying / Simplifying complex SQL, Getting ready
- complex SQL, simplifying
- subquery, moving to view / Moving part of the query into a view
- WITH statement, using / Using the WITH statement instead of a separate view
- temporary tables, using for subquery / Using temporary tables for parts of the query
- materialized views, using / Use materialized views (long-living temp tables)
- computer connectivity
- connection information
- inspecting / Inspecting your connection information
- Connection Pool
- setting up / Set up a Connection Pool, How to do it..., How it works...
- about / Set up a Connection Pool
- Contrib / Getting ready
- crash recovery
- about / Understanding and controlling crash recovery
- controlling / How to do it..., How it works...
- CREATE GROUP command / CREATE USER and CREATE GROUP
- CREATE ROLE command / CREATE USER and CREATE GROUP
- CREATE USER command / CREATE USER and CREATE GROUP
- current configuration settings, PostgreSQL
D
- data
- sampling / Randomly sampling data, How to do it...
- loading, from spreadsheet / Loading data from a spreadsheet, How to do it...
- loading, from flat files / Loading data from flat files, How to do it...
- database
- recovering / Recovery of a dropped/damaged database, How to do it...
- database connection, SSL used
- about / Connecting using SSL
- working / How it works...
- SSL key and certificate, getting / Getting SSL key and certificate
- client, setting up / Setting up a client to use SSL
- server authenticity, checking / Checking server authenticity
- database object definitions backup
- about / Backup of database object definitions
- performing / How to do it...
- databases
- listing / List databases on this database server?, How to do it..., How it works...
- monitoring / Monitoring is important
- viewing, pgAdmin used / Realtime view using pgAdmin
- database server
- starting manually / Starting the database server manually, How it works...
- stopping / Stopping the server safely and quickly, How it works...
- stopping, in emergency / Stopping the server in an emergency
- server configuration files, reloading / Reloading the server configuration files, How to do it..., There's more...
- restarting / Restarting the server quickly, How to do it...
- new connections, preventing / Preventing new connections, How to do it..., How it works...
- users, restricting to one session / Restricting users to just one session each, How it works...
- users, terminating / Pushing users off the system, How to do it...
- recovery / Recovery of all databases, How to do it...
- database server files, PostgreSQL
- locating / Locate the database server files, How to do it...
- locating, on Debian or Ubuntu / How to do it...
- locating, on CentOS / How to do it...
- locating, on Red Hat RHEL / How to do it...
- locating, on Fedora / How to do it...
- working / How it works...
- database server message log
- locating / Locate the database server message log
- locating, on Debian or Ubuntu systems / How to do it...
- locating, on Fedora / How to do it...
- locating, on CentOS / How to do it...
- locating, on Red Hat RHEL / How to do it...
- locating, on Windows systems / How to do it...
- working / How it works...
- database sessions
- terminating / Killing a specific session, How it works...
- databases session, terminating
- query, canceling / Try to cancel the query first
- backend, terminating / If the backend won't terminate
- queries, cleaning up / Use statement timeout to clean up queries which take too long
- idle in transaction queries, terminating / Killing "Idle in transaction" queries
- backend, terminating from command line / You can also kill the backend from command line
- data changes
- auditing / Auditing data changes, Collecting changes using triggers and saving them to another database using dblink or plproxy
- collecting, from server log / Collecting data changes from server log
- collecting, triggers used / Collecting changes using triggers
- data generator
- features / There's more...
- data quality issues, removing
- about / Enforcing same name, same column definition
- Information Schema query, using / Columns
- tables, comparing / Tables
- table definitions, comparing / There's more...
- dblink
- installing / Getting ready
- working / How it works...
- functions / There's more...
- dbname
- about / How it works...
- DDL (Data Definition Language)
- about / Auditing DDL changes
- DDL changes
- auditing / Auditing DDL changes, How it works...
- Debian or Ubuntu systems
- database server files, locating / How to do it...
- debugging_info function
- differential backup
- differential physical backup
- performing / How to do it...
- working / How it works...
- disk space size, database
- finding / How much disk space does a database use?
- disk space size, of table
- du command / When temp_tablespaces has one or more tablespaces
- duplicate rows
- preventing / Preventing duplicate rows, How to do it..., How it works...
- duplicates
E
- EMS SQLManager
- URL / See also
- enable_seqscan
- setting to false / set enable_seqscan to false
- external module
- adding, to PostgreSQL / Adding an external module to PostgreSQL, How to do it...
F
- failed connection
- troubleshooting / Troubleshooting a failed connection, How to do it...
- Fedora
- database server files, locating / How to do it...
- database server message log, locating / How to do it...
G
- generic monitoring tools
- genetic query optimization (GEQO) / Using temporary tables for parts of the query
- GNU Privacy Handbook
- URL / See also
- graphical administration tools
- upgrading / Using graphical administration tools, How to do it...
H
- hostaddr
- about / How it works...
- hstore / What makes PostgreSQL different?
I
- IANA
- about / How it works...
- incremental backup
- indexes
- maintaining / Maintaining indexes, Getting ready, How to do it..., How it works...
- Information Schema
- about / How it works...
L
- LDAP (lightweight Directory Access Protocol) / Integrating with LDAP
- LDAP integration
- about / Integrating with LDAP
- libpq interface library / How to do it...
- Lightning Admin
- URL / See also
- Linux Filesystem Hierarchy Standard (FHS) / How it works...
- listen_addresses parameter / How it works...
- logfile errors, daily summary report
- logical backup
- improving / How to do it...
- logical backup, of all databases
- about / Hot logical backup of all databases
- performing / How to do it...
- working / How it works...
- logical backup, of all tables in tablespace
- about / Hot logical backup of all tables in a tablespace
- performing / How to do it...
- working / How it works...
- logical backup, of one database
- about / Hot logical backup of one database
- performing / How to do it...
- working / How it works...
- logical restore
- improving / How to do it...
- Log Sequence Number (LSN) / There's more...
M
- maintenance
- planning / Planning maintenance, How it works...
- Major.Minor.Maintenance format
- about / How it works...
- max_client_conn parameter / How to do it...
- max_connections parameter / How to do it...
- max_stack_depth / Who set that?
- monitoring information
- multi-tenancy
- multi-tenancy design
- Multi-Version Concurrency Control (MVCC) / What makes PostgreSQL different?
- multiple physical databases
- running on server / How to do it...
- multiple schemas
- using / Using multiple schemas, How to do it...
- working / How it works...
- multiple servers
- running, on one system / Running multiple servers on one system, How it works...
- Munin
- about / Monitoring is important
- MVCC
- about / How it works...
N
- Nagios
- names, for database objects
- selecting / Choosing good names for database objects
- Navicat
- URL / See also
- network/remote access
- network port
- about / How it works...
- newcust_customerid_excl / How to do it...
- newcust_customerid_idx / How to do it...
- newcust_customerid_key / How to do it...
- newcust_pkey / How to do it...
- new database
- planning / Planning a new database, How it works...
O
- objects
- handling, with quoted names / Handling objects with quoted names, How to do it..., There's more...
- moving, between schemas / Moving objects between schemas, How it works...
- moving, between tablespaces / Moving objects between tablespaces, How it works..., There's more...
- accessing, in other PostgreSQL databases / Accessing objects in other PostgreSQL databases, Getting ready, How to do it..., How it works...
- old prepared transactions
- OLTP (Online Transaction Processing) systems / How to catch queries which only run for a few milliseconds
- OpenSSL web page
- URL / See also
- Optimal Flexible Architecture (OFA) / How it works...
- optimistic locking
- using / Using optimistic locking
- OS X
- database server files, locating / How to do it...
P
- page corruptions
- parameter file
- updating / Updating the parameter file, There's more...
- parameters
- changing / Changing parameters in your programs, How it works..., There's more...
- checking, for non-default settings / Which parameters are at non-default settings?, How it works...
- setting, for partuicular user groups / Setting parameters for particular groups of users, How it works...
- parameters, for toast tables
- toast.autovacuum_enabled / How to do it...
- toast.autovacuum_vacuum_cost_delay / How to do it...
- toast.autovacuum_vacuum_cost_limit / How to do it...
- toast.autovacuum_vacuum_scale_factor / How to do it...
- toast.autovacuum_vacuum_threshold / How to do it...
- toast.autovacuum_freeze_min_age / How to do it...
- toast.autovacuum_freeze_max_age / How to do it...
- toast.autovacuum_freeze_table_age / How to do it...
- toast.autovacuum_analyze_scale_factor / How to do it...
- toast.autovacuum_analyze_threshold / How to do it...
- parameters, postgresql.conf
- autovacuum / How to do it...
- autovacuum_analyze_scale_factor / How to do it...
- autovacuum_analyze_threshold / How to do it...
- autovacuum_freeze_max_age / How to do it...
- autovacuum_max_workers / How to do it...
- autovacuum_naptime / How to do it...
- autovacuum_vacuum_cost_delay / How to do it...
- autovacuum_vacuum_cost_limit / How to do it...
- autovacuum_vacuum_scale_factor / How to do it...
- autovacuum_vacuum_threshold / How to do it...
- log_autovacuum_min_duration / How to do it...
- partial index
- about / How to do it...
- password
- changing / Changing your password securely, How to do it...
- keeping, in secure password file / Avoiding hardcoding your password, Getting ready, How it works...
- performance tuning, PostgreSQL
- slow SQL statements, finding / Finding slow SQL statements
- regular optimizer statistics, collecting / Collecting regular statistics from pg_stat* views
- reasons for slow SQL statement, finding / Finding what makes SQL slow
- number of returned rows, reducing / Reducing the number of rows returned, Application runs a huge number of small lookup queries
- complex SQL, simplifying / Simplifying complex SQL, Getting ready
- queries, speeding up / Speeding up queries without rewriting them
- query, not using an index / Why is my query not using an index?, How to do it...
- database, forcing to use an index / How do I force a query to use an index, set enable_seqscan to false
- optimistic locking, using / Using optimistic locking
- performance problems, reporting / Reporting performance problems
- pgAdmin
- about / How to do it...
- working / How it works...
- pgAdmin3
- about / How to do it...
- PgBouncer / Connecting using SSL
- Pgcrypto
- about / Two versions of pg_crypto
- pgcrypto package / Encrypting sensitive data
- PgCrypto page
- URL / See also
- pgFoundry / Getting ready
- pgloader
- about / Getting ready
- PGPASSFILE / How to do it...
- PGSSLMODE / Setting up a client to use SSL
- pgstatindex() / How it works...
- pgstattuple() / How it works...
- pg_batch
- pg_cacheutils / How to do it...
- pg_cache_save() / How it works...
- pg_cache_warm() / How it works...
- pg_catalog
- about / How it works...
- pg_catalog schema / How it works...
- pg_controldata
- about / How it works...
- pg_database_size() function
- object dependencies / How it works...
- pg_dump
- about / Planning backups
- pg_dumpall
- about / Planning backups
- pg_dumpall utility / How it works...
- pg_hba.conf / How it works..., Updating the parameter file
- pg_ident.conf / Updating the parameter file
- pg_locks view / There's more...
- pg_ls_dir(dirname text) function / How it works...
- pg_rman / There's more...
- pg_rman 1.1.2 / There's more...
- pg_settings / How to do it...
- pg_stat_activity / There's more..., How to do it..., How it works...
- pg_stat_activity.waiting field / This catches only queries waiting on locks
- pg_stat_file(filename text) function / How it works...
- pg_stat_get_activity function / How it works...
- pg_stat_user_indexes / Providing PostgreSQL information to monitoring tools
- pg_stat_user_tables / Providing PostgreSQL information to monitoring tools, How it works...
- pg_stop_backup() function
- about / How it works...
- pg_terminate_backend() / How it works...
- pg_terminate_backend() function / How to do it...
- pg_terminate_backend(processid) function / How to do it..., How it works...
- phpPgAdmin
- URL / There's more...
- about / There's more...
- physical backup
- improving / How to do it...
- physical database backup
- about / Standalone hot physical database backup
- performing / How to do it...
- working / How it works...
- physical database backup, with continuous archiving
- about / Hot physical backup , Getting ready
- performing / How to do it...
- working / How it works...
- physical restore
- improving / How to do it...
- PL/Proxy / See also
- point in time recovery (PITR)
- about / Recovery to a point in time
- performing / How to do it...
- working / How it works...
- PostGIS
- about / How it works...
- postgres
- about / How it works...
- postgres OS user
- connecting / Getting ready
- PostgreSQL
- about / Introduction, Introducing PostgreSQL 9, Introduction
- benefits / Introducing PostgreSQL 9
- features / Introducing PostgreSQL 9, What makes PostgreSQL different?
- objectives / What makes PostgreSQL different?
- downloading / Getting PostgreSQL, How to do it...
- installing / How to do it...
- working / How it works..., How it works...
- accessing / Connecting to PostgreSQL server, How to do it..., How it works...
- connection information, inspecting / Inspecting your connection information
- network/remote access, enabling / Enabling access for network/remote users, How it works...
- graphical administration tools, upgrading / Using graphical administration tools, How to do it...
- password, changing securely / Changing your password securely, How to do it...
- password, keeping in secure password file / Avoiding hardcoding your password, Getting ready, How it works...
- connection service file, using / Using a connection service file, How it works...
- failed connection, troubleshooting / Troubleshooting a failed connection, How to do it...
- version, checking / What version is the server?
- release support policy / How it works...
- version number, checking / There's more...
- server uptime, monitoring / What is the server uptime?, How to do it...
- database server files, locating / Locate the database server files, How to do it...
- database server message log, locating / Locate the database server message log, How to do it...
- databases, listing / List databases on this database server?, How to do it..., How it works...
- number of tables / How many tables in a database?, How it works...
- disk space size, finding / How much disk space does a database use?
- disk space size of table, finding / How much disk space does a table use?, How to do it...
- biggest table size, finding / Which are my biggest tables?
- table rows, counting / How many rows in a table?
- number of rows in table, estimating / Quick estimate of the number of rows in a table, How to do it...
- object dependencies / Understanding object dependencies
- manual, reading / Reading the Fine Manual (RTFM)
- new database, planning / Planning a new database, How it works...
- parameters, changing / Changing parameters in your programs, How it works..., There's more...
- current configuration settings / What are the current configuration settings?, How to do it...
- parameter file, updating / Updating the parameter file, There's more...
- parameters, setting for partuicular user groups / Setting parameters for particular groups of users, How it works...
- basic server configuration checklist / Basic server configuration checklist, How to do it...
- external module, adding / Adding an external module to PostgreSQL, How to do it...
- running, in power saving mode / Running server in power saving mode, How to do it..., How it works...
- data directory / Introduction
- database server, starting manually / Starting the database server manually, How it works...
- multiple schemas, using / Using multiple schemas, How to do it...
- private database, providing to users / Giving users their own private database, How to do it..., There's more...
- database object names, selecting / Choosing good names for database objects
- objects, handling with quoted names / Handling objects with quoted names, How to do it..., There's more...
- data quality issues, removing / Enforcing same name, same column definition
- duplicates, removing / Identifying and removing duplicates, How to do it..., How it works..., There's more...
- duplicates, identifying / Identifying and removing duplicates, How to do it..., How it works..., There's more...
- duplicate rows, preventing / Preventing duplicate rows, How to do it..., How it works...
- duplicate indexes / Duplicate indexes
- uniqueness without indexes / Uniqueness without indexes
- unique set of key columns, finding / Finding a unique key for a set of data, How to do it...
- test data, generating / Generating test data, Rows
- data, loading from spreadsheet / Loading data from a spreadsheet, How to do it...
- data, loading from flat files / Loading data from flat files, How to do it...
- security / Introduction
- new user, creating / Creating a new user
- rights of deleted users, assigning to new user / You can assign the rights of the "deleted" user to a new user
- ownerships, assigning to user / Assigning ownerships to other users
- ownership, reassigning / Reassigning ownership in older databases
- integrating, with LDAP / Integrating with LDAP
- enabling, SSL used / Connecting using SSL, How to do it...
- sensitive data, encrypting / Encrypting sensitive data, How to do it...
- script, writing / Writing a script that either all succeeds or all fails
- script, working / How it works...
- psql script, writing / Writing a psql script that exits on first error, How to do it...
- actions, performing on many tables / Performing actions on many tables
- table columns, adding/removing / Adding/Removing the columns of a table, How it works...
- column datatypes, changing / Changing datatype of a column, How to do it..., There's more...
- schemas, adding/removing / Adding/Removing schemas, There's more...
- schema-level privileges / Schema-level privileges
- objects, moving between schemas / Moving objects between schemas, How it works...
- tablespaces, adding/removing / Adding/Removing tablespaces, Getting ready, How to do it...
- objects, moving between tablespaces / Moving objects between tablespaces, How it works..., There's more...
- objects, accessing in other PostgreSQL databases / Accessing objects in other PostgreSQL databases, Getting ready, How to do it...
- views, making updateable / Making views updateable, How to do it...
- monitoring information, providing / Providing PostgreSQL information to monitoring tools
- regular maintenance / Introduction
- performance tuning / Introduction
- backups / Introduction
- crash recovery / Understanding and controlling crash recovery
- postgresql-contrib / Getting ready
- PostgreSQL-LDAP inetgration
- about / Integrating with LDAP
- working / How it works...
- client, setting up / Setting up the client to use LDAP
- postgresql.conf / How to do it...
- PostgreSQL 9
- introducing / Introducing PostgreSQL 9
- PostgreSQL documents
- about / Reading the Fine Manual (RTFM)
- database design / How to do it...
- transaction analysis / How to do it...
- hardware configuration / How to do it...
- localization plan / How to do it...
- access and security plan / How to do it...
- maintenance plan / How to do it...
- availability plan / How to do it...
- high availability plan / How to do it...
- PostgreSQL Flexible Architecture (PFA) / How it works...
- PostgreSQL manual
- about / Reading the Fine Manual (RTFM)
- reference link / How to do it...
- working / How it works...
- PQA (Practical Query Analysis) / See also
- private database
- providing, to users / Giving users their own private database, How to do it..., There's more...
- production database
- administrators / Typical user role
- end-users / Typical user role
- psql
- about / Using psql query and scripting tool
- using / Getting ready, How to do it...
- working / How it works...
- psql script
- writing / Writing a psql script that exits on first error, How to do it...
- working / How it works...
Q
- queries
- long-running queries, viewing / How to watch longest queries
- viewing, from ps / Watching queries from ps
- status, verifying / Are they active or blocked?
- blocking, causes / Who is blocking them?, How to do it...
- slowing down, causes / Why are my queries slowing down?, How to do it..., Is the second run of same query also slow?
- queries, running for milliseconds
- queries, speeding up
- better information, providing / Providing better information to the optimizer
- multi-column index, adding / Adding a multi-column index tuned specifically for that query
- special conditional index adding / Adding a special conditional index
- table, clustering on specific indexes / Cluster tables on specific indexes
- constraint exclusion, using / Use table partitioning and constraint exclusion
- table partitioning, using / Use table partitioning and constraint exclusion
- fillfactor, setting on table / In case of many updates set fillfactor on table
- schema, rewriting / Rewriting the schema—a more radical approach
- quote_ident() / There's more...
R
- random() function / How it works...
- random_page_cost
- lowering / Lower random_page_cost
- recovery, of database server
- logical recovery / How to do it..., How it works...
- performing / How to do it...
- physical recovery / How to do it..., How it works...
- working / How it works...
- Red Hat layout / How it works...
- Red Hat RHEL
- database server files, locating / How to do it...
- database server message log, locating / How to do it...
- regular maintenance
- about / Introduction
- automatic database maintenance, controlling / Controlling automatic database maintenance, How to do it...
- page corruptions, avoiding / Avoiding auto freezing and page corruptions, Getting ready, How to do it...
- auto freeze, avoiding / Avoiding auto freezing and page corruptions, Getting ready, How to do it...
- transaction wraparound, avoiding / Avoiding transaction wraparound, Getting ready
- old prepared transactions, removing / Removing old prepared transactions, Getting ready
- actions, for heavy users of temporary tables / Actions for heavy users of temporary tables, How it works...
- bloated tables and indexes, fixing / Identifying and fixing bloated tables and indexes
- bloated tables and indexes, identifying / Identifying and fixing bloated tables and indexes
- indexes, maintaining / Maintaining indexes, Getting ready, How to do it..., How it works...
- unwanted indexes, removing / Carefully removing unwanted indexes
- maintenance, planning / Planning maintenance, How it works...
- regular optimizer statistics
- collecting / Collecting regular statistics from pg_stat* views
- working / How it works...
- REINDEX CONCURRENTLY command / See also
- restore performance
- rows, in table
- counting / How many rows in a table?
- estimating / Quick estimate of the number of rows in a table
- RRDtool (Round Robin Database Tool)
- about / Monitoring is important
- Munin / Monitoring is important
- Cacti / Monitoring is important
- RTFM
- about / Reading the Fine Manual (RTFM)
- Ruby / See also
S
- schemas
- adding/removing / Adding/Removing schemas, There's more...
- script
- writing / Writing a script that either all succeeds or all fails
- working / How it works...
- security
- about / Introduction
- user access, revoking to table / Revoking user access to a table, How to do it...
- user access, granting to table / Granting user access to a table
- new database user, creating / Creating a new user
- user connection, preventing temporarily / Temporarily preventing a user from connecting
- user, removing without dropping data / Removing a user without dropping their data
- user passwords, encrypting / Checking all users have a secure password
- superuser powers, limiting to specific users / Giving limited superuser powers to specific users, Getting ready, How it works...
- DDL changes, auditing / Auditing DDL changes
- data changes, auditing / Auditing data changes
- sensitive data
- encrypting / Encrypting sensitive data, How to do it...
- Separate projects / Getting ready
- server configuration files
- server uptime, PostgreSQL
- monitoring / What is the server uptime?, How to do it...
- SET LOCAL command / There's more...
- SHOW command / How to do it...
- SHOW commands / There's more...
- Slony
- about / How it works...
- slow SQL statements
- finding / Finding slow SQL statements, How to do it...
- queries, finding / Finding queries that make the server slow
- slow queries, making appearing in slow query log / Once a suspect is found, make the query slow, so that it is logged
- SNMP (Simple Network Management Protocol)
- about / Monitoring is important
- SQL function
- creating / Function 1, Function 2
- SQL REINDEX command / Getting ready
- storage parameters
- autovacuum_enabled / How to do it...
- autovacuum_vacuum_cost_delay / How to do it...
- autovacuum_vacuum_cost_limit / How to do it...
- autovacuum_vacuum_scale_factor / How to do it...
- autovacuum_vacuum_threshold / How to do it...
- autovacuum_freeze_min_age / How to do it...
- autovacuum_freeze_max_age / How to do it...
- autovacuum_freeze_table_age / How to do it...
- autovacuum_analyze_scale_factor / How to do it...
- autovacuum_analyze_threshold / How to do it...
- superuser powers
- limiting, to specific users / Giving limited superuser powers to specific users, Getting ready, How it works...
- Swiss knife script / Providing PostgreSQL information to monitoring tools
- syslog / How to do it...
T
- table
- status, verifying / Is anybody using a specific table?
- daily usage statistics, collecting / Collecting daily usage statistics
- file dates, viewing / Looking at file dates
- recovering / Recovery of a dropped/damaged table, How to do it...
- tablespace
- tablespaces
- adding/removing / Adding/Removing tablespaces, Getting ready, How to do it...
- working / How it works...
- pg_xlog directory, putting on seperate device / Putting pg_xlog on a separate device
- tablespace-level tuning / Tablespace-level tuning
- temporary data
- space consumption, measuring / How much disk space is used by temporary data?
- temp_tablespaces settings / When temp_tablespaces has one or more tablespaces, When temp_tablespaces is empty
- temporary file usage
- logging / Logging temporary file usage
- temp_tablespaces parameter / How to do it...
- test data
- generating / Generating test data, Rows
- rows, generating / Rows
- columns, generating / Columns, How it works...
- timeofday() function / Uniqueness without indexes
- TOAST
- about / There's more...
- TOAST index
- about / How it works...
- TOAST table
- about / How it works...
- TPL (The PostgreSQL License) / Getting PostgreSQL
- transaction wraparound
- avoiding / Avoiding transaction wraparound, How to do it...
- troubleshooting, failed connection
- database name and username, checking / How to do it...
- explicit rejections, checking / How to do it...
- implicit rejections, checking / How to do it...
- psql connection, checking / How to do it...
- server, checking / How to do it...
- port, checking / How to do it...
- connection request, checking / How to do it...
- disconnection reasons, checking / How to do it...
U
- unique set of key columns
- unwanted indexes
- removing / Carefully removing unwanted indexes
- user
- removing / Removing a user without dropping their data
- user access
- revoking, to table / Revoking user access to a table, How to do it...
- granting, to table / Granting user access to a table, There's more...
- granting, to table through group role / Granting access to a table through a group role
- granting, to all objects in schema / Granting access to all objects in schema
- user connection
- preventing temporarily / Temporarily preventing a user from connecting
- NOLOGIN users, disconnecting / Forcing NOLOGIN users to disconnect
- verifying / Is the user connected?
- user passwords
- encrypting / Getting ready, How to do it...
V
- VACUUM command
- about / Introduction
- versions, PostgreSQL
- PostgreSQL 8.2 / How it works...
- PostgreSQL 8.3 / How it works...
- PostgreSQL 8.4 / How it works...
- PostgreSQL 9.0 / How it works...
- views
- about / Making views updateable
- making updateable / Making views updateable, How to do it...
- working / How it works...
- VPN (Virtual private Network) / Connecting using SSL
W
- WAL receiver process
- about / How it works...
- WAL writer process
- about / How it works...
- Windows
- database server files, locating / How to do it...
- Write Ahead Log (WAL) / How to do it...