Index

A

• -a parameter / How it works..., How it works..., How it works...
• agcount setting / How it works...
• allocsize setting / How it works...
• AMD Opteron CPUs
  • URL / See also
• AnandTech
  • URL / See also
• application data
  • selecting, to logical shard mapping / Choose an application data to logical shard mapping
• archive_command setting
  • URL / See also
• archive_mode setting
  • URL / See also
• associated resources
  • grouping / Grouping associated resources, How it works...
• asynchronous replication
  • building / Upgrading to asynchronous replication, How it works..., There's more...
  • changing, into synchronous replication / How to do it...
• attr2 option / How it works...
• attr inode setting / How it works...
• avgqu-sz field / How it works...
• await field / How it works...

B

• backend_start field / How it works...
• backup parameter / How it works...
• Barman
  • installing / Installing and configuring Barman, How to do it..., How it works..., See also
  • configuring / Installing and configuring Barman, How to do it..., How it works..., See also
  • URL / See also
  • database, backing up with / Backing up a database with Barman, How it works..., There's more...
  • database, restoring with / Restoring a database with Barman, How it works...
• barman command tool / See also, See also
• Barman documentation
  • URL / See also
• base options
  • starting with / Starting with base options, How it works...
• Bucardo
  • setting up / Setting up Bucardo, Getting ready, How it works...
  • URL / Getting ready, See also
  • tables, copying with / Copying a few tables with Bucardo, How it works...
• bucardo_ctl activate command / How it works...
• bucardo_ctl command / How it works...
  • URL / See also
• business downtime
  • determining / Determining acceptable losses, How to do it..., How it works...

C

• -c frag command / How it works...
• -c parameter / How it works...
• cache
  • creating / Create a cache
• calls column / How it works...
• capacity planning
  • about / Sizing storage
• Carbon
  • configuring, URL / See also
• CentOS
  • URL / See also
• chassis
  • selecting / Selecting a chassis, How it works...
• checkpoint activity
  • examining / Logging checkpoints properly, How to do it..., How it works..., See also
• checkpoints_req field
  • about / There's more...
• checkpoints_timed field
  • about / There's more...
• checkpoint_sync_time field
  • about / There's more...
• check_mk
  • about / Enhancing Nagios with check_mk
  • Nagios, enhancing with / Enhancing Nagios with check_mk, How to do it..., How it works..., There's more...
  • URL / How to do it...
• check_mk documentation
  • URL / See also
• check_postgres
  • installing / Getting to know check_postgres, How to do it..., How it works..., There's more...
  • URL / Getting ready, See also
• chkconfig utility / How it works...
• chown command / How it works...
• client connections, PgBouncer
  • listing / Listing PgBouncer client connections, There's more...
  • user / How it works...
  • database / How it works...
  • state / How it works...
  • connect_time / How it works...
  • request_time / How it works...
• clock_timestamp function
  • about / How it works...
• clone-max setting
  • about / How it works...
• clone-node-max setting
  • about / How it works...
• clone parameter / How it works...
• clones
  • about / How it works...
• cluster
  • hiding, for virtual IP addition / Adding a virtual IP to hide the cluster, How it works...
• clusterlabs.org website
  • URL / See also
• cluster management
  • DRBD, adding to / Adding DRBD to cluster management, How it works..., There's more...
  • LVM, adding to / Adding LVM to cluster management, How it works..., There's more...
  • XFS, adding to / Adding XFS to cluster management, How it works...
  • PostgreSQL, adding to / Adding PostgreSQL to cluster management, How it works..., There's more...
• Cluster Resource Manager / How it works...
• collectd
  • installing / Installing and configuring collectd, Getting ready, How to do it..., How it works...
  • configuring / Installing and configuring collectd, Getting ready, How to do it..., How it works...
  • about / Installing and configuring collectd
• collectd.conf Manpage
  • URL / See also
• collectd custom PostgreSQL query
  • creating / Adding a custom PostgreSQL monitor to collectd, How it works..., There's more...
• collectd data
  • adding, to Graphite / Adding collectd data to Graphite, Getting ready, How it works...
• collectd documentation
  • URL / See also
• collectd Manpage
  • URL / See also
• colocation
  • about / Combining and ordering related actions
• COMMAND column / How it works...
• components
  • installing / Installing the components, How it works..., There's more...
• concurrent index creation
  • testing / How to do it...
  • elements / No transactions, One at a time
• configure property parameter / How it works...
• connection costs and limits
  • determining / Determining connection costs and limits, How to do it..., There's more...
• connection pool
  • inserting / Introduction
• connections
  • terminating / Terminating rogue connections, How to do it..., How it works..., There's more...
• Corosync
  • about / Introduction, How it works...
  • configuring / Configuring Corosync, How to do it..., How it works...
• corosync-keygen utility / How it works...
• create-md parameter / How it works...
• create-root parameter / How it works...
• CREATE MATERIALIZED VIEW
  • URL / See also
• CREATE SERVER
  • URL / Mapping a remote user
• CREATE USER MAPPING
  • URL / Creating a foreign table
• create_id_function / How it works...
• crm command / How it works..., How to do it..., There's more...
• crm shell
  • about / See also
• crm_mon command / There's more...
• cron parameter / There's more...
• current disk performance
  • evaluating, with iostat utility / Evaluating the current disk performance with iostat, How to do it..., How it works..., See also
• current_query field / How it works...

D

• -d parameter / How it works...
• -D parameter / How it works...
• DAS
  • about / How it works...
• database
  • about / How to do it..., How it works...
  • backing up, with Barman / Backing up a database with Barman, How it works..., See also
  • restoring, with Barman / Restoring a database with Barman, How it works...
  • cloning, with repmgr / Cloning a database with repmgr, How to do it..., How it works..., See also
  • cloning, with walctl / Cloning a database with walctl, How it works...
• database host
  • monitoring, through Nagios configuration / Configuring Nagios to monitor a database host, How to do it..., How it works..., There's more..., See also
• Data source
  • URL / See also
• dd utility / There's more...
• Debian systems
  • URL / There's more...
• default_pool_size setting / How it works...
• define keyword / How it works...
• Dell
  • URL / See also
• derived values
  • about / How it works...
• device parameter / How it works...
• df command / How it works...
• dirty_background_ratio setting
  • about / How it works...
• Disaster Recovery
  • about / How it works...
• Disaster Recovery (DR) / How to do it...
• disk cache
  • restoring, to operating system / How to do it..., How it works...
• disk cache poisoning
  • defusing / Defusing cache poisoning, Getting ready
• disk failures, in real world
  • URL / See also
• disk keyword / How it works...
• DISK READ column / How it works...
• disk states / How it works...
• DISK WRITE column / How it works...
• doc/ directory / How it works...
• download parameter / How it works...
• DRBD
  • about / Why DRBD?, Adding block-level replication
  • adding / Adding block-level replication, How it works...
  • adding, to cluster management / Adding DRBD to cluster management, How it works..., There's more...
• DRBD, installation guide
  • URL / See also
• DRBD, storage speed
  • URL / The stack
• drbdadm command / There's more...
• drbdadm utility / Verifying a DRBD filesystem
• DRBD documentation
  • URL / See also, See also, See also
• DRBD filesystem
  • verifying / Verifying a DRBD filesystem, How it works...
• DRBD split brain
  • repairing / Correcting a DRBD split brain, How it works...
• DRBD system
  • dismantling / Detaching a problematic node, There's more...
• dstat
  • performance, correlating with / Correlating performance with dstat, How to do it..., How it works..., See also

E

• e-mail alert
  • adding / Adding an e-mail alert, How it works...
• EMC
  • URL / See also
• EPEL package
  • URL / Getting ready
  • installing, URL / Getting ready
• extract PostgreSQL function / How it works...
• Extra Packages for Enterprise Linux (EPEL) / Getting ready

F

• -f parameter / How it works...
• features, Intel CPUs
  • hyperthreading / Hyperthreading
  • Turbo Mode / Turbo Boost
  • power usage / Power usage
• first LVM layer
  • creating / How to do it..., How it works...
• foreign PostgreSQL server
  • setting up / Setting up a foreign PostgreSQL server, How it works...
• foreign servers
  • altering / Altering foreign servers
  • dropping / Dropping foreign servers
• foreign table
  • creating / Creating a foreign table, How to do it..., How it works..., There's more...
  • used, in query / Using a foreign table in a query, How to do it..., How it works..., There's more...
• foreign table access
  • optimizing / Optimizing foreign table access, How it works..., There's more...
• foreign tables
  • transforming, into local tables / Transforming foreign tables into local tables, How it works..., There's more...
• frontend caching
  • about / Introduction

G

• 10-gigabit Ethernet
  • URL, for working / See also
• gauges
  • about / How it works...
• generate_series PostgreSQL function
  • avg_query / How it works...
• Google Docs
  • URL / See also
• graph
  • building, in Graphite / Building a graph in Graphite, How it works...
• Graphite
  • installing / Installing and configuring Graphite, How to do it..., How it works...
  • configuring / Installing and configuring Graphite, How to do it..., How it works...
  • URL / See also
  • collectd data, adding to / Adding collectd data to Graphite, Getting ready, How it works...
  • graph, building / Building a graph in Graphite, How it works...
• Graphite dashboard
  • creating / Creating a Graphite dashboard, How to do it..., How it works..., There's more...
• Graphite documentation
  • URL / See also
• Graphite graph
  • customizing / Customizing a Graphite graph, How it works...
• group
  • about / Grouping associated resources

H

• --help parameter / How it works...
• -h parameter / How it works..., How it works..., How it works..., How it works...
• hardware
  • monitoring / Figuring out what to monitor, How to do it..., How it works...
• hardware failure
  • mitigating / Mitigating the impact of hardware failure, How to do it..., How it works...
• hardware planning, PostgreSQL database
  • redundancy, planning / Getting ready, How to do it..., How it works...
  • sufficient IOPS / Having enough IOPS, How to do it..., How it works...
  • storage, sizing / Sizing storage, How to do it..., How it works...
  • investing, in RAID / Investing in a RAID, Getting ready, How it works...
  • processor, selecting / Picking a processor, How it works...
  • memory usage / Making the most of memory, How to do it..., How it works...
  • memory speed / There's more...
  • nimble networking, exploring / Exploring nimble networking, Getting ready, How it works...
  • motherboards, managing / Managing motherboards, Getting ready, How it works...
  • chassis, selecting / Selecting a chassis, How it works...
  • SAN / Saddling up to a SAN, Getting ready, How it works...
  • server, tallying / Getting ready, How it works...
  • server, protecting / Protecting your eggs, How it works...
• hardware spreadsheet
  • producing, for tracking purchase needs / How to do it..., How it works...
• herd / Copying a few tables with Bucardo
• horizontal candidates
  • identifying / Identifying horizontal candidates, Getting ready, How it works..., See also
• Hot Standby
  • URL / See also
• HP
  • URL / See also
• hyperthreading
  • about / Hyperthreading

I

• -i flag
  • about / Getting ready
• init_shard_tables / How it works...
• Instagram
  • about / Creating a scalable nextval replacement
• install parameter / How it works...
• Intel Xeon CPUs
  • URL / See also
• invalidate-remote parameter / How it works...
• invalidate parameter / How it works...
• IO column / How it works...
• IOPS
  • about / Having enough IOPS
• iostat utility
  • current disk performance, evaluating with / Evaluating the current disk performance with iostat, How to do it..., How it works..., See also
• iotop command
  • sample output, obtaining from / How to do it..., How it works..., There's more...

K

• kernel tweaks
  • using / Applying bonus kernel tweaks, How it works...

L

• -l parameter / How it works..., How it works...
• -L parameter / There's more...
• latest keyword / How it works...
• layers
  • about / The stack
• Libre Office
  • URL / See also
• link aggregation
  • URL / See also
• Linux Documentation Project
  • URL / See also, See also
• Linux Standard Base (LSB) / There's more...
• Linux Standard Base specification
  • URL / See also
• list-backup parameter / How it works...
• list-files parameter / How it works...
• list tables parameter / How it works...
• live stack systems
  • switching / Switching live stack systems, How to do it..., How it works...
• local tables
  • foreign tables, transforming into / Transforming foreign tables into local tables, How it works..., There's more...
• Log-Shipping Standby Servers
  • URL / See also, See also
• logbsize option / How it works...
• logbufs option / How it works...
• logical shard
  • about / Talking to the right shard
• logical shard mapping
  • application data, selecting to / Choose an application data to logical shard mapping
• Londiste
  • setting up / Setting up Londiste, How to do it..., How it works...
  • tables, copying with / Copying a few tables with Londiste, How it works...
• londiste3 command-line utility / How it works...
• londiste3 utility
  • URL / See also
• Londiste documentation
  • URL / See also
• lvcreate command / There's more...
• lvdisplay command / How it works...
• LVM
  • about / Why LVM?, Getting started with the Linux Volume Manager, Getting ready
  • adding, to cluster management / Adding LVM to cluster management, How it works..., There's more...
• LVM documentation
  • URL / See also
• LVM snapshots
  • using / Using LVM snapshots, How to do it..., How it works..., See also
• lvremove command / How it works...

M

• --man parameter / How it works...
• --monitoring-history parameter / How it works...
• MailTo agent
  • about / How it works...
• maintenance_work_mem setting
  • about / How it works...
• make command / How it works...
• managed resource migration
  • performing / Performing a managed resource migration, How it works..., There's more...
• man command / There's more...
• man utility / See also
• master/slave mode, pgpool
  • configuring / Configuring pgpool for master/slave mode, How to do it..., How it works...
• master parameter / How it works...
• master register parameter / How it works...
• materialized view library
  • URL / See also
• materialized views
  • about / Transforming foreign tables into local tables
• max_client_conn setting / How it works...
• meta-disk keyword / How it works...
• migration
  • testing, outage used / Using an outage to test migration, How it works..., There's more...
• mkdir command / How it works...
• mkfs.xfs command / How it works...
• mklabel parameter / How it works...
• mkpart parameter / How it works...
• motherboards
  • managing / Managing motherboards, Getting ready, How it works...
• mount command / How it works..., How it works...

N

• -n parameter / How it works..., How it works..., How it works...
• Nagios
  • about / Installing and configuring Nagios
  • installing / Installing and configuring Nagios, How to do it..., There's more..., See also
  • configuring / Installing and configuring Nagios, How to do it..., There's more..., See also
  • configuring, to monitor database host / Configuring Nagios to monitor a database host, How to do it..., How it works..., There's more..., See also
  • enhancing, with check_mk / Enhancing Nagios with check_mk, How to do it..., How it works..., There's more...
• Nagios 3.0 Documentation
  • URL / See also
• Nagios object manual
  • URL / See also
• Nagios Quickstart Installation Guides
  • URL / See also
• Nagios Remote Plugin Executor (NRPE) / Getting ready
• NAS
  • about / How it works...
• NetApp
  • URL / See also
• network bond
  • examining / Examining /proc/net/bonding/bond0, How it works...
• network cards
  • research, saving / Save the research
• networking
  • example / A networking example
• network monitoring systems
  • comparison, URL / See also
• Network Operations Center (NOC) / Introduction
• nimble networking
  • exploring / Exploring nimble networking, Getting ready, How it works...
• noatime option / How it works...
• nodes
  • swapping, with repmgr / Swapping active nodes with repmgr, How to do it..., How it works..., See also
• nodiratime option / How it works...
• notify setting
  • about / How it works...
• number of IOPS, figuring out
  • working example / A working example
  • concessions, making / Making concessions

O

• $OPS variable / How it works...
• OLAP
  • about / How to do it...
• OLTP
  • about / How to do it...
• OmniPITR
  • installing / Installing and configuring OmniPITR, How it works...
  • configuring / Installing and configuring OmniPITR, How it works...
  • installation, URL / See also
  • setup, URL / See also
  • WAL files, managing with / Managing WAL files with OmniPITR, How to do it..., How it works..., There's more...
• omnipitr-archive
  • URL / See also
• omnipitr-restore command / There's more...
• onetimecopy parameter / How it works...
• on keyword / How it works...
• Open Office
  • URL / See also
• operating system
  • disk cache, restoring to / How to do it..., How it works...
• outage
  • used, to test migration / Using an outage to test migration, How it works..., There's more...

P

• /proc/meminfo
  • interpreting / Interpreting /proc/meminfo, How it works..., See also
  • URL / See also
• Pacemaker
  • about / Introduction, Before we begin...
  • installing / How to do it...
• Password File
  • URL / See also
• password option
  • about / How it works...
• pcp_attach_node command / How it works...
• pcp_detach_node command / How it works...
• pcp_recovery_node command / How it works...
• Penguin Computing
  • URL / See also
• pg-clone
  • promoting / How to do it...
• pg-primary server
  • about / How it works...
• pgAgent
  • URL / See also
• pgbench command / How it works...
• PgBouncer
  • about / Installing PgBouncer
  • installing / Installing PgBouncer, Getting ready, How to do it..., How it works...
  • configuring / Configuring PgBouncer safely, How to do it..., How it works...
  • prepared statements / Problems with prepared statements
  • connecting to / Connecting to PgBouncer, Getting ready
  • server connections, listing / Listing PgBouncer server connections
  • client connections, listing / Listing PgBouncer client connections, How it works...
  • pool health, evaluating / Evaluating PgBouncer pool health, Getting ready, How it works..., There's more...
  • combining, with pgpool / Combining the power of PgBouncer and pgpool, How it works...
• pgFincore
  • URL / See also
• pgpool
  • about / Installing pgpool
  • installing / How to do it..., How it works...
  • configuring, for master/slave mode / Configuring pgpool for master/slave mode, How to do it..., How it works..., There's more...
  • write query, testing / Testing a write query on pgpool, How to do it..., How it works...
  • active nodes, swapping / Swapping active nodes with pgpool, How to do it..., There's more...
• pgpool_recovery extension
  • installing / There's more...
• pgstattuple
  • using / Use pgstattuple
  • URL / Use pgstattuple
• pgtune
  • URL / See also
• PGXN
  • about / Getting ready
  • URL / Getting ready
  • installing / Getting ready
• pg_backend_pid function / How it works...
• pg_basebackup
  • URL / Upgrading to asynchronous replication
• pg_basebackup command / Setting up a hot standby, How it works...
• pg_basebackup tool
  • about / There's more...
• pg_basebackup Utility
  • URL / See also
• pg_basebackup utility
  • about / Cloning a database with walctl
• pg_class
  • URL / See also
• pg_foreign_server
  • URL / Mapping a remote user
• pg_receivexlog command
  • about / Faking replication with pg_receivexlog
• pg_receivexlog utility
  • URL / See also, See also
• pg_settings view
  • URL / See also
• pg_standby
  • URL / Upgrading to asynchronous replication
• pg_start_backup() function / There's more...
• pg_stat_activity view
  • checking / Checking the pg_stat_activity view, How it works..., See also
  • URL / See also
• pg_stat_statements
  • URL / See also
• pg_stat_statements view
  • checking / Checking the pg_stat_statements view, How to do it..., How it works...
  • stats, resetting / Reset the stats
  • URL / See also
• pg_total_relation_size function / How it works...
• pg_upgrade
  • about / There's more...
• pg_user_mapping
  • URL / Creating a foreign table
• physical shard
  • about / Talking to the right shard
• pid field / How it works...
• PL/Java
  • URL / See also
• PL/Perl
  • URL / See also
• PL/pgSQL
  • URL / See also
• PL/PHP
  • URL / See also
• PL/Python
  • URL / See also
• PL/Ruby
  • URL / See also
• Point In Time Recovery (PITR) / How it works..., Securing the WAL stream
• pooling resources
  • PgBouncer / Installing PgBouncer
  • pgpool / Installing pgpool
• pool_mode configuration setting
  • session / What about pool_mode?
  • transaction / What about pool_mode?
  • statement / What about pool_mode?
• PostgreSQL
  • adding, to cluster management / Adding PostgreSQL to cluster management, How it works..., There's more...
• PostgreSQL 9.0 High Performance
  • URL / See also
• PostgreSQL 9.2 / How it works...
• PostgreSQL database
  • configuration / Configuration – getting it right the first time, How to do it..., How it works..., See also
• PostgreSQL documentation
  • URL / See also
• PostgreSQL hot standby
  • building / Setting up a hot standby, How to do it..., How it works...
  • URL / See also
• PostgreSQL Plugin
  • URL / See also
• PostgreSQL repository
  • adding, URL / Getting ready
• PostgreSQL Server Configuration
  • URL / See also
• PostgreSQL settings
  • managing / Configuration – managing scary settings, How to do it..., How it works..., More information
  • distinct settings / Distinct settings
• PostgreSQL software
  • upgrading / How to do it...
• postgres_fdw
  • URL / Mapping a remote user
• Primary server / Adding block-level replication
• primitives
  • about / How it works...
• processor
  • selecting / Picking a processor, How it works...
• procpid field / How it works...
• psycopg2
  • installing / Getting ready
• Python Package Index | pip
  • URL / See also

Q

• query
  • foreign table, using in / Using a foreign table in a query, How to do it..., How it works..., There's more...
• query column / How it works...
• query_start field / How it works...

R

• --remote-ssh-command parameter / How it works...
• -r option / How it works...
• r/s field / How it works...
• RAID
  • about / Investing in a RAID
  • investing in / Investing in a RAID, Getting ready, How it works...
  • URL / There's more...
• RAID-1
  • about / Bulletproofing with synchronous replication
• RAID 5 / How it works...
• RAID 6 / How it works...
• RAID controllers / There's more...
• ra meta command / How it works..., How it works...
• Red Hat Enterprise Linux (RHEL) / Why XFS?
  • about / Getting ready
  • URL / Getting ready
• Red Hat systems
  • URL / There's more...
• redundancy
  • about / Planning for redundancy, Remember redundancy
  • planning for / Getting ready, How to do it..., How it works...
• REFRESH MATERIALIZED VIEW
  • URL / See also
• related actions
  • combining / Combining and ordering related actions, How it works...
  • ordering / Combining and ordering related actions, How it works...
• remote user
  • mapping / Mapping a remote user, Getting ready, How it works..., There's more...
• replication resource requirements
  • determining / Deciding what to copy, How it works...
• repmgr
  • installing / Installing and configuring repmgr, Getting ready, How to do it..., How it works...
  • configuring / Installing and configuring repmgr, Getting ready, How to do it..., How it works...
  • URL / See also
  • database, cloning with / Cloning a database with repmgr, How to do it..., How it works..., See also
  • nodes, swapping with / Swapping active nodes with repmgr, How to do it..., How it works..., See also
• repmgr command / How it works..., How it works..., There's more...
• repmgr documentation
  • URL / See also
• RepoForge
  • URL / See also
• RepoForge library / Getting ready
• RepoForge package
  • URL / Getting ready
• reserve_pool_size setting / How it works...
• roles / How it works...
• round-trip-time (RTT) / Examining /proc/net/bonding/bond0
• rows column / How it works...
• RPM
  • URL / Getting ready
• rsync / Getting ready
• rsync command / How it works..., How it works...
• r_await field / How it works...

S

• -s flag
  • about / Getting ready
• -s parameter / How it works...
• sample output
  • obtaining, from iotop command / Tracking I/O-heavy processes with iotop, How it works..., There's more...
• SAN
  • about / How it works..., Saddling up to a SAN, Introduction
• sar utility
  • past performance, viewing with / Viewing past performance with sar, How to do it..., How it works...
• scalable nextval replacement
  • creating / Creating a scalable nextval replacement, How to do it..., How it works...
• sched_autogroup_enabled setting
  • about / How it works...
• sched_migration_cost setting
  • about / How it works...
• Secondary server / Adding block-level replication
• second LVM layer
  • creating / Incorporating the second LVM layer, How it works...
• server connections, PgBouncer
  • listing / Listing PgBouncer server connections
  • user / How it works...
  • database / How it works...
  • state / How it works...
  • connect_time / How it works...
  • request_time / How it works...
• Service Level Agreement (SLA) / Determining acceptable losses
• setenforce utility / How it works...
• SETOF modifier
  • about / How it works...
• set parameter / How it works...
• shard
  • moving, to another server / Moving a shard to another server, How to do it..., How it works..., There's more...
• sharding API
  • building / Building a sharding API, How it works..., There's more...
• Shard Manager
  • URL / There's more...
• show-backup parameter / How it works...
• SHOW POOLS query
  • cl_active column / How it works...
  • cl_waiting column / How it works...
  • sv_active column / How it works...
  • sv_idle column / How it works...
  • maxwait column / How it works...
• SHOW STATS query
  • total_requests / How it works...
  • total_received / How it works...
  • total_sent / How it works...
  • total_query_time / How it works...
  • avg_req / How it works...
  • avg_recv / How it works...
  • avg_sent / How it works...
  • avg_query / How it works...
• SkyTools
  • URL / Getting ready
• slonik tool / How it works...
• slon utility / How it works...
• Slony
  • setting up / Setting up Slony, How to do it..., How it works...
  • URL / Getting ready
  • tables, copying with / Copying a few tables with Slony, How to do it..., How it works..., There's more...
• Slony documentation
  • URL / See also
• software
  • monitoring / Figuring out what to monitor, How to do it..., How it works...
• software upgrades
  • managing / Managing software upgrades, Getting ready, How to do it..., How it works...
• source parameter / How it works...
• ssh-copy-id command / How it works..., How it works...
• ssh command / How it works...
• ssh_command / How it works...
• stack
  • about / The stack
  • layers / The stack
  • systems, preparing for / Preparing systems for the stack, Getting ready, How it works..., There's more...
• Standby Server Settings
  • URL / See also
• startup services
  • preparing / Preparing startup services, How it works..., There's more...
• state field / How it works...
• static table
  • creating / How to do it...
• Statistics Collector
  • URL / See also, See also, See also
• statistics packages
  • installing / Installing common statistics packages, How it works...
• stats
  • resetting / Reset stats
• status parameter / How it works...
• STONITH
  • about / There's more...
  • disabling / How it works...
• storage
  • sizing / Sizing storage, How to do it..., How it works...
• storage, sizing
  • real world example / Real-world example
  • numbers, adjusting / Adjusting the numbers
  • spreadsheet, incorporating / Incorporate the spreadsheet
• strace utility
  • debugging with / Debugging with strace, How to do it..., How it works..., There's more...
• Streaming Replication
  • URL / See also
• synchronous replication
  • working with / Bulletproofing with synchronous replication, How it works..., There's more...
• System Administration Functions
  • URL / See also, See also
• system migrations
  • managing / Managing system migrations, Getting ready, How it works..., There's more...
• systems
  • preparing, for stack / Preparing systems for the stack, Getting ready, How it works..., There's more...
• system troubleshooting
  • URL / See also

T

• -t parameter / How it works..., How it works...
• table
  • building, to map logical shards to their physical locations / How to do it..., How it works...
• tables
  • identifying / Identifying important tables
  • copying, with Slony / Copying a few tables with Slony, How to do it..., How it works..., There's more...
  • copying, with Bucardo / Copying a few tables with Bucardo, How it works...
  • copying, with Londiste / Copying a few tables with Londiste, How to do it..., How it works...
• targetdb parameter / How it works...
• tcpkill command / How it works...
• The Oversize Attribute Storage Technique (TOAST) / How it works...
• The Statistics Collector
  • URL / See also
• third-party tools
  • using / Deciding when to use third-party tools, Getting ready, How it works...
• TID column / How it works...
• Tom's Hardware
  • URL / See also
• top command / Tracking I/O-heavy processes with iotop
• total_time column / How it works...
• TPS
  • about / How it works...
• transactions per second (tps) / How it works...
• triage
  • performing / Performing triage, How it works..., There's more...
• Turbo Mode
  • about / Turbo Boost

U

• %util field / How it works...
• -u parameter / How it works...
• udev filesystem / How it works...
• uptime command / How it works...
• username field / How it works...

V

• $? variable / There's more...
• -V parameter / There's more...
• VCE
  • URL / See also
• verify-alg setting / How it works...
• verify parameter / How it works...
• virtual IP
  • creating / Exploring the magic of virtual IPs, How it works...
  • moving / Exploring the magic of virtual IPs, How it works...
  • adding, to hide cluster / Adding a virtual IP to hide the cluster, How it works...
• volume group
  • about / How it works...

W

• w/s field / How it works...
• waiting field / How it works...
• WAL Configuration
  • URL / See also
• walctl
  • installing / Installing and configuring walctl, Getting ready, How to do it..., How it works...
  • configuring / Installing and configuring walctl, Getting ready, How to do it..., How it works...
  • URL / Getting ready
  • database, cloning with / Cloning a database with walctl, How it works...
  • WAL files, managing with / Managing WAL files with walctl, How it works...
• walctl documentation
  • URL / See also
• walctl_clone command / Cloning a database with walctl, How it works...
• walctl_clone tool
  • about / Cloning a database with walctl
• walctl_pull / Managing WAL files with walctl
• walctl_push / Managing WAL files with walctl
• walctl_setup utility
  • about / How it works...
• WAL data
  • saving / Faking replication with pg_receivexlog, How to do it..., How it works...
• WAL files
  • managing, with OmniPITR / Managing WAL files with OmniPITR, How to do it..., How it works..., There's more...
  • managing, with walctl / Managing WAL files with walctl, There's more...
• WAL stream
  • securing / There's more..., Copy WAL files more easily, See also, Securing the WAL stream, Getting ready, How it works..., There's more...
• wal_keep_segments parameter / How it works...
• watch utility
  • about / There's more...
• web administration tool (WATO) / How it works...
• Whiptail
  • URL / See also
• worker parameter / How it works...
• work_mem setting
  • about / How it works...
• Write Ahead Log
  • URL / See also
• Write Ahead Log (WAL) / Logging checkpoints properly, Securing the WAL stream
• write_graphite Plugin
  • URL / See also
• w_await field / How it works...

X

• xact_start field / How it works...
• XFS
  • about / Why XFS?
  • adding, to cluster management / Adding XFS to cluster management, How it works...
• XFS FAQ
  • URL / See also
• XFS filesystem
  • formatting / Formatting an XFS filesystem, How it works...
  • maintaining / Maintaining an XFS filesystem, How it works..., There's more...
• XFS performance
  • improving / Tweaking XFS performance, How it works..., See also
• xfs_db command / There's more...
• xfs_db utility / How it works...
• xfs_fsr command / How it works...

Y

• yum command / Getting ready