PostgreSQL 10 Administration Cookbook :: Over 165 effective recipes for database management and maintenance in PostgreSQL 10.
PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL solution.
Saved in:
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham :
Packt Publishing,
2018.
|
| Subjects: | |
| Online Access: | DE-862 DE-863 |
| Summary: | PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL solution. |
| Item Description: | Getting ready. |
| Physical Description: | 1 online resource (564 pages) |
| ISBN: | 9781788477895 1788477898 9781788474924 1788474929 |
Staff View
MARC
| LEADER | 00000cam a2200000Mi 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-on1038475454 | ||
| 003 | OCoLC | ||
| 005 | 20250103110447.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 180602s2018 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 UKMGB |d OCLCO |d LVT |d UKAHL |d C6I |d OCLCQ |d UX1 |d K6U |d N$T |d OCLCO |d NZAUC |d OCLCQ |d OCLCO |d OCLCL |d TMA |d OCLCQ |d SXB | ||
| 015 | |a GBB897993 |2 bnb | ||
| 016 | 7 | |a 018882485 |2 Uk | |
| 019 | |a 1038397402 |a 1175624106 | ||
| 020 | |a 9781788477895 |q (electronic bk.) | ||
| 020 | |a 1788477898 |q (electronic bk.) | ||
| 020 | |a 9781788474924 | ||
| 020 | |a 1788474929 |q (Trade Paper) | ||
| 024 | 3 | |a 9781788474924 | |
| 035 | |a (OCoLC)1038475454 |z (OCoLC)1038397402 |z (OCoLC)1175624106 | ||
| 037 | |a DE0F8BFA-D4AF-40B9-ACC0-B12A52CFB070 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.D3 |b .C565 2018eb | |
| 082 | 7 | |a 005.74 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Ciolli, Gianni. | |
| 245 | 1 | 0 | |a PostgreSQL 10 Administration Cookbook : |b Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |
| 260 | |a Birmingham : |b Packt Publishing, |c 2018. | ||
| 300 | |a 1 online resource (564 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; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: First Steps; Introduction; Introducing PostgreSQL 10; What makes PostgreSQL different?; Robustness; Security; Ease of use; Extensibility; Performance and concurrency; Scalability; SQL and NoSQL; Popularity; Commercial support; Research and development funding; Getting PostgreSQL; How to do it ... ; How it works ... ; There's more ... ; Connecting to the PostgreSQL server; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Enabling access for network/remote users. | |
| 505 | 8 | |a How to do it ... How it works ... ; There's more ... ; See also; Using graphical administration tools; How to do it ... ; How it works ... ; OmniDB; See also; Using the psql query and scripting tool; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Changing your password securely; How to do it ... ; How it works ... ; Avoiding hardcoding your password; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Using a connection service file; How to do it ... ; How it works ... ; Troubleshooting a failed connection; How to do it ... ; There's more ... ; Chapter 2: Exploring the Database; Introduction. | |
| 505 | 8 | |a What version is the server?How to do it ... ; How it works ... ; There's more ... ; What is the server uptime?; How to do it ... ; How it works ... ; See also; Locating the database server files; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database server's message log; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database's system identifier; Getting ready; How to do it ... ; How it works ... ; Listing databases on this database server; How to do it ... ; How it works ... ; There's more ... ; How many tables are there in a database?; How to do it ... | |
| 505 | 8 | |a How it works ... There's more ... ; How much disk space does a database use?; How to do it ... ; How it works ... ; How much disk space does a table use?; How to do it ... ; How it works ... ; There's more ... ; Which are my biggest tables?; How to do it ... ; How it works ... ; How many rows are there in a table?; How to do it ... ; How it works ... ; Quickly estimating the number of rows in a table; How to do it ... ; How it works ... ; There's more ... ; Function 1 -- Estimating the number of rows; Function 2 -- Computing the size of a table without locks; Listing extensions in this database; Getting ready; How to do it ... ; How it works ... | |
| 505 | 8 | |a There's more ... Understanding object dependencies; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Chapter 3: Configuration; Introduction; Reading the fine manual; How to do it ... ; How it works ... ; There's more ... ; Planning a new database; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Changing parameters in your programs; How to do it ... ; How it works ... ; There's more ... ; Finding the current configuration settings; How to do it ... ; There's more ... ; How it works ... ; Which parameters are at non-default settings?; How to do it ... ; How it works ... ; There's more ... ; Updating the parameter file. | |
| 500 | |a Getting ready. | ||
| 520 | |a PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL solution. | ||
| 630 | 0 | 0 | |a PostgreSQL. |0 http://id.loc.gov/authorities/names/n00067354 |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a Database management |2 fast | |
| 655 | 4 | |a Electronic book. | |
| 700 | 1 | |a Riggs, Simon. | |
| 758 | |i has work: |a PostgreSQL 10 administration cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGYryC9TXyv7cMyhMyFKbd |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Ciolli, Gianni. |t PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |d Birmingham : Packt Publishing, ©2018 |
| 966 | 4 | 0 | |l DE-862 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1817509 |3 Volltext |
| 966 | 4 | 0 | |l DE-863 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1817509 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH34621753 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL5400404 | ||
| 938 | |a YBP Library Services |b YANK |n 15450186 | ||
| 938 | |a EBSCOhost |b EBSC |n 1817509 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-862 | ||
| 049 | |a DE-863 | ||
Record in the Search Index
| DE-BY-FWS_katkey | ZDB-4-EBA-on1038475454 |
|---|---|
| _version_ | 1829095269867716608 |
| adam_text | |
| any_adam_object | |
| author | Ciolli, Gianni |
| author2 | Riggs, Simon |
| author2_role | |
| author2_variant | s r sr |
| author_facet | Ciolli, Gianni Riggs, Simon |
| author_role | |
| author_sort | Ciolli, Gianni |
| author_variant | g c gc |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 .C565 2018eb |
| callnumber-search | QA76.9.D3 .C565 2018eb |
| callnumber-sort | QA 276.9 D3 C565 42018EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Cover; Title Page; Copyright and Credits; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: First Steps; Introduction; Introducing PostgreSQL 10; What makes PostgreSQL different?; Robustness; Security; Ease of use; Extensibility; Performance and concurrency; Scalability; SQL and NoSQL; Popularity; Commercial support; Research and development funding; Getting PostgreSQL; How to do it ... ; How it works ... ; There's more ... ; Connecting to the PostgreSQL server; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Enabling access for network/remote users. How to do it ... How it works ... ; There's more ... ; See also; Using graphical administration tools; How to do it ... ; How it works ... ; OmniDB; See also; Using the psql query and scripting tool; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Changing your password securely; How to do it ... ; How it works ... ; Avoiding hardcoding your password; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Using a connection service file; How to do it ... ; How it works ... ; Troubleshooting a failed connection; How to do it ... ; There's more ... ; Chapter 2: Exploring the Database; Introduction. What version is the server?How to do it ... ; How it works ... ; There's more ... ; What is the server uptime?; How to do it ... ; How it works ... ; See also; Locating the database server files; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database server's message log; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database's system identifier; Getting ready; How to do it ... ; How it works ... ; Listing databases on this database server; How to do it ... ; How it works ... ; There's more ... ; How many tables are there in a database?; How to do it ... How it works ... There's more ... ; How much disk space does a database use?; How to do it ... ; How it works ... ; How much disk space does a table use?; How to do it ... ; How it works ... ; There's more ... ; Which are my biggest tables?; How to do it ... ; How it works ... ; How many rows are there in a table?; How to do it ... ; How it works ... ; Quickly estimating the number of rows in a table; How to do it ... ; How it works ... ; There's more ... ; Function 1 -- Estimating the number of rows; Function 2 -- Computing the size of a table without locks; Listing extensions in this database; Getting ready; How to do it ... ; How it works ... There's more ... Understanding object dependencies; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Chapter 3: Configuration; Introduction; Reading the fine manual; How to do it ... ; How it works ... ; There's more ... ; Planning a new database; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Changing parameters in your programs; How to do it ... ; How it works ... ; There's more ... ; Finding the current configuration settings; How to do it ... ; There's more ... ; How it works ... ; Which parameters are at non-default settings?; How to do it ... ; How it works ... ; There's more ... ; Updating the parameter file. |
| ctrlnum | (OCoLC)1038475454 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06105cam a2200625Mi 4500</leader><controlfield tag="001">ZDB-4-EBA-on1038475454</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20250103110447.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">180602s2018 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">EBLCP</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">EBLCP</subfield><subfield code="d">YDX</subfield><subfield code="d">MERUC</subfield><subfield code="d">IDB</subfield><subfield code="d">CHVBK</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">NLE</subfield><subfield code="d">TEFOD</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCO</subfield><subfield code="d">LVT</subfield><subfield code="d">UKAHL</subfield><subfield code="d">C6I</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UX1</subfield><subfield code="d">K6U</subfield><subfield code="d">N$T</subfield><subfield code="d">OCLCO</subfield><subfield code="d">NZAUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">TMA</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">SXB</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB897993</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018882485</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">1038397402</subfield><subfield code="a">1175624106</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781788477895</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1788477898</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781788474924</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1788474929</subfield><subfield code="q">(Trade Paper)</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9781788474924</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1038475454</subfield><subfield code="z">(OCoLC)1038397402</subfield><subfield code="z">(OCoLC)1175624106</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">DE0F8BFA-D4AF-40B9-ACC0-B12A52CFB070</subfield><subfield code="b">OverDrive, Inc.</subfield><subfield code="n">http://www.overdrive.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">.C565 2018eb</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Ciolli, Gianni.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">PostgreSQL 10 Administration Cookbook :</subfield><subfield code="b">Over 165 effective recipes for database management and maintenance in PostgreSQL 10.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2018.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (564 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Title Page; Copyright and Credits; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: First Steps; Introduction; Introducing PostgreSQL 10; What makes PostgreSQL different?; Robustness; Security; Ease of use; Extensibility; Performance and concurrency; Scalability; SQL and NoSQL; Popularity; Commercial support; Research and development funding; Getting PostgreSQL; How to do it ... ; How it works ... ; There's more ... ; Connecting to the PostgreSQL server; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Enabling access for network/remote users.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">How to do it ... How it works ... ; There's more ... ; See also; Using graphical administration tools; How to do it ... ; How it works ... ; OmniDB; See also; Using the psql query and scripting tool; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Changing your password securely; How to do it ... ; How it works ... ; Avoiding hardcoding your password; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Using a connection service file; How to do it ... ; How it works ... ; Troubleshooting a failed connection; How to do it ... ; There's more ... ; Chapter 2: Exploring the Database; Introduction.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">What version is the server?How to do it ... ; How it works ... ; There's more ... ; What is the server uptime?; How to do it ... ; How it works ... ; See also; Locating the database server files; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database server's message log; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database's system identifier; Getting ready; How to do it ... ; How it works ... ; Listing databases on this database server; How to do it ... ; How it works ... ; There's more ... ; How many tables are there in a database?; How to do it ...</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">How it works ... There's more ... ; How much disk space does a database use?; How to do it ... ; How it works ... ; How much disk space does a table use?; How to do it ... ; How it works ... ; There's more ... ; Which are my biggest tables?; How to do it ... ; How it works ... ; How many rows are there in a table?; How to do it ... ; How it works ... ; Quickly estimating the number of rows in a table; How to do it ... ; How it works ... ; There's more ... ; Function 1 -- Estimating the number of rows; Function 2 -- Computing the size of a table without locks; Listing extensions in this database; Getting ready; How to do it ... ; How it works ...</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">There's more ... Understanding object dependencies; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Chapter 3: Configuration; Introduction; Reading the fine manual; How to do it ... ; How it works ... ; There's more ... ; Planning a new database; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Changing parameters in your programs; How to do it ... ; How it works ... ; There's more ... ; Finding the current configuration settings; How to do it ... ; There's more ... ; How it works ... ; Which parameters are at non-default settings?; How to do it ... ; How it works ... ; There's more ... ; Updating the parameter file.</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Getting ready.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL solution.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">PostgreSQL.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n00067354</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">PostgreSQL</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="4"><subfield code="a">Electronic book.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Riggs, Simon.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">PostgreSQL 10 administration cookbook (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCGYryC9TXyv7cMyhMyFKbd</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Ciolli, Gianni.</subfield><subfield code="t">PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10.</subfield><subfield code="d">Birmingham : Packt Publishing, ©2018</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-862</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1817509</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-863</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1817509</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH34621753</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL5400404</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">15450186</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">1817509</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-862</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| genre | Electronic book. |
| genre_facet | Electronic book. |
| id | ZDB-4-EBA-on1038475454 |
| illustrated | Not Illustrated |
| indexdate | 2025-04-11T08:46:21Z |
| institution | BVB |
| isbn | 9781788477895 1788477898 9781788474924 1788474929 |
| language | English |
| oclc_num | 1038475454 |
| open_access_boolean | |
| owner | MAIN DE-862 DE-BY-FWS DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-862 DE-BY-FWS DE-863 DE-BY-FWS |
| physical | 1 online resource (564 pages) |
| psigel | ZDB-4-EBA FWS_PDA_EBA ZDB-4-EBA |
| publishDate | 2018 |
| publishDateSearch | 2018 |
| publishDateSort | 2018 |
| publisher | Packt Publishing, |
| record_format | marc |
| spelling | Ciolli, Gianni. PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. Birmingham : Packt Publishing, 2018. 1 online resource (564 pages) text txt rdacontent computer c rdamedia online resource cr rdacarrier Print version record. Cover; Title Page; Copyright and Credits; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: First Steps; Introduction; Introducing PostgreSQL 10; What makes PostgreSQL different?; Robustness; Security; Ease of use; Extensibility; Performance and concurrency; Scalability; SQL and NoSQL; Popularity; Commercial support; Research and development funding; Getting PostgreSQL; How to do it ... ; How it works ... ; There's more ... ; Connecting to the PostgreSQL server; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Enabling access for network/remote users. How to do it ... How it works ... ; There's more ... ; See also; Using graphical administration tools; How to do it ... ; How it works ... ; OmniDB; See also; Using the psql query and scripting tool; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Changing your password securely; How to do it ... ; How it works ... ; Avoiding hardcoding your password; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Using a connection service file; How to do it ... ; How it works ... ; Troubleshooting a failed connection; How to do it ... ; There's more ... ; Chapter 2: Exploring the Database; Introduction. What version is the server?How to do it ... ; How it works ... ; There's more ... ; What is the server uptime?; How to do it ... ; How it works ... ; See also; Locating the database server files; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database server's message log; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database's system identifier; Getting ready; How to do it ... ; How it works ... ; Listing databases on this database server; How to do it ... ; How it works ... ; There's more ... ; How many tables are there in a database?; How to do it ... How it works ... There's more ... ; How much disk space does a database use?; How to do it ... ; How it works ... ; How much disk space does a table use?; How to do it ... ; How it works ... ; There's more ... ; Which are my biggest tables?; How to do it ... ; How it works ... ; How many rows are there in a table?; How to do it ... ; How it works ... ; Quickly estimating the number of rows in a table; How to do it ... ; How it works ... ; There's more ... ; Function 1 -- Estimating the number of rows; Function 2 -- Computing the size of a table without locks; Listing extensions in this database; Getting ready; How to do it ... ; How it works ... There's more ... Understanding object dependencies; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Chapter 3: Configuration; Introduction; Reading the fine manual; How to do it ... ; How it works ... ; There's more ... ; Planning a new database; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Changing parameters in your programs; How to do it ... ; How it works ... ; There's more ... ; Finding the current configuration settings; How to do it ... ; There's more ... ; How it works ... ; Which parameters are at non-default settings?; How to do it ... ; How it works ... ; There's more ... ; Updating the parameter file. Getting ready. PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL solution. PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. Database management fast Electronic book. Riggs, Simon. has work: PostgreSQL 10 administration cookbook (Text) https://id.oclc.org/worldcat/entity/E39PCGYryC9TXyv7cMyhMyFKbd https://id.oclc.org/worldcat/ontology/hasWork Print version: Ciolli, Gianni. PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. Birmingham : Packt Publishing, ©2018 |
| spellingShingle | Ciolli, Gianni PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. Cover; Title Page; Copyright and Credits; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: First Steps; Introduction; Introducing PostgreSQL 10; What makes PostgreSQL different?; Robustness; Security; Ease of use; Extensibility; Performance and concurrency; Scalability; SQL and NoSQL; Popularity; Commercial support; Research and development funding; Getting PostgreSQL; How to do it ... ; How it works ... ; There's more ... ; Connecting to the PostgreSQL server; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Enabling access for network/remote users. How to do it ... How it works ... ; There's more ... ; See also; Using graphical administration tools; How to do it ... ; How it works ... ; OmniDB; See also; Using the psql query and scripting tool; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Changing your password securely; How to do it ... ; How it works ... ; Avoiding hardcoding your password; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Using a connection service file; How to do it ... ; How it works ... ; Troubleshooting a failed connection; How to do it ... ; There's more ... ; Chapter 2: Exploring the Database; Introduction. What version is the server?How to do it ... ; How it works ... ; There's more ... ; What is the server uptime?; How to do it ... ; How it works ... ; See also; Locating the database server files; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database server's message log; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Locating the database's system identifier; Getting ready; How to do it ... ; How it works ... ; Listing databases on this database server; How to do it ... ; How it works ... ; There's more ... ; How many tables are there in a database?; How to do it ... How it works ... There's more ... ; How much disk space does a database use?; How to do it ... ; How it works ... ; How much disk space does a table use?; How to do it ... ; How it works ... ; There's more ... ; Which are my biggest tables?; How to do it ... ; How it works ... ; How many rows are there in a table?; How to do it ... ; How it works ... ; Quickly estimating the number of rows in a table; How to do it ... ; How it works ... ; There's more ... ; Function 1 -- Estimating the number of rows; Function 2 -- Computing the size of a table without locks; Listing extensions in this database; Getting ready; How to do it ... ; How it works ... There's more ... Understanding object dependencies; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Chapter 3: Configuration; Introduction; Reading the fine manual; How to do it ... ; How it works ... ; There's more ... ; Planning a new database; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Changing parameters in your programs; How to do it ... ; How it works ... ; There's more ... ; Finding the current configuration settings; How to do it ... ; There's more ... ; How it works ... ; Which parameters are at non-default settings?; How to do it ... ; How it works ... ; There's more ... ; Updating the parameter file. PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. Database management fast |
| subject_GND | http://id.loc.gov/authorities/names/n00067354 http://id.loc.gov/authorities/subjects/sh85035848 |
| title | PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |
| title_auth | PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |
| title_exact_search | PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |
| title_full | PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |
| title_fullStr | PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |
| title_full_unstemmed | PostgreSQL 10 Administration Cookbook : Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |
| title_short | PostgreSQL 10 Administration Cookbook : |
| title_sort | postgresql 10 administration cookbook over 165 effective recipes for database management and maintenance in postgresql 10 |
| title_sub | Over 165 effective recipes for database management and maintenance in PostgreSQL 10. |
| topic | PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. Database management fast |
| topic_facet | PostgreSQL. PostgreSQL Database management. Bases de données Gestion. Database management Electronic book. |
| work_keys_str_mv | AT ciolligianni postgresql10administrationcookbookover165effectiverecipesfordatabasemanagementandmaintenanceinpostgresql10 AT riggssimon postgresql10administrationcookbookover165effectiverecipesfordatabasemanagementandmaintenanceinpostgresql10 |