![mynotesoracledba](/img/default-banner.jpg)
- Видео 77
- Просмотров 154 899
mynotesoracledba
Индия
Добавлен 1 авг 2017
My channel will provide vast knowledge to beginner Dba. We will share the topics which are used to improve the skills.
How To configure synchronous mode replication in postgres
in this video we are going to detail steps of synchronous replication mode
Просмотров: 92
Видео
How to setup streaming replication in Postgresql
Просмотров 3932 месяца назад
How does it works: PostgreSQL streaming replication is a process that replicates data from a primary PostgreSQL database to one or more standby databases in real-time. The key aspects are: 1. The primary server writes changes to its write-ahead log (WAL), which contains all the data modifications. 2. The primary server's WAL sender process streams these WAL records to the standby server's WAL r...
Jenkins-06: Complete Jenkins Backup and Restoration Guide | Safeguard Your Setup
Просмотров 357Год назад
Welcome to our step-by-step Jenkins Backup and Restoration tutorial! 🚀 In the world of software development, Jenkins plays a pivotal role, and ensuring the security of your setup is non-negotiable. Whether you're a seasoned developer or just starting, mastering the art of backups and restoration is essential knowledge. 🔑 What You'll Master: - The Importance of Regular Backups - Seamless Step-by...
Jenkins Tutorial-05: Mastering Plugin Management, User Administration, and UI Navigation
Просмотров 79Год назад
"Jenkins Tutorial: Mastering Plugin Management, User Administration, and UI Navigation Are you looking to optimize your Jenkins usage? Look no further! In this comprehensive tutorial, we cover everything you need to know about managing plugins, handling user accounts, and navigating the Jenkins User Interface (UI) seamlessly. 🔌 Plugin Management: Discover how to find, install, update, and remov...
Mastering Multi-Branch Pipelines in Jenkins :Replay and Restart from any stage| Jenkins Tutorials-04
Просмотров 409Год назад
🚀 Mastering Multi-Branch Pipelines in Jenkins: Replay and Restart from Any Stage | Complete Tutorial Welcome to Mynotesoracledba! In this in-depth tutorial, we're diving into the world of Multi-Branch Pipelines in Jenkins and exploring how you can effectively replay and restart your pipelines from any stage. Whether you're new to Jenkins or looking to level up your pipeline management skills, t...
Jenkins Pipeline Demo:Source,Build,Test and Notifications| Jenkins Tutorial-03
Просмотров 297Год назад
In this Jenkins Pipeline demo, we walk you through the entire process of setting up a comprehensive pipeline for your software development projects. From source code integration to building, testing, and receiving notifications, we cover it all. Learn how to automate your development workflow and streamline your CI/CD processes using Jenkins Pipeline. 🔥 Topics Covered: - Source Code Integration...
PT-04 How to Identify blocking queries in postgresql | Tribute to #Missleman
Просмотров 258Год назад
Learn how to identify blocking queries in PostgreSQL with this quick RUclips tutorial. Master the art of pinpointing and resolving blocking issues for optimal database performance! to identify blocking query; SELECT bl.pid AS blocked_pid, a.usename AS blocked_user, ka.query AS blocking_statement, now() - ka.query_start AS blocking_duration, kl.pid AS blocking_pid, ka.usename AS blocking_user, a...
Jenkins Slave Configuration With Git Poll SCM & Parameterized Build:Step-by-step|Jenkins Tutorial-02
Просмотров 105Год назад
Jenkins Tutorial: Configuring Jenkins Slave with Git Poll SCM & Parameterized Build Welcome to Myntoesoracledba Jenkins tutorial series! In this video, we'll walk you through the process of setting up Jenkins Slave configuration with Git Poll SCM and Parameterized Build. Mastering these essential features will empower you to optimize your Continuous Integration and Continuous Delivery (CI/CD) p...
Jenkins Installation and Email Notifications for Job Failure|Jenkins Tutorial-01
Просмотров 247Год назад
Title: "Mastering Jenkins: Installation and Email Notifications for Job Failure" Description: In this comprehensive tutorial video, learn how to install Jenkins and configure it to send email notifications for job failure status. Jenkins is a powerful open-source automation server that is widely used in the DevOps world. By setting up email notifications, you can stay informed about job failure...
Tutorial 40-What is a list Partition in Postgresql | Understanding List Partitioning in PostgreSQL
Просмотров 495Год назад
Understanding List Partitioning in PostgreSQL - A Comprehensive Overview Description: In this video, we delve into the world of list partitioning in PostgreSQL. List partitioning is a powerful technique that enables us to organize large tables into smaller, more manageable partitions based on specific criteria. 📌 What is List Partitioning? List partitioning in PostgreSQL involves dividing a tab...
PT-03 What is a Optimizer Statistics in Postgresql
Просмотров 289Год назад
In PostgreSQL, optimizer statistics refer to the data and metadata that the PostgreSQL query optimizer uses to determine the most efficient execution plan for a given query. These statistics include information such as the number of distinct values in a column, the correlation between columns, the distribution of data within a column, and more. The optimizer uses this information to estimate th...
How to understand Linux Architecture
Просмотров 141Год назад
here we are going to understand that Linux architecture What is a Linux? Linux is an operating system that uses a monolithic kernel architecture, where the kernel is the central component of the operating system and controls all hardware and software resources. The Linux kernel is responsible for managing system resources such as CPU, memory, I/O devices, and network connections. mynotesoracled...
PT-02 How to read and understand Explain Query Plan in Postgresql
Просмотров 1,3 тыс.Год назад
PT-02 How to read and understand Explain Query Plan in Postgresql
PT-01 Identify slow query and Explain plan in Postgresql
Просмотров 1 тыс.Год назад
PT-01 Identify slow query and Explain plan in Postgresql
Tutorial-04 What are the errors that can occur during the pg_repack ? | Pg_repack series
Просмотров 226Год назад
Tutorial-04 What are the errors that can occur during the pg_repack ? | Pg_repack series
Tutorial-03 How do I run pg_repack? |How to perform the pg_repack| pg_repack Series
Просмотров 918Год назад
Tutorial-03 How do I run pg_repack? |How to perform the pg_repack| pg_repack Series
Tutorial-02 How to install pg_repack in Linux | pg_repack series
Просмотров 879Год назад
Tutorial-02 How to install pg_repack in Linux | pg_repack series
Tutorial 38-What is a system administration function in PostgreSQL | system catalogs schema
Просмотров 254Год назад
Tutorial 38-What is a system administration function in PostgreSQL | system catalogs schema
Tutorial-01 What is a pg_repack in PostgreSQL?| Understanding of pg_repack | pg_repack series
Просмотров 885Год назад
Tutorial-01 What is a pg_repack in PostgreSQL?| Understanding of pg_repack | pg_repack series
Vertical Partition In Postgresql | What is a vertical Partition in Postgresql?
Просмотров 5252 года назад
Vertical Partition In Postgresql | What is a vertical Partition in Postgresql?
Tutorial 37-System information function | pg_catalog| System catalogs schema in PostgreSQL
Просмотров 5562 года назад
Tutorial 37-System information function | pg_catalog| System catalogs schema in PostgreSQL
Tutorial 36-PostgreSQL system catalogs schema (System information tables) | pg_catalog
Просмотров 1,6 тыс.2 года назад
Tutorial 36-PostgreSQL system catalogs schema (System information tables) | pg_catalog
What is a order by clause in postgresql?
Просмотров 2042 года назад
What is a order by clause in postgresql?
Tutorial 33-How to prevent Transaction ID wraparound in PostgreSQL?
Просмотров 1,9 тыс.2 года назад
Tutorial 33-How to prevent Transaction ID wraparound in PostgreSQL?
Tutorial 22-What is a Default Roles in PostgreSQL | PostgreSQL Default Roles
Просмотров 4812 года назад
Tutorial 22-What is a Default Roles in PostgreSQL | PostgreSQL Default Roles
Tutorial 28-What are Data fragmentation and bloat in PostgreSQL | PostgreSQL Bloat
Просмотров 8842 года назад
Tutorial 28-What are Data fragmentation and bloat in PostgreSQL | PostgreSQL Bloat
Tut01.What is the use of system databases in SQL Server | An Overview of SQL server System Database
Просмотров 802 года назад
Tut01.What is the use of system databases in SQL Server | An Overview of SQL server System Database
Tutorial 35-PostgreSQL Cluster command | what is a cluster command in Postgresql
Просмотров 7762 года назад
Tutorial 35-PostgreSQL Cluster command | what is a cluster command in Postgresql
PostgreSQL Logical Backup-Pg-dump| How to take backup using pg_dump
Просмотров 5 тыс.2 года назад
PostgreSQL Logical Backup-Pg-dump| How to take backup using pg_dump
What is a pooling Mode in Postgresql | Pgbouncer Pooling modes | pgbouncer-02
Просмотров 7792 года назад
What is a pooling Mode in Postgresql | Pgbouncer Pooling modes | pgbouncer-02
Could you repeat this process, but on a Windows Server, where there is already an existing database on the primary server? The setup should ensure that the standby server synchronizes with the primary server.
Very nice session given more details about synchronise replication
Keep watching
Amazing explanation. Could you make a new video about Mvcc in postgres
seems like you're reading from a book instead of explaining it
Hi, I have a doubt about reindex. is there any chance of data loss when reindexing?
Every IT tutorial with a thick Indian accent 😂 Go slow mate !
headache from out of focus graphics
Thanks
hello, error when running make, pls help me, whats wrong -bash-4.2$ make make[1]: Entering directory `/var/lib/pgsql/pg_repack-1.4.5/bin' Makefile:34: /usr/pgsql-12/lib/pgxs/src/makefiles/pgxs.mk: No such file or direc tory make[1]: *** No rule to make target `/usr/pgsql-12/lib/pgxs/src/makefiles/pgxs.m
So checkpoint happens before 'bgwriter' writing to the datafiles, infact checkpoint invokes writing dirty buffers to datafiles. Having an Oracle background Im learning Postgres and finding your videos very helpful. Thank you!
how to restart my build from failed build stage in jenkins
mynotesoracledba.medium.com/how-to-create-a-multi-branch-pipeline-job-in-jenkins-12ed358d920
nice session jenkins backup and restore.
Thank you
Insightful, thank you so much 🙏
"promosm" 🌟
Master node worker node Slave is old terminology
Thanks you so much bro✌
Very good explanation!
Please share disk usage query
You can refer this blog wiki.postgresql.org/wiki/Disk_Usage
Nice tutorial, thank you!
Thank you so much
thanx
way to fast bro
Full Video : ruclips.net/video/4LmeXhyL8Io/видео.html
ok good vid
ok
Full video in link: ruclips.net/video/4HFUZdNld0Y/видео.html
Full Video link: ruclips.net/video/RYsr5XGIZmo/видео.html
ok
VM doesn’t exist for indexes
ok
Full video link: ruclips.net/video/g3Ccgh4q9AA/видео.html
nice explanation.
Thank you so much🙏✌
Full video Link: ruclips.net/video/YxLl_SAaRhc/видео.html
Please do video on how to configure and use it barman
Sure mam, will do✌
kindly share the Notes pls!!
Share your email address
Good one!
Thanks aysha✌🙏
thanks!
Thanks jose🙏
Great of your act, you respond to your Viewer, by creating a new video
Without them there is no family 😉
superb....tqu
Thanks for your feed back✌
How to take backup with 100 rows from each table?
Can you pls elaborate your questions
@@raghuldrag I have customers -schema and having 5 tables with 5000 records for each table. Now I want to take customers schema with only 100 records from each table.
@@raghuldrag Table is having 1000 records but I want take backup only 200 records using pg_dump. Is it possible? Tell me how ?
@@mastimasti3898 you can do it but you should create one more table like create table sports as select * from sports_org where sports_name='cricket'; then do pgdump backup
What type of temp database should i use to maintain logs or export logs
Can u pls Specific more about what you want to achieve?
@@mynotesoracledba I have customer table.. i need to push the history logs of the table to temporal table and export as file...
so, can i use temporal tables for maintaining history logs?
is temporal tables valid only till the session...or can i prolong them
@@vijaybaskar6696 it is valid till the sessions
Lovely
Thank you🙏
When you close video don't stop with drawbacks give a solution.
Thanks for you valuable feedback ✌
Thank you for making an informative video. Can you show us how to do vertical partition in Postgres as well? Thanks
Thanks you so much
But my SQL does support sub queries
jajaja This video is uploaded on Jun and the intro makes me smile because im seeing the video the 31-dec pd: happy day from the past to you (reader)
Thank you for your valuable time😊✌
super explanation brother
Thank you bro 😊✌
Really very nice notes. Thanks for sharing
Thanks bro✌
Hi, Nice explanation please share the query that you have shown in the video, thanks in advance
Hi Umashankar, Please find the query details SELECT current_database(), schemaname, tablename, /*reltuples::bigint, relpages::bigint, otta,*/ ROUND((CASE WHEN otta=0 THEN 0.0 ELSE sml.relpages::float/otta END)::numeric,1) AS tbloat, CASE WHEN relpages < otta THEN 0 ELSE bs*(sml.relpages-otta)::BIGINT END AS wastedbytes, iname, /*ituples::bigint, ipages::bigint, iotta,*/ ROUND((CASE WHEN iotta=0 OR ipages=0 THEN 0.0 ELSE ipages::float/iotta END)::numeric,1) AS ibloat, CASE WHEN ipages < iotta THEN 0 ELSE bs*(ipages-iotta) END AS wastedibytes FROM ( SELECT schemaname, tablename, cc.reltuples, cc.relpages, bs, CEIL((cc.reltuples*((datahdr+ma- (CASE WHEN datahdr%ma=0 THEN ma ELSE datahdr%ma END))+nullhdr2+4))/(bs-20::float)) AS otta, COALESCE(c2.relname,'?') AS iname, COALESCE(c2.reltuples,0) AS ituples, COALESCE(c2.relpages,0) AS ipages, COALESCE(CEIL((c2.reltuples*(datahdr-12))/(bs-20::float)),0) AS iotta -- very rough approximation, assumes all cols FROM ( SELECT ma,bs,schemaname,tablename, (datawidth+(hdr+ma-(case when hdr%ma=0 THEN ma ELSE hdr%ma END)))::numeric AS datahdr, (maxfracsum*(nullhdr+ma-(case when nullhdr%ma=0 THEN ma ELSE nullhdr%ma END))) AS nullhdr2 FROM ( SELECT schemaname, tablename, hdr, ma, bs, SUM((1-null_frac)*avg_width) AS datawidth, MAX(null_frac) AS maxfracsum, hdr+( SELECT 1+count(*)/8 FROM pg_stats s2 WHERE null_frac<>0 AND s2.schemaname = s.schemaname AND s2.tablename = s.tablename ) AS nullhdr FROM pg_stats s, ( SELECT (SELECT current_setting('block_size')::numeric) AS bs, CASE WHEN substring(v,12,3) IN ('8.0','8.1','8.2') THEN 27 ELSE 23 END AS hdr, CASE WHEN v ~ 'mingw32' THEN 8 ELSE 4 END AS ma FROM (SELECT version() AS v) AS foo ) AS constants GROUP BY 1,2,3,4,5 ) AS foo ) AS rs JOIN pg_class cc ON cc.relname = rs.tablename JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema' LEFT JOIN pg_index i ON indrelid = cc.oid LEFT JOIN pg_class c2 ON c2.oid = i.indexrelid ) AS sml ORDER BY wastedbytes DESC