عنوان
پدید آورنده
موضوع
رده
QA76.9.D3 .A364 2018eb
QA76
.
9
.
D3
.
A364
2018eb
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
1788472454
(Number (ISBN
9781788472456
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
PostgreSQL 10 High Performance :
General Material Designation
[Book]
Other Title Information
Expert techniques for query optimization, high availability, and efficient database maintenance.
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Birmingham :
Name of Publisher, Distributor, etc.
Packt Publishing,
Date of Publication, Distribution, etc.
2018.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
1 online resource (499 pages)
GENERAL NOTES
Text of Note
Database disk layout.
CONTENTS NOTE
Text of Note
Cover; Title Page; Copyright and Credits; Dedication; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: PostgreSQL Versions; Performance of historical PostgreSQL releases; Choosing a version to deploy; Upgrading to a newer major version; Upgrades to PostgreSQL 8.3+ from earlier ones; Minor version upgrades; Migrating from PostgreSQL 9.x to 10.x -- a new way to work; PostgreSQL or another database?; PostgreSQL 10.x and NoSQL; PostgreSQL as HUB; PostgreSQL tools; PostgreSQL contrib; Finding contrib modules on your system; Installing a contrib module from source.
Text of Note
Bonnie++ 2.0Bonnie++ ZCAV; sysbench; pgbench; Seek rate; Removing test files; fsync commit rate; Complicated disk benchmarks; Sample disk results; Disk performance expectations; Sources of slow disk and array performance; Summary; Chapter 4: Disk Setup; Maximum filesystem sizes; Filesystem crash recovery; Journaling filesystems; Linux filesystems; ext2; ext3; ext4; XFS; Benchmarks; Other Linux filesystems; Write barriers; Drive support for barriers; Filesystem support for barriers; General Linux filesystem tuning; Read-ahead; File access times; Read caching and swapping; Write cache sizing.
Text of Note
I/O scheduler elevatorSolaris and FreeBSD filesystems; Solaris UFS; FreeBSD UFS2; ZFS; Windows filesystems; FAT32; NTFS; Adjusting mounting behavior; Disk layout for PostgreSQL; Symbolic links; Tablespaces; Database directory tree; Temporary files; Disk arrays, RAID, and disk layout; Disk layout guidelines; Summary; Chapter 5: Memory for Database Caching; Memory units in postgresql.conf; Increasing Unix shared memory parameters for larger buffer sizes; Kernel semaphores; Estimating shared memory allocation; Inspecting the database cache; Installing pg_buffercache into a database.
Text of Note
Performance impact of write-through cachingSummary; Chapter 3: Database Hardware Benchmarking; CPU and memory benchmarking; Memtest86+; STREAM memory testing; STREAM and Intel versus AMD; CPU benchmarking; Sources of slow memory and processors; Physical disk performance; Random access and input/outputs per second; Sequential access and ZCAV; Short stroking; Commit rate; PostgreSQL test_fsync; INSERT rate; Windows commit rate; Disk benchmarking tools; HD Tune; Short stroking tests; IOPS; Unpredictable performance and Windows; Disk throughput in case of sequential read and write; Bonnie++
Text of Note
Using a contrib modulepgFoundry; PGXN; Additional PostgreSQL-related software; PostgreSQL application scaling life cycle; Performance tuning as a practice; Summary; Chapter 2: Database Hardware; Balancing hardware spending; CPUs; Memory; Disks; RAID; Drive error handling; Hard drive reliability studies; Drive firmware and RAID; SSDs; Disk controllers; Hardware and software RAID; Recommended disk controllers; Attached storage -- SAN and NAS; Reliable controller and disk setup; Write-back caches; Sources of write-back caching; Disk controller monitoring; Disabling drive write caches.
0
8
8
8
8
SUMMARY OR ABSTRACT
Text of Note
PostgreSQL is increasingly utilized in all kind of applications, starting from desktop to web and mobile applications. In this book, you will find the best ways to design, monitor and maintain your PostgreSQL solution, with suggestions and tips for high performance, troubleshooting and high availability.
ACQUISITION INFORMATION NOTE
Source for Acquisition/Subscription Address
OverDrive, Inc.
Stock Number
FA673B1A-8F1F-40A7-8799-9F0DD7D51827
OTHER EDITION IN ANOTHER MEDIUM
Title
PostgreSQL 10 High Performance : Expert techniques for query optimization, high availability, and efficient database maintenance.
TOPICAL NAME USED AS SUBJECT
Relational databases.
Computers-- Data Modeling & Design.
Computers-- Database Management-- General.
Database design & theory.
Databases.
Information architecture.
Relational databases.
Servers.
DEWEY DECIMAL CLASSIFICATION
Number
005
.
74
Edition
23
LIBRARY OF CONGRESS CLASSIFICATION
Class number
QA76
.
9
.
D3
Book number
.
A364
2018eb
PERSONAL NAME - PRIMARY RESPONSIBILITY
Pirozzi, Enrico.
ORIGINATING SOURCE
Date of Transaction
20200823060349.0
Cataloguing Rules (Descriptive Conventions))
pn
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
