首頁 > 計算機(jī)網(wǎng)絡(luò) >
專用軟件
> PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance最新章節(jié)目錄
舉報 
會員
PostgreSQL 9 Administration Cookbook LITE: Configuration, Monitoring and Maintenance
最新章節(jié)：
Index
Learn?Changeparametersinyoursystemandfindouthowthatwillaffecttherestofyourdatabase?SummariestohelpDBAswithexperienceofotherdatabasesystems?Monitoryouruserssothatyoucanseewhethertheyareconnected,whattheyarerunning,andwhethertheiraccounthasbecomeblocked?Identifytemporarydataandtheeffectthatithasonyoursystem?Advancedtechnicaltipsandscriptsforexperiencedusers?Controltheautomaticdatabasemaintenanceprogram?Identifyandfixbloatedtablesandindexes?HowandwhentoVACUUMyourdatabasesAboutPostgreSQLisapowerful,opensource,enterprisedatabase.ThisPostgreSQL9AdministrationCookbookLITEbookdescribeskeyaspectsofthePostgreSQLopensourcedatabasesystem.ThebookwillhelpasysadminorDBAwithkeyadministrationissuesinPostgreSQL:configuration,monitoringanddiagnosis,andsettingupregularmaintenance.Thishands-onguidewillassistdevelopersworkingonlivedatabasessupportingweborenterprisesoftwareapplications.Tofindoutmoreaboutupgradingtothefulledition,visitwww.packtpub.com/lite-editionsandlogintoyouraccountforoffersandhelp.Ifyoudon’thaveanaccountonPacktPub.com,visittodayandsetoneup!Features?Administerandmaintainahealthydatabase?ConfigureyourPostgreSQLdatabasetoyourneeds?Monitoryourdatabaseandlearntodiagnoseanyproblems?PartofPackt'sCookbookseries:Eachrecipeisacarefullyorganizedsequenceofinstructionstocompletethetaskasefficientlyaspossible
目錄(50章)
倒序
- 封面
- 版權(quán)信息
- 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
- Chapter 1. Configuration
- Introduction
- Reading the Fine Manual (RTFM)
- Planning a new database
- Changing parameters in your programs
- What are the current configuration settings?
- Which parameters are at non-default settings?
- Updating the parameter file
- Setting parameters for particular groups of users
- Basic server configuration checklist
- Adding an external module to PostgreSQL
- Chapter 2. Monitoring and Diagnosis
- Introduction
- Is the user connected?
- What are they running?
- Are they active or blocked?
- Who is blocking them?
- Killing a specific session
- Resolving an in-doubt prepared transaction
- Is anybody using a specific table?
- When did anybody last use it?
- How much disk space is used by temporary data?
- Why are my queries slowing down?
- Investigating and reporting a bug
- Producing a daily summary of logfile errors
- Chapter 3. Regular Maintenance
- Introduction
- Controlling automatic database maintenance
- Avoiding auto freezing and page corruptions
- Avoiding transaction wraparound
- Removing old prepared transactions
- Actions for heavy users of temporary tables
- Identifying and fixing bloated tables and indexes
- Maintaining indexes
- Locating the unused indexes
- Carefully removing unwanted indexes
- Planning maintenance
- Index 更新時間：2021-04-02 19:42:47
推薦閱讀
- Instant Vert.x
- Object/Oriented Programming in ColdFusion
- Word-Excel-PowerPoint 2010三合一從新手到高手（超值版）
- Photoshop CS6 互聯(lián)網(wǎng)應(yīng)用設(shè)計教程
- 中文版Premiere Pro CC入門教程
- 中文版Photoshop 2020基礎(chǔ)教程
- 中文版CorelDRAW X8基礎(chǔ)培訓(xùn)教程（全彩版）
- AI繪畫實戰(zhàn)：Midjourney從新手到高手
- Photoshop CC摳圖＋修圖＋調(diào)色＋合成＋特效實戰(zhàn)視頻教程
- CorelDRAW X6核心應(yīng)用案例教程（全彩慕課版）
- Flash CC動畫制作與應(yīng)用（第3版）
- AI設(shè)計時代：Midjourney實戰(zhàn)應(yīng)用手冊
- 精通AutoCAD 2013機(jī)械設(shè)計
- jQuery UI 1.6: The User Interface Library for jQuery
- 用友(T3)會計信息化軟件考前12小時
- AutoCAD 2018中文版從入門到精通（標(biāo)準(zhǔn)版）
- AutoCAD計算機(jī)輔助設(shè)計標(biāo)準(zhǔn)教程（慕課版）
- Python Multimedia
- Photoshop CS5中文版完全學(xué)習(xí)手冊（超值版）
- Photoshop CS5圖形圖像處理任務(wù)驅(qū)動式教程 第2版
- Joomla! VirtueMart 1.1 Theme and Template Design
- 老郵差 Photoshop數(shù)碼照片處理技法 色彩篇（修訂版）
- Photoshop CC新媒體圖形圖像設(shè)計與制作（全彩慕課版·第2版）
- 剪映短視頻制作完全自學(xué)一本通（手機(jī)版+電腦版）
- 中文版Flash CS6實用教程
- AutoCAD 2020 從入門到精通 實戰(zhàn)版
- MATLAB神經(jīng)網(wǎng)絡(luò)超級學(xué)習(xí)手冊
- 零基礎(chǔ)學(xué)Photoshop+Illustrator平面設(shè)計（全視頻教學(xué)版）
- 中文版CorelDRAW X6實用教程（第2版）
- Rhomobile Beginner's Guide
