Cargando…
PostgreSQL 9.0 High Performance.
Accelerate your PostgreSQL system.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2010.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Mu 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn796383595 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 121121s2010 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d OCLCQ |d DEBSZ |d OCLCQ |d ZCU |d MERUC |d ICG |d OCLCO |d OCLCF |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d WYU |d DKC |d AU@ |d OCLCQ |d OCLCO |d OCLCQ |d TXI |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 020 | |a 9781849510318 | ||
| 020 | |a 1849510318 | ||
| 029 | 1 | |a DEBBG |b BV044166250 | |
| 029 | 1 | |a DEBSZ |b 397325614 | |
| 035 | |a (OCoLC)796383595 | ||
| 050 | 4 | |a QA76.9.D3 S65 2010 | |
| 082 | 0 | 4 | |a 005.7585 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Smith, Gregory, |d 1971- |1 https://id.oclc.org/worldcat/entity/E39PCjyJv3mfhjhYGQ6ymGxj3P | |
| 245 | 1 | 0 | |a PostgreSQL 9.0 High Performance. |
| 260 | |a Birmingham : |b Packt Pub., |c 2010. | ||
| 300 | |a 1 online resource (868 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 505 | 0 | |a PostgreSQL 9.0 High Performance; PostgreSQL 9.0 High Performance; Credits; About the Author; About the Reviewers; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 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; PostgreSQL or another database?; PostgreSQL tools; PostgreSQL contrib; Finding contrib modules on your system. | |
| 505 | 8 | |a Installing a contrib module from sourceUsing a contrib module; pgFoundry; Additional PostgreSQL-related software; PostgreSQL application scaling lifecycle; Performance tuning as a practice; Summary; 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. | |
| 505 | 8 | |a Disabling drive write cachesPerformance impact of write-through caching; Summary; 3. Database Hardware Benchmarking; CPU and memory benchmarking; memtest86+; STREAM memory testing; STREAM and Intel vs. AMD; CPU benchmarking; Sources of slow memory and processors; Physical disk performance; Random access and I/Os Per Second; Sequential access and ZCAV; Short stroking; Commit rate; PostgreSQL test_fsync; INSERT rate; Windows commit rate; Disk benchmarking tools; hdtune; Short stroking tests; IOPS; Unpredictable performance and Windows; dd; bonnie++; bonnie++ 2.0; bonnie++ ZCAV; sysbench. | |
| 505 | 8 | |a Seek ratefsync commit rate; Complicated disk benchmarks; Sample disk results; Disk performance expectations; Sources of slow disk and array performance; Summary; 4. Disk Setup; Maximum filesystem sizes; Filesystem crash recovery; Journaling filesystems; Linux filesystems; ext2; ext3; ext4; XFS; 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; I/O scheduler elevator; Solaris and FreeBSD filesystems; Solaris UFS; FreeBSD UFS2; ZFS. | |
| 505 | 8 | |a Windows filesystemsFAT32; NTFS; Adjusting mounting behaviour; Disk layout for PostgreSQL; Symbolic links; Tablespaces; Database directory tree; Temporary files; Disk arrays, RAID, and disk layout; Disk layout guidelines; Summary; 5. Memory for Database Caching; Memory units in the 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; Database disk layout; Creating a new block in a database; Writing dirty blocks to disk. | |
| 520 | |a Accelerate your PostgreSQL system. | ||
| 588 | 0 | |a Print version record. | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a Database management |2 fast | |
| 758 | |i has work: |a PostgreSQL 9.0 high performance (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGP9MJmPywCtvtk4CQB4WP |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Smith, Gregory. |t PostgreSQL 9.0 High Performance. |d Birmingham : Packt Publishing, ©2010 |z 9781849510301 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=943995 |z Texto completo |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL943995 | ||
| 994 | |a 92 |b IZTAP | ||