Database optimization with the power of PostgreSQL data types

In few moments you will come to know about the magic tool that  lets you to store data using a range of different data types, allowing  the database engine to optimize its use of memory and storage, and also it performs various operations on the stored data more efficiently, effectively with fewer errors.

Data type selection plays an important role in how efficiently your relational database management system functions, and so it is important to be fully aware of the options available to you, and to select the most appropriate data type for your storage needs.

This article will explain the inportant applications of PostgreSQL , and provides you with a ready supply of choices the next time you sit down to optimize your existing databases or create new ones.

TEXT: Storing large blocks of textual data Examples: News stories, product descriptions

VARCHAR: Storing string values of varying length (up to a specified maximum length). Examples: Names, passwords, short text labels

CHAR: Storing string values which will always contain a preset number of characters. Examples: Airline, country or post codes

SERIAL: Automatically numbering data sets, like table records. Example: Table primary keys

NUMERIC: Storing decimal values which require highprecision. Examples: Currency amounts, scientific values

DATE: Storing dates Examples: Birthdays, product expiry dates

FLOAT: Storing decimal values Examples: Measurement, temperature

BOOLEAN: Storing attributes that can only take one of three possible values: true, false and NULL. Examples: Enable/disable, yes/no fields

Most implicit conversions work the way you expect, and I love this.