Problem Resolution

Step-by-Step to fix the PostgreSQL Databases errors: Errors - Causes - Investigation - Resolution

PostgreSQL Hardware Performance Tuning — by Josana Bujokas da Rosa — last modified 2009-01-30 18:09

POSTGRESQL is an object-relational database developed on the Internet by a group of developers spread across the globe. It is an open-source alternative to commercial databases like Oracle and Informix. POSTGRESQL was originally developed at the University of California at Berkeley. In 1996, a group began development of the database on the Internet. They use email to share ideas and file servers to share code. POSTGRESQL is now comparable to commercial databases in terms of features, performance, and reliability. It has transactions, views, stored procedures, and referential integrity constraints. It supports a large number of programming interfaces, including ODBC, Java (JDBC), TCL/TK, PHP, Perl, and Python. POSTGRESQL continues to improve at a tremendous pace thanks to a talented pool of Internet developers.

PostgreSQL Naming Rules — by Josana Bujokas da Rosa — last modified 2009-01-30 18:10

This chapter covers the basic operation of PostgreSQL, including naming conventions, creating a database, and indexing.