Month: July 2022
Patch db node(linux server node) for ExaCC from oel6 to oel7
Updating the Exadata System Software on database servers is a process that entails patching the entire Oracle Linux operating system, and related Exadata software rather than just updating single packages. Updating the operating system does […]
810 total views
Check the PostgreSQL plan for visualization
Today we will see how to generate plans in graphical form freely in PostgreSQL. Try to generate a plan in json format by using the below prefix before any query you want to check plan […]
575 total views
Table partition in PostgreSQL
Table partitioning is the practice of splitting a large table into smaller sub-tables and each sub-table is created using separate CREATE TABLE commands. So every time you query data, PostgreSQL scan and process a smaller […]
596 total views
Files and Forks in Postgres
All information associated with a relation is stored in several different forks1 , each containing data of a particular type. At first, a fork is represented by a single file. Its filename consists of a […]
818 total views