How to install, configure from source and connect Postgresql on fedora 22

PostgreSQL is a free and open source software developed for general purpose and object-relational database management system. Developed for Postgresql version 4.2 at Berkeley Computer Science department, University of California, it was initially designed to run on UNIX-like platforms.  Postgresql is designed to be portable  on various platforms such as Mac OS X, Solaris, and Windows. It’s a source code that can be obtained under … Continue reading How to install, configure from source and connect Postgresql on fedora 22

Checking for postgreSQL table bloat

Bloated index/tables in postgres DB due to lack of a VACUUM or a badly structured database. An index bloat can slow down your database and consume more storage space than required and therefore it can be important to find out if your database has an index bloat. The VACUUM command marks every row in a page as unavailable and if the page happens to be … Continue reading Checking for postgreSQL table bloat