Improvements in PostgreSQL 8.3

[Calan]

I have recently started working on the PostgreSQL 8.3, so I am not having enough knowledge about it. Just know that PostgreSQL is a management system database and object relational (ORDBMS). This is a free tool available under the terms of a BSD-style license. So thought to take some help from you members. Please tell me about an improvements in PostgreSQL 8.3. Also tell me about an advantages and disadvantages of this version of PostgreSQL. I am expecting some quick response from your side.

[Kaufman]

Among the most interesting features in terms of performance, you will find:

• Technology HOT (Heap Only Tuples), which allows 75% accelerate Table Maintenance frequent updates.
• self-optimization of the writing process in the background;
• asynchronous commit: pgSQL awaits the writing on the disk to move to the next requite
• sprawl checkpoints.
• paths synchronized: access to several commercially avail overlap to reduce the number of inputs / outputs
• reduction headers varlena;
• protection of the route of L2 cache

Version 8.3 also includes many useful features for administrators and users alike:

• logging application CSV to facilitate the audit
• Support for XPath and reqêtes publication in SQL / XML
• support for MS Visual C + + performance increase on MS Windows
• management of ENUM and compound types of tables in order to have better compatibility with MySQL and Oracle databases
• tsearch integrated research;
• SSPI & GSSAPI: secure authentication with Linux and Windows directories

[Appaji]

PostgreSQL is a management system database and object relational (ORDBMS). This is a free tool available under the terms of a BSD-style license.

Yeah its true. This system is a competitor for other management systems, database, they are free (such as MySQL and Firebird) or owners (such as Oracle, Sybase, DB2 and Microsoft SQL Server). As open source projects and Linux Apache, PostgreSQL is not controlled by one company, but is based on a global community of developers and businesses. PostgreSQL can store more data types than the traditional types integer, characters, etc.. The user can create types, functions, use inheritance like so. PostgreSQL is virtually consistent (more consistent) with ANSI SQL 89, SQL 92 (SQL 2) SQL 99 (SQL 3) and SQL: 2003. It runs on various hardware platforms and under different operating systems. PostgreSQL runs on Solaris, SunOS, Mac OS X, Linux , BSD and all sorts of unix. Since version 8.0, PostgreSQL also runs natively on Windows. Before version 8, PostgreSQL on Windows was working with an emulator like cygwin.

[Radames]

The following are some advantages of MySQL :

• MySQL is relatively faster than PostgreSQL.
• The design database is simpler.
• You can create a basic website run by the web.
• MySQL replication has been thoroughly tested.
• MySQL does not require cleaning (vacuum).

And the following points are the PostgreSQL Advantages:

• Design of complex databases
• Distancing from Oracle, Sybase or MSSQL
• Complex sets of rules (rules)
• Use of procedural languages on the server
• Transactions
• Using stored procedures
• Using geographic information
• Trees R-trees (used for index)

[Sharanya]

This new version of PostgreSQL includes a large number of new features and enhancements, including more than 280 fixes and features such as checkpoint distributed, self-tuning of the writing process in the background, so the possibility of asynchronous commit. The latest version of this engine management databases just appeared, and comes with many new developments that place it as a valid alternative proposals regarding MySQL, Oracle or Microsoft. One of the major improvements is the integration of technology HOT (Heap Organized Tuples), which improves the performance of critical databases that are updated with a very high frequency. Other developments affecting the inclusion of so-called 'commits' asynchronous support, SQL / XML, text searches in the databases or the possibility of simultaneous scans on large databases.

[Barsha]

PostgreSQL has always been a database with good performance, it is important to clarify because they are creating unfounded comments that greatly hurts bad reputation as an excellent quality software. The PostgreSQL installation defaults is not the most optimal in a PostgreSQL server must be properly configured for better performance and better utilize the features of the machine. That is a price to pay for a database, or any other product of considerable complexity and potential. Many people get to read between MySQL and PostgreSQL benchmarks made up of simple queries, without much complexity in their constraits and MySQL are winning, but they do not know is that the benchmark itself against Oracle, MySQL also win, ask yourself: does it MySQL makes faster than Oracle? "And / or better option?. Of course not. Note that this version has optimizations in extreme situations well, fairly frequent updates, is a case where solid database make their show, more simple elements MySQL continue to gain in performance. Bear this in mind when making a trial with this new version of PostgreSQL, not be heard to say, with great ignorance, "the truth was that performance did not rise much, MySQL is still faster". Do not confuse my statement with an anti-MySQL, MySQL is an excellent software and for certain solutions is a better choice of PostgreSQL, so you always have to evaluate the problem to recommend the best solution.