rdf-syntax-grammar
mods:
  schema location: http://www.loc.gov/mods/v3 http://www.loc.gov/standards/mods/v3/mods-3-2.xsd
  title info:
    title: PostgreSQL for Data Architects
  name:
    name part: Maymala, Jayadevan
    role:
      role term: creator
    role:
      role term: author.
  name:
    name part: Safari, an O'Reilly Media Company
  type of resource: text
  genre: Electronic books.
  origin info:
    place:
      place term: xx
    date issued: 2015
    edition: 1st edition.
    issuance: monographic
  language:
    language term: eng
  physical description:
    form: remote
    extent: 1 online resource (272 pages)
  abstract: Discover how to design, develop, and maintain your database application effectively with PostgreSQL In Detail PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up. PostgreSQL for Data Architects will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running. The book starts with basic concepts like installing PostgreSQL from source and covers theoretical aspects such as concurrency and transaction management. After this, you'll learn how to set up replication, use load balancing to scale horizontally, and troubleshoot errors. Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzing PostgreSQL logs, setting up load balancing, and recovery. What You Will Learn Compile PostgreSQL from source and understand the PostgreSQL architecture Configure parameters and change default settings for a PostgreSQL server Leverage the logging mechanism to identify errors and suboptimal queries Use replication to scale horizontally Set up backup and recovery processes Tweak parameters to optimize queries and processes Troubleshoot connection errors Use indexes and rewrite queries to improve performance Install and use PostgreSQL extensions Learn how to leverage the command-line client (psql)
  note: Maymala, Jayadevan.
  note: Electronic resource.
  note: Electronic reproduction. Boston, MA : Safari, Available via World Wide Web.
  note: Mode of access: World Wide Web.
  identifier: 9781783288601
  identifier: 9781783288618
  identifier: https://proxy.library.tamu.edu/login
  record info:
    record creation date: 310315
    record change date: 20260130163458.7
    record identifier: in00004259527