PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance - Helion
ebook
Autor: Hannu Krosing, Simon Riggs, PostgreSQLTytuł oryginału: PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance.
ISBN: 9781849516433
stron: 88, Format: ebook
Data wydania: 2011-05-13
Księgarnia: Helion
Cena książki: 58,49 zł (poprzednio: 64,99 zł)
Oszczędzasz: 10% (-6,50 zł)
Osoby które kupowały "PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance", wybierały także:
- Jak zhakowa 125,00 zł, (10,00 zł -92%)
- Blockchain i kryptowaluty. Kurs video. Zdecentralizowane finanse od podstaw 118,90 zł, (11,89 zł -90%)
- Web scraping. Kurs video. Zautomatyzowane pozyskiwanie danych z sieci 126,36 zł, (13,90 zł -89%)
- GraphQL. Kurs video. Buduj nowoczesne API w Pythonie 153,64 zł, (16,90 zł -89%)
- Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
Spis treści
PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance eBook -- spis treści
- PostgreSQL 9 Administration Cookbook: LITE
- Table of Contents
- PostgreSQL 9 Administration Cookbook: LITE
- Credits
- About the Authors
- About the Reviewers
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code for this book
- Errata
- Piracy
- Questions
- 1. Configuration
- Introduction
- Reading the Fine Manual (RTFM)
- How to do it...
- How it works...
- Theres more...
- Planning a new database
- Getting ready
- How to do it...
- How it works...
- There's more...
- Changing parameters in your programs
- How to do it...
- How it works...
- There's more...
- What are the current configuration settings?
- How to do it...
- How it works...
- Which parameters are at non-default settings?
- How to do it...
- How it works...
- There's more...
- Who set that?
- Updating the parameter file
- Getting ready
- How to do it...
- How it works...
- There's more...
- Setting parameters for particular groups of users
- How to do it...
- How it works...
- Basic server configuration checklist
- Getting ready
- How to do it...
- Adding an external module to PostgreSQL
- Getting ready
- How to do it...
- How it works...
- Running server in power saving mode
- Getting ready
- How to do it...
- How it works...
- 2. Monitoring and Diagnosis
- Introduction
- Monitoring is important
- Providing PostgreSQL information to monitoring tools
- Where to find more information about generic monitoring tools
- Realtime view using pgAdmin
- Is the user connected?
- Getting ready
- How to do it...
- How it works...
- There's more...
- What if I want to know "is that computer connected?"
- What are they running?
- Getting ready
- How to do it...
- How it works...
- There's more...
- How to catch queries which runs only for a few milliseconds
- How to watch longest queries
- Watching queries from ps
- See also
- Are they active or blocked?
- Getting ready
- How to do it...
- How it works...
- There's more...
- No need for "= true"
- This shows only queries waiting on locks
- Who is blocking them?
- Getting ready
- How to do it...
- How it works...
- Killing a specific session
- Getting ready
- How to do it...
- How it works...
- There's more...
- Try to cancel the query first
- If the backend won't terminate
- Use statement timeout to clean up queries which take too long
- Killing "Idle in transaction" queries
- You can also kill the backend from command line
- Resolving an in-doubt prepared transaction
- Is anybody using a specific table?
- Getting ready
- How to do it...
- How it works...
- There's more...
- The quick and dirty way
- Collecting daily usage statistics
- When did anybody last use it?
- Getting ready
- How to do it...
- Looking at file dates
- How it works...
- There's more...
- There may be last-use information in future version of PostgreSQL
- How much disk space is used by temporary data?
- Getting ready
- How to do it...
- When temp_tablespaces has one or more tablespaces
- When temp_tablespaces is empty
- How it works...
- There's more...
- Finding out if temporary file is in use any more
- Logging temporary file usage
- Why are my queries slowing down?
- Getting ready
- How to do it...
- How it works...
- There's more...
- Do the queries return significantly more data than earlier?
- Do the queries also run slowly when run alone?
- Is the second run of same query also slow?
- See also
- Investigating and reporting a bug
- Getting ready
- How to do it...
- How it works...
- See also
- The official PostgreSQL bug/problem reporting guides
- Producing a daily summary of logfile errors
- Getting ready
- How to do it...
- How it works...
- There's more...
- Writing your own log processor
- See also
- Introduction
- 3. Regular Maintenance
- Introduction
- Controlling automatic database maintenance
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Avoiding auto freezing and page corruptions
- Getting ready
- How to do it...
- Avoiding transaction wraparound
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Removing old prepared transactions
- Getting ready
- How to do it...
- How it works...
- There's more...
- Actions for heavy users of temporary tables
- How to do it...
- How it works...
- Identifying and fixing bloated tables and indexes
- How to do it...
- How it works...
- There's more...
- Maintaining indexes
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Locating the unused indexes
- How to do it...
- How it works...
- See also
- Carefully removing unwanted indexes
- How to do it...
- How it works...
- Planning maintenance
- How to do it...
- How it works...
- Index