LEADER 04780nam  2200649 a 450 
001 9910785229003321
005 20200520144314.0
010   $a1-282-89647-4
010   $a9786612896477
010   $a1-84951-031-8
035   $a(CKB)2670000000055048
035   $a(EBL)943995
035   $a(OCoLC)796383595
035   $a(SSID)ssj0000441016
035   $a(PQKBManifestationID)11292965
035   $a(PQKBTitleCode)TC0000441016
035   $a(PQKBWorkID)10405149
035   $a(PQKB)10423785
035   $a(Au-PeEL)EBL943995
035   $a(CaPaEBR)ebr10428670
035   $a(CaONFJC)MIL289647
035   $a(CaSebORM)9781849510301
035   $a(MiAaPQ)EBC943995
035   $a(PPN)227983920
035   $a(EXLCZ)992670000000055048
100   $a20101207d2010      uy             0
101 0 $aeng
135   $aurunu|||||
181   $ctxt
182   $cc
183   $acr
200 10$aPostgreSQL 9.0$b[electronic resource] $ehigh performance /$fGregory Smith
205   $a1st edition
210   $aBirmingham [England] $cPackt Publishing$d2010
215   $a1 online resource (468 p.)
225 0 $aOpen source : community experience distilled
300   $a"Accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down."
300   $aIncludes index.
311   $a1-84951-030-X 
327   $aCover; Copyright; Credits; About the Author; About the Reviewers; 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; PostgreSQL or another database?; PostgreSQL tools; PostgreSQL contrib; Finding contrib modules on your system; Installing a contrib module from source; Using a contrib module; pgFoundry; Additional PostgreSQL-related software; PostgreSQL application scaling lifecycle
327   $aPerformance 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; Performance impact of write-through caching; Summary; Chapter 3: Database Hardware Benchmarking; CPU and memory benchmarking
327   $amemtest86+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; Seek rate; fsync commit rate; Complicated disk benchmarks; Sample disk results; Disk performance expectations; Sources of slow disk and array performance
327   $aSummary Chapter 4: Disk Setup; Maximum file system sizes; File system crash recovery; Journaling file systems; Linux file systems; ext2; ext3; ext4; XFS; Other Linux file systems; Write barriers; Drive support for barriers; File system support for barriers; General Linux file system tuning; Read-ahead; File access times; Read caching and swapping; Write cache sizing; I/O scheduler elevator; Solaris and FreeBSD file systems; Solaris UFS; FreeBSD UFS2; ZFS; Windows filesystems; FAT32; NTFS; Adjusting mounting behaviour; Disk layout for PostgreSQL; Symbolic links; Tablespaces; Database directory tree
327   $aTemporary files Disk arrays, RAID, and disk layout; Disk layout guidelines; Summary; Chapter 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; Crash recovery and the buffer cache; Checkpoint processing basics; Write-ahead log and recovery processing; Checkpoint timing; Checkpoint spikes
327   $aSpread checkpoints
330   $aAccelerate your PostgreSQL system
606   $aDatabase management
615  0$aDatabase management.
676   $a005.7585
700   $aSmith$b Gregory$0193667
801  0$bMiAaPQ
801  1$bMiAaPQ
801  2$bMiAaPQ
906   $aBOOK
912   $a9910785229003321
996   $aPostgreSQL 9.0$93698124
997   $aUNINA