|
|
|
|
| LEADER |
04713nmm a2200517 u 4500 |
| 001 |
EB001939439 |
| 003 |
EBX01000000000000001102341 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 9781783288618
|
| 050 |
|
4 |
|a QA76.9.D3
|
| 100 |
1 |
|
|a Maymala, Jayadevan
|
| 245 |
0 |
0 |
|a PostgreSQL for data architects
|b discover how to design, develop, and maintain your database application effectively with PostgreSQL
|c Jayadevan Maymala
|
| 246 |
3 |
1 |
|a Discover how to design, develop, and maintain your database application effectively with PostgreSQL
|
| 246 |
3 |
1 |
|a Postgre Structured Query Language for data architects
|
| 260 |
|
|
|a Birmingham, UK
|b Packt Publishing
|c 2015
|
| 300 |
|
|
|a 1 volume
|b illustrations
|
| 505 |
0 |
|
|a Approaches to reducing the number of blocks read/writtenQuery execution components; Planner; Access methods; Join strategies; Finding the execution plan; Optimization guidelines and catches; Indexing foreign keys; Using SELECT *; Using ORDER BY; Using DISTINCT; Using UNION ALL instead of UNION; Using functions in the FILTER clause; Reducing the number of SQL statements; Reducing function executions; Not using indexes; Partial indexes; Optimizing functions; Summary; Chapter 8: Server Tuning; Server-wide memory settings; shared_buffers; effective_cache_size
|
| 505 |
0 |
|
|a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing PostgreSQL; Installation options; Downloading and extracting the source; Inspecting the contents; Dependencies to compile the source; Configuring and creating the makefile; Building and creating the executables; Installing and moving the files to where they belong; Inspecting the changes; Initializing a cluster; A quick walk through the directories; Processes created; Important files created; Working with extensions; Summary; Chapter 2: Server Architecture
|
| 505 |
0 |
|
|a Starting with the daemon processUnderstanding the shared buffer; Inspecting the buffer cache; Checkpoint; WAL and the WAL writer process; Recovery; Incremental backup and point-in-time recovery; Replication; The background writer; The autovacuum launcher process; The logging process; The stats collector process; The WAL sender and WAL receiver; Sorting in memory with work_mem; Maintenance with maintenance_work_mem; Understanding effective_cache_size; Summary; Chapter 3: PostgreSQL -- Object Hierarchy and Roles; The PostgreSQL cluster; Understanding tablespaces
|
| 505 |
0 |
|
|a Exporting the data modelProfiling; Summary; Chapter 6: Client Tools; GUI tools and command-line tools; pgAdmin -- downloading and installation; Adding a server; The pgAdmin main window; The Query tool; psql -- working from the command line; psql -- connection options; The power of \d; More meta-commands; Setting up the environment; History of commands; Summary; Chapter 7: SQL Tuning; Understanding basic facts about databases; Fact 1 -- databases are more frequently read from than written to; Fact 2 -- data is always read in blocks or pages, not as individual records or columns
|
| 505 |
0 |
|
|a Managing temporary objects with temporary tablespacesViews; Databases, schemas, and search_path; Schemas -- use cases; Roles and privileges; Summary; Chapter 4: Working with Transactions; Understanding transactions; ACID properties of transactions; A for atomicity; C for consistency; I for isolation; D for durability; PostgreSQL and MVCC; Summary; Chapter 5: Data Modeling with SQL Power Architect; Tools for databases and their uses; Database design tools; SQL Power Architect -- downloading and installing; Creating tables; Generating SQL; Reverse engineering and making changes
|
| 653 |
|
|
|a PostgreSQL. / http://id.loc.gov/authorities/names/n00067354
|
| 653 |
|
|
|a Bases de données / Gestion
|
| 653 |
|
|
|a Database design / fast
|
| 653 |
|
|
|a COMPUTERS / Database Management / General / bisacsh
|
| 653 |
|
|
|a Database design / http://id.loc.gov/authorities/subjects/sh88004472
|
| 653 |
|
|
|a Database management / http://id.loc.gov/authorities/subjects/sh85035848
|
| 653 |
|
|
|a Bases de données / Conception
|
| 653 |
|
|
|a PostgreSQL / fast
|
| 653 |
|
|
|a Database management / fast
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 490 |
0 |
|
|a Community experience disitlled
|
| 500 |
|
|
|a Includes index
|
| 015 |
|
|
|a GBB6G3026
|
| 776 |
|
|
|z 9781783288601
|
| 776 |
|
|
|z 1783288604
|
| 776 |
|
|
|z 1783288612
|
| 776 |
|
|
|z 9781783288618
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781783288601/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 658
|
| 082 |
0 |
|
|a 745.4
|
| 082 |
0 |
|
|a 005.7565
|
| 520 |
|
|
|a Annotation
|