عنوان
پدید آورنده
موضوع
رده
QA76.9.D3 .A364 2018eb
QA76
.
9
.
D3
.
A364
2018eb
کتابخانه
محل استقرار
شابک
شابک
1788472454
شابک
9781788472456
عنوان و نام پديدآور
عنوان اصلي
PostgreSQL 10 High Performance :
نام عام مواد
[Book]
ساير اطلاعات عنواني
Expert techniques for query optimization, high availability, and efficient database maintenance.
وضعیت نشر و پخش و غیره
محل نشرو پخش و غیره
Birmingham :
نام ناشر، پخش کننده و غيره
Packt Publishing,
تاریخ نشرو بخش و غیره
2018.
مشخصات ظاهری
نام خاص و کميت اثر
1 online resource (499 pages)
يادداشت کلی
متن يادداشت
Database disk layout.
یادداشتهای مربوط به مندرجات
متن يادداشت
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.
متن يادداشت
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.
متن يادداشت
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.
متن يادداشت
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++
متن يادداشت
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
یادداشتهای مربوط به خلاصه یا چکیده
متن يادداشت
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.
یادداشتهای مربوط به سفارشات
منبع سفارش / آدرس اشتراک
OverDrive, Inc.
شماره انبار
FA673B1A-8F1F-40A7-8799-9F0DD7D51827
ویراست دیگر از اثر در قالب دیگر رسانه
عنوان
PostgreSQL 10 High Performance : Expert techniques for query optimization, high availability, and efficient database maintenance.
موضوع (اسم عام یاعبارت اسمی عام)
موضوع مستند نشده
Relational databases.
موضوع مستند نشده
Computers-- Data Modeling & Design.
موضوع مستند نشده
Computers-- Database Management-- General.
موضوع مستند نشده
Database design & theory.
موضوع مستند نشده
Databases.
موضوع مستند نشده
Information architecture.
موضوع مستند نشده
Relational databases.
موضوع مستند نشده
Servers.
رده بندی ديویی
شماره
005
.
74
ويراست
23
رده بندی کنگره
شماره رده
QA76
.
9
.
D3
نشانه اثر
.
A364
2018eb
نام شخص به منزله سر شناسه - (مسئولیت معنوی درجه اول )
مستند نام اشخاص تاييد نشده
Pirozzi, Enrico.
مبدا اصلی
تاريخ عمليات
20200823060349.0
قواعد فهرست نويسي ( بخش توصيفي )
pn
دسترسی و محل الکترونیکی
نام الکترونيکي
مطالعه متن کتاب اطلاعات رکورد کتابشناسی
نوع ماده
[Book]
اطلاعات دسترسی رکورد
تكميل شده
Y
