Postgres
Consulting
Reference
Materials
These
pages contain brief descriptions of materials both at our site and at
others which might be considered "citations" pertaining to Postgres
/ PostgreSql. We hope you find these materials informative and interesting.
Non-Postgres-specific
reference materials are found here.
Postgres
/ PostgreSql Reference Materials Available Here:
- Community
Here find links to the Postgres community. We have participated in
well over 90% of all Bay Area San Francisco Postgres Local User Group
(SFPUG) meetings since 2005 - come join us at the next meeting!
- Definition
of Terms Here find a glossary containing definitions of some of
the terminology used by the Postgres community.
- Key
Topics Here you'll find a reasonably comprehensive list of the
things pertaining to the care and feeding of Postgres installations.
Postgres
/ PostgreSql Community
We are
active participants in the Postgres community, most notably in the
San Francisco Bay Area. We encourage ALL interested parties to join
the community.
Of course,
the official Postgres web site has a community page, here,
but we would like to emphasize the benefits of community. Please join
us in connecting with fellow Postgres Users at the San Francisco Postgres
User's Group meetings. Find
them here.
Postgres
/ PostgreSql Related Terms and their Definitions
The
glossary section is large enough to warrant its own page - please
find it here.
Postgres
/ PostgreSql Documentation
The
following links go back to the
official Postgres site and are provided here only as a matter
of convenience:
| Release |
Online Version |
Downloadable Version |
| 9.1 |
|
- Comprehensive Manual: A4
PDF (8.2 MB)
- Comprehensive Manual: US
PDF (8.2 MB)
|
| 9.0 |
|
- Comprehensive Manual: A4
PDF (7.1 MB)
- Comprehensive Manual: US
PDF (7.2 MB)
|
| 8.4 |
|
|
| 8.3 |
|
|
| 8.2 |
|
- Comprehensive Manual: A4
PDF (14.1 MB)
- Comprehensive Manual: US
PDF (14.1 MB)
|
Note
that there is a manual archive for documentation for older releases.
You can find it here.
Postgres
/ PostgreSql Key Topics
The
following is provided as a basic outline of what one needs to know
as it pertains to the care and feeding of Postgres and its applications.
We created the following by capturing the basic outlines of our own
internal materials we use to help guide our consultants to success,
including our Consultant's Handbook and various outlines we use as
a part of standardized services, such as Database
Health Report.
First,
the big picture:
- Hardware
configuration choices
-
Operating
System configuration choices (including file systems)
-
RDBMS
configuration choices
-
Server
Configuration
-
Maintenance
-
Application
Design choices
-
Overview
of Performance Monitoring
-
Database
Implementation choices
-
Indicies
-
Partitioning
-
Table
Spaces
-
Query
Tuning
- Ordered
list of Queries Of Concern
- Suggestions
for addressing Queries Of Concern
Now,
some detail:
-
Database
Administration with Postgres
- Authorization
of Users
- Client
to Server Connectivity
- Backup
and Restoration Operations
- Data
Dumps - the pg_dump utility
- Operating
System-based Backups
- Continuous
Archiving and Point-In-Time Recovery (PITR)
- Routine
Maintenance Tasks
- Avoiding
Disk Full
- Vacuuming
and disk space recovery
- Updating
planner statistics
- Preventing
transaction ID wraparound failures
- Routine
Reindexing
- Logfile
"maintenance"
- Clusters,
Databases, Schemas, Tables, and Indices
- Schemas
- Where
data is stored: Tablespaces
- Creation
of Databases
- Creation
of Tables
- Creation
of Indices
-
Application
Design and Performance
- Referential
Integrity Enforcement
- Populating
Tables
- Table
Partitioning
- Types
of Partitions
- Implementing
Partitioning
- Partition
Maintenance Considerations
- Partition
Constraint Exclusion
- Partition
Caveats
- Concurrency
- Transaction
Isolation
- Explicit
Locking
- Data
Consistency Checks
- Locking
& Indexes
-
Performance
Tuning
- Observation
- Postgres
Processes
- The
Statistics Collector
- Locks
- Dynamic
Tracing
- Disk
Utilization
- Usage
Patterns
- Application
Tuning
- Writing
"Optimal" Queries
- Query
Plans
- Statistics
used in generating Query Plans
- Server
Tuning
- Hardware
Tuning
- Sync
- DMA
- Direct Memory Access
-
Troubleshooting
|
