Cargando…
PostgreSQL 10 High Performance : Expert techniques for query optimization, high availability, and efficient database maintenance.
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 availabi...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2018.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Mi 4500 | ||
|---|---|---|---|
| 001 | EBSCO_on1035516842 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 180512s2018 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d YDX |d MERUC |d IDB |d CHVBK |d OCLCO |d OCLCF |d NLE |d TEFOD |d OCLCQ |d LVT |d UKAHL |d C6I |d OCLCQ |d N$T |d K6U |d OCLCO |d OCLCQ | ||
| 019 | |a 1035394311 |a 1040682746 | ||
| 020 | |a 9781788472456 |q (electronic bk.) | ||
| 020 | |a 1788472454 |q (electronic bk.) | ||
| 029 | 1 | |a CHNEW |b 001016275 | |
| 029 | 1 | |a CHVBK |b 523132670 | |
| 029 | 1 | |a AU@ |b 000067107704 | |
| 029 | 1 | |a AU@ |b 000067383796 | |
| 035 | |a (OCoLC)1035516842 |z (OCoLC)1035394311 |z (OCoLC)1040682746 | ||
| 037 | |a FA673B1A-8F1F-40A7-8799-9F0DD7D51827 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.D3 |b .A364 2018eb | |
| 082 | 0 | 4 | |a 005.74 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Pirozzi, Enrico. | |
| 245 | 1 | 0 | |a PostgreSQL 10 High Performance : |b Expert techniques for query optimization, high availability, and efficient database maintenance. |
| 260 | |a Birmingham : |b Packt Publishing, |c 2018. | ||
| 300 | |a 1 online resource (499 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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++ | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 500 | |a Database disk layout. | ||
| 520 | |a 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. | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a Servers. |2 bicssc | |
| 650 | 7 | |a Databases. |2 bicssc | |
| 650 | 7 | |a Database design & theory. |2 bicssc | |
| 650 | 7 | |a Information architecture. |2 bicssc | |
| 650 | 7 | |a Computers |x Data Modeling & Design. |2 bisacsh | |
| 650 | 7 | |a Computers |x Database Management |x General. |2 bisacsh | |
| 650 | 7 | |a Relational databases. |2 fast |0 (OCoLC)fst01093575 | |
| 776 | 0 | 8 | |i Print version: |a Pirozzi, Enrico. |t PostgreSQL 10 High Performance : Expert techniques for query optimization, high availability, and efficient database maintenance. |d Birmingham : Packt Publishing, ©2018 |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1804694 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n BDZ0036705480 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL5379701 | ||
| 938 | |a YBP Library Services |b YANK |n 15343694 | ||
| 938 | |a EBSCOhost |b EBSC |n 1804694 | ||
| 994 | |a 92 |b IZTAP | ||