Index

As this ebook edition doesn't have fixed pagination, the page numbers below are hyperlinked for reference only, based on the printed edition of this book.

Symbols

.pgpass

using 350, 351

A

actual time block 210

adminpack module

using 426-428

advisory locks

utilizing 38, 39

aggregates

efficiency, improving 142-144

hypothetical aggregates, writing 144-146

support, adding for parallel queries 141, 142

writing 137

anonymous code blocks

using 263, 264

asynchronous replication

checking, to ensure availability 380-383

conflicts, managing 385, 386

failovers, performing 383

halting 380

making, reliable 387

resuming 380

setting up 376

set up, performing 377-379

set up, security improving 379

timelines 384

autovacuum

configuring 41

available extensions

checking 423- 426

B

backups

passwords and connection information, passing 349

performing 347, 348

performing...