psql

This is quick guide howto install PostgreSQL 8.4 (current stable 8.4.7) database server on CentOS, Fedora and Red Hat. Fedora 14, Fedora...

Updated by JR on Sep 7, 2010 in SQL | 9 comments

This article compares the speed and performance of queries between partitioned and non partitioned PostgreSQL tables. However, it is...

Updated by JR on Sep 7, 2010 in Programming, SQL | 1 comment

As Part 1 (Howto create PostgreSQL table partitioning) shows, making of PostgreSQL partitioning needs a lot of SQL commands. So this Part 2...

Updated by JR on Sep 7, 2010 in SQL | 3 comments

PostgreSQL supports partitioning via table inheritance. So the partitioning is made in such a way that every child table inherits single...

Updated by JR on Sep 30, 2010 in Featured, SQL | 0 comments

Psql is a good tool for the PostgreSQL database management and use. Psql client functioning can easily be improved by adding a few lines...