PostgreSQL performance optimization is a widely discussed issue on the most forums. Although PostgreSQL is shipped with a solid default configuration aimed to fit most setups, it requires fair amount of performance optimization to offer the best. There are basically two major aspects of PostgreSQL database performance optimization. This involves enhancing the use of the hardware and configuration setting, and optimizing the performance queries sent to database. Well, it's not possible for the PostgreSQL developers to tune the default configuration for everyone. We prepared a list of top 10 PostgreSQL performance optimization tips that combines both the above aspects. Full article (947 words) »

Most of the businesses these days use database server. Although commercial databases like Oracle, Microsoft's SQL Server, and IBM's DB2 server are widely used, but the open source databases are fast gaining popularity, especial with the small and mid size businesses.
For decade now open source community has improved upon its quality of software to be more enterprise worthy. This has led to a gradual move from the proprietary, commercial software to open-source software in recent years. A large number of businesses around the world use Linux, the Perl programing language and open source database servers - PostgreSQL and MySQL.

Although the two open source RDBMS seem to converge somewhere, there exist a fundamental asymmetry between the database servers. We would delve into the major differences between PostgreSQL and MySQL that sets them apart.
Full article (2016 words) »

Postgresql command line interface psql presents a stumbling block to any mysql users. Try running psql on command line and you will get a nice and unfriendly error message: FATAL:  database "root" does not exist

Most MySQL users face this problem initially with Postgresql because Postgresql works differently. Full article (87 words) »