PostgresqlHelp

PostgreSQL 13 Beta 1 has been released for testing.

postgres=# show server_version_num; server_version_num -------------------- 130000 (1 row)

PostgreSQL 13 New Features

More than 160 new features have been added in PostgreSQL 13 compared to its previous versions.

PostgreSQL is written in C, so installing PostgreSQL software is nothing but compiling and running all the C-Programs in your source code.

To work with PostgreSQL internals it is highly recommended to learn the basics of C programming.

How to create and compile a C Program on Linux

Create a C program called first.c

[root@prim final]# cat first.c #include<stdio.h> int main(void) { printf("Hello! This is a test prgoram.\n"); }

To compile this program, enter:

PostgreSQL is an open-source database management system. It is a great way to learn to program, design and debug.

One of the main features of PostgreSQL is Extensions.

Extensions of PostgreSQL can be an as small extension as pg_fincore, used to understand the OS cache of your PostgreSQL pages to the large projects like PostGIS and Citus data.

The PostgreSQL extension is a piece of script or code which enhances the functionality of your PostgreSQL server.

In this post, we are going to understand…

PostgreSQL Vacuum is a vast subject. There are many things that can be discussed in vacuuming. But in this post, I am going to touch something interesting.

Before we begin, I have a question for you.

Is vacuum table_name releases space to disk?

And if your answer is NO, then you are wrong.

The answer is MAYBE (terms and conditions apply).

Example.,