PostgreSQL Online Survey – Results For a better experience of results, switch to desktop mode on your mobile browser [may take a second or two to load the results]. Alternatively, you can click here Also, read What does make and make install mean in PostgreSQL Thank you for giving your valuable time to read the … Read more
PostgreSQL Online Survey – Everything you need to know how people are using PostgreSQL In this survey, I just wanted to understand how people are using PostgreSQL and wanted to give the information to the community [survey will be loaded here in a second or two] Don’t forget to see the results here Also read, … Read more
What does the below code snippet really mean in PostgreSQL while installing software? ./configure make make install We will understand it in this post. PostgreSQL is written in C, so installing PostgreSQL software is nothing but compiling and running all the C-Programs in your source code. We will do that with an example., How to … Read more
[postgres@stagdb pg_dynshmem]$ ls -lrt total 8 -rw——- 1 postgres postgres 6928 Feb 17 16:36 mmap.2106693104 [postgres@stagdb pg_dynshmem]$ pwd /u01/pgsql/10/pg_dynshmem There is a file in pg_dynshmem sub-directory under PostgreSQL data directory. But what is that file? The answer is here, But before we understand that, we will have to understand some basics. If you want to … Read more
What happens when you execute a transaction in PostgreSQL? The block will be fetched to shared buffers, executed there and upon commit, the dirty buffer will leave to disk again, but how does that happen? The answer is here. PostgreSQL is an ORDBMS software, Let’s ignore O for time being (we will have a separate … Read more
Drop Database in PostgreSQL 13 Warning: The information provided here is based on unsupported development version of PostgreSQL 13. DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. It cannot be executed while you are … Read more
Media failure is one of the crucial things that the database administrator should be aware of. Media failure is nothing but a physical problem reading or writing to files on the storage medium. A typical example of media failure is a disk head crash, which causes the loss of all files on a disk drive. … Read more
In this post we are going to understand PostgreSQL Page Layout in detail. Bonus is coming up towards the end!! Do I have ORACLE’s PCTFREE and PCTUSED kind of mechanism in PostgreSQL? PostgreSQL Page Layout Each data file in PostgreSQL is divided into PostgreSQL disk blocks of 8 Kb each.The blocks are numbered sequentially, 0 … Read more
This post answers the following question with comprehensive details. How much memory you need to give to your shared buffers in PostgreSQL and why? Bonus!! Why my RDS postgreSQL shared buffers uses 25% of system RAM where as Aurora’s shared buffers is 75%? The answer is here. Understanding OS Cache vs Shared Buffers in PostgreSQL … Read more
The PostgreSQL certification questions mentioned below are just for understanding purpose and we do not guarantee that they appear in the exam. Please read the questions to understand the difficulty level of the certification exam. Sample PostgreSQL Certification Questions You are working as a PostgreSQL DBA, you want to remove all obsoleted rows of the … Read more