Nijamutheen J

Currently we want to take the backup what are the schema name having kafi and nijam. PreRequest: checking table rows count of particular table. Check the schema’s size. check the available  backup location size. 1.List the schema whoose name start …

A sequential scan i.e when there is no index and postgres has to fetch all the data from disk are a problem area for a cache like this. Since a single seq scan can wipe all of the data from …

The Checkpoint parameters are again playing an importance role to improve the performance of PostgreSQL. Important Note: PostgreSQL 9.5 onwards you can use min_wal_size and max_wal_size instead of checkpoint_segments. If our PostgreSQL set up for heavy bulk operations, after setting the …

LIBPQ   -Library Pooled Quota  Details About Connected Users Using tools  libpq is the C application programmer’s interface to PostgreSQL. libpq is a set of library functions that allow client programs to pass queries to the PostgreSQL backend server and to …

Keyword:Relation -Table,Pages – blocks,Records -Tubles,Row -Item,Datafiles -Files There are two separate access control mechanisms for shared disk buffers: 1.Reference counts (a/k/a pin counts) 2.Buffer content locks. 3.Actually,there’s a third level of access control: one must hold the appropriate kind of …

Postgresql tablespace moving is two types they are: 1. Online moving – with database down 2. Offline moving – without database downwhy moving tablespace ? once default tablespace or non-default tablespace filesystem is full means you will get issue/error  at the …

postgresql tablespace moving is two types they are: 1. online moving – with database down 2. offline moving – without database down why moving tablespace ? once default tablespace or non-default tablespace filesystem is full means you will get issue/error  at …

Scenario: If Postgresql data partition is  running out of disk space How to solve this issue Ans: Option 1:Create a new tablespace on a separate drive and move existing tables to it. ALTER TABLE schema.table SET TABLESPACE tbs1; Or using …

Create a directory mkdir /home/Postdata/pg_data sudo chown postgres:postgres /home/Postdata/pg_data psql -d crsp -c “CREATE TABLESPACE tab1 OWNER u1 LOCATION ‘/home/Postdata/pg_data'”; If I wanted to move my database into this new tablespace: psql -d postgres -c “ALTER DATABASE db1 SET TABLESPACE …

how to find out the database and table a file path refers to on PostgreSQL database ? There are three main patterns for paths: 1.For files in the default tablespace: base/database_oid/filenode id for the relation 2.For files in Non-default tablespace: pg_tblspc / tablespace_oid …

Why Partition : Maintenance of large tables and indexes can become very time and resource consuming. At the same time, data access performance can reduce drastically for these objects. Partitioning of tables and indexes can benefit the performance and maintenance …

Database administration and management is required for any database on which there are continuous business transactions.  If databases across enterprises are not monitored and maintained, then such databases are vulnerable to disasters, which eventually brings downtime to missions-critical application and, …

1. Avoid join if possible use subquery instead of join Note : subqueries can be slower than LEFT [OUTER] JOINS, but in my opinion their strength is slightly higher readability. select GPA from Student where sID in (select sID from Apply …

2ndQuadrant.in offers a clear, comprehensive and scalable support package. This helpdesk is specifically designed to protect and secure your PostgreSQL data and databases. 2ndQuadrant.in guarantees fast query support by a confirmed PostgreSQL expert. Our support formulas Basic formula Unlimited calls and …