Category: PostgreSQL
-
Tablespace in PostgreSQL
Tablespace In PostgreSQL, tablespaces enable administrators to specify places in the file system where files representing database objects can be kept. When generating database objects, a tablespace can be referred to by name once it has been created. By using tablespaces, an administrator can control the disk layout of a PostgreSQL installation. This is useful in at…
-
Enabled DAC to connect remotely
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you how to use the DAC and how to enable it for remote connections. DAC- The dedicated admin connection (DAC) can assist you in getting out of a bind. This was created to assist you in connecting to SQL Server and…
-
Page Life Expectancy (PLE) in SQL Server
Hey guys, In this blog I am going to explain you about Page Life Expectancy and How to monitor it. Page Life Expectancy (PLE)- Page Life Expectancy (PLE) is an age of a data page in seconds in the buffer cache or buffer memory after querying the tables with the loading data page into the buffer memory.…
-
Detach and Attach in SQL Server
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you about Detach and Attach Detach SQL Server Database- A SQL Server database is made up of at least two files: a data file (mdf) and a log file (ldf), though there may be additional data files in some circumstances. Since…
-
SQL Interview Questions
You can benefit from this article’s popular SQL Server DBA interview questions and answers. To learn more about SQL interview questions, I would advise you to read this post as well as the SQL Server Interview questions and answers. I made an effort to be very specific in my responses to each question in this…
-
PostgreSQL Index and Types
Hey guys, In this blog I am going to explain you about PostgreSQL Index and Types. PostgreSQL Index- The database search engine can use indexes, which are specialized lookup tables, to speed up data retrieval. An index is simply a pointer to information in a table. An index in a database resembles a book’s back…
-
PG Basic Commands
PG Basic Commands ============================================================================================================== Create a User postgres=# create user user_name with encrypted password ‘mypassword’; CREATE USER s2user WITH PASSWORD ‘***************’; CREATE USER s2user WITH PASSWORD ‘***************’ VALID UNTIL 2040-12-01;CREATE USER s2user SUPERUSER LOGIN PASSWORD ‘12345’;CREATE USER s2user SUPERUSER LOGIN PASSWORD ‘12345’; postgres=# grant all privileges on database sample_db to user_name; ============================================================================================================== Insert a huge Data…
-
PostgreSQL Architecture and Back-end Process
Hey guys, in this blog I am going to explain to you about PostgreSQL Architecture and Back-end Process. PostgreSQL- PostgreSQL is an open-source general-purpose object-relational database management system that is one of the most advanced. Because it is open-source software, its source code is available under the PostgreSQL license, which is a broad open-source license.…
-
Table Partitioning in PostgreSQL
Hello Guys, In this blog, I am going to explain you about table partitioning in PostgreSQL Table Partitioning in PostgreSQL Partitioning – Partitioning involves splitting large tables into smaller ones according to some attribute (like time ranges, regions, or even user ID groups) but can still be treated as one table from the application. This is a…