PostgreSQL is an object database management system
released under a BSD-style
license. The project is commonly known by the name "Postgres", which was in fact its original
name.
Here are some books about Postgres:
Disclosure: Products details and descriptions provided by Amazon.com. Our company may receive a payment if you purchase products from them after following a link from this website.
Product Description: Accelerate your PostgreSQL system
Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance.
Discover the techniques used to scale successful database installations.
Avoid the common pitfalls that can slow your system down.
Filled with advice about what you should be doing; how to build experimental databases to explore performance topics, and then move what you've learned into a production database environment.
Covers versions 8.1 through 9.0.
In Detail PostgreSQL database servers have a common set of problems they encounter as their usage gets heavier and requirements more demanding. You could spend years discovering solutions to them all, step by step as you encounter them. Or you can just look in here.
All successful database applications are destined to eventually run into issues scaling up their performance. Peek into the future of your PostgreSQL database's problems today. Know the warning signs to look for, and how to avoid the most common issues before they even happen.
Surprisingly, most PostgreSQL database applications evolve in the same way: Choose the right hardware. Tune the operating system and server memory use. Optimize queries against the database, with the right indexes. Monitor every layer, from hardware to queries, using some tools that are inside PostgreSQL and others that are external. Using monitoring insight, continuously rework the design and configuration. On reaching the limits of a single server, break things up; connection pooling, caching, partitioning, and replication can all help handle increasing database workloads.
The path to a high performance database system isn't always easy. But it doesn't have to be mysterious with the right guide. Approach A clear, step-by-step guide to optimizing and scaling up PostgreSQL database servers. Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database.
PostgreSQL is one of the world’s most popular Open Source relational database systems. It is renowned for its wide range of capabilities, and its ability to perform functions not available in other databases. The forthcoming release of PostgreSQL 8.0 in late 2004/early 2005 will include major revisions, such as Win32 Native Support, and this book will provide the tools for anyone making the transition or learning about PostgreSQL for the first time.
This book introduces readers to many of the most prominent features, simultaneously introducing key relational database design and management principles that will help the novice reader effectively manage their data-driven application.
Over 150 pages of coverage is devoted to the most popular PostgreSQL APIs, including PHP, Perl, Java and C. Users of all levels will appreciate the 50 pages of condensed reference material covering PostgreSQL data types, syntax, the psql client, and large object support.
Product Description: Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases on PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. This book is most suited to those who have some technical experience.
The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.
Whether you're canvassing a congressional district, managing a sales region, mapping city bus schedules, or analyzing local cancer rates, thinking spatially opens up limitless possibilities for database users. PostGIS, a freely available open-source spatial database extender, can help you answer questions that you could not answer using a mere relational database. Its feature set equals or surpasses proprietary alternatives, allowing you to create location-aware queries and features with just a few lines of SQL code. PostGIS in Action is the first book devoted entirely to PostGIS. It will help both new and experienced users write spatial queries to solve real-world problems. For those with experience in more traditional relational databases, this book provides a background in vector-based GIS so you can quickly move to analyzing, viewing, and mapping data. Advanced users will learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions suited specifically to their applications. It also discusses the new features available in PostgreSQL 9.0 /9.1 and PostGIS 2.0 and provides tutorials on using additional open source GIS tools in conjunction with PostGIS.
Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage.
This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft. Also included is a CD-ROM with Command Prompt's PostgreSQL Application Server, LXP. The CD covers LXP version 0.8.0 and PostgreSQL version 7.1.3.
Product Description: Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases in PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. The book assumes that you are familiar with the basic operation of PostgreSQL.
Product Description: PostgreSQL is rapidly on its way to becoming the most successful open source relational database system. It has had an explosive growth, from its roots in academia, to the Internet, through the efforts of a talented hard-working worldwide development team. The vast array of enterprise businesses migrating to PostgreSQL from proprietary databases are stark evidence for its success to come.
This book is a complete tutorial on PostgreSQL features and functions beginning with the basics and building up to the design and construction of databases and integrating them with programming languages for the Web. Here we'll show you how to make the most of this fully programmable databases' powerful features like aggregate, join, transaction, inheritance, embedding your own C routines and more.
This book covers:
Detailed tutorial in PostgreSQL
Installing from binaries and source code on UNIX and Windows
Working with graphical tools
Various forms of queries, subqueries, aggregate functions and joins
Transactions, locking, stored procedures and triggers
Performance monitoring, tuning and server control
Connecting and executing SQL statements using C (libpq) and Embedded SQL
Beginning PHP 5 and PostgreSQL 8 is the first and most comprehensive book to delve into the latest versions of two popular open source web development technologies, the PostgreSQL 8 database server and PHP 5 scripting language. Readers reap the knowledge of these core technologies and gain valuable insight into how they are used in unison to create dynamic data-driven web applications.
This is an ideal guide for the web designer, programmer, hobbyist, or novice who wants to learn how to create applications with PHP 5 and PostgreSQL 8.
Product Description: This manual is part of the official reference documentation for PostgreSQL 9.0. It describes the SQL language specification as implemented by PostgreSQL, including syntax, data types, functions and operators, indexes and transactions. The new XML datatypes and full-text index support of PostgreSQL 9 are also fully documented. This volume is part of a set. The separate Volume 1B "SQL Command Reference" (ISBN 978-1-906966-05-8) contains the documentation for every PostgreSQL command from ABORT to VALUES. PostgreSQL client and server command-line tools are also documented in Volume 1B. Volumes 1A and 1B are intended to be used together. The further additional volumes of this series are Volume 2, the "Programming Guide" (ISBN 978-1-906966-06-5), and Volume 3, the "Server Administration Guide" (ISBN 978-1-906966-07-2). For each copy of this manual sold 1 USD is donated to the PostgreSQL project by the publisher, Network Theory Ltd.
Answers 2000 Limited has no opinion about any stories or content of, or
views expressed in, any linked news resource or website.
Information about companies, organizations, products and services
was believed to be correct at the time it was first published on this website,
but may out of date by the time you read this website. For current
information about any company or organization,
readers are advised to check with the applicable company or organization.
Answers 2000 Limited expresses no opinion about any company or
organization (including expressing no opinion on any investments in, with, or relating to, any company or organization),
product or service. This website is not intended as investment or
financial advice.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Disclosure:
Our company's websites' content (including this website's content) includes advertisements for
our own company's websites, products, and services,
and for other organization's websites, products, and services.
In the case of links to other organization's websites,
our company may receive a payment, (1) if you purchase products or services,
or (2) if you sign-up for third party offers, after following links from this website.
Unless specifically otherwise stated, information about other organization's products and services,
is based on information provided by that organization,
the product/service vendor, and/or publicly available information - and should
not be taken to mean that we have used the product/service in question.
Additionally, our company's websites contain some adverts which we are paid
to display, but whose content is not selected by us, such as Google AdSense ads. For more
detailed information, please see Advertising/Endorsements Disclosures
