DEV Community: RK

What is a tuple in python

RK — Sun, 23 Apr 2023 15:07:02 +0000

A tuple is an ordered collection of elements, similar to a list, but with one major difference: a tuple is immutable, which means that once you create it, you can't modify its contents

https://link.medium.com/T9sEtPdCezb

Explain about Linux Architecture

RK — Tue, 07 Mar 2023 01:35:00 +0000

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.

How to read explain query plan in postgresql

RK — Sun, 29 Jan 2023 17:53:35 +0000

In PostgreSQL, the output of an EXPLAIN query shows the query plan used by the database to execute a particular SQL statement. The output of an EXPLAIN query can be difficult to read, but it provides valuable information about the optimization of a query.

Python For Beginner Series|Day-15

RK — Wed, 14 Dec 2022 18:39:58 +0000

On Day 15, Today we will do some exercises using List functions.
Here we are going to do the exercise to select a random name from a list of names. The person selected will have to pay for everybody’s food bill.

https://mynotesoracledba.medium.com/python-for-beginner-series-day-15-35f7b1b63b5

How to enable the slow query log in Postgresql

RK — Fri, 09 Dec 2022 15:05:14 +0000

We can capture the slow query details using the parameter “log_min_duration_statement”

Also we should consider the below parameters
* logging_collector
* log_directory
* log_filename
* log_statement
https://www.youtube.com/watch?v=g3Ccgh4q9AA&list=PLKShApAWCKLTCQeLLu_z_tHS5wICa4Qs9&index=1

Python For Beginner Series| Day-13

RK — Wed, 23 Nov 2022 01:26:17 +0000

On Day 13, Today we will understand something important topic which we will use multiple times in future. The concept called python List

https://link.medium.com/oa6xEk81avb

What are the errors that can occur during the pg_repack ?

RK — Thu, 17 Nov 2022 16:51:54 +0000

pg_repack VER is not installed in the database

2.program 'pg_repack V1' does not match database library 'pg_repack V2' --version mismatch

relation "table" must have a primary key or not-null unique keys

4.the table "tbl" already has a trigger called repack_trigger

Due to session timeout or bastion disconnect

Another pg_repack command may be running on the table

We couldn't execute the simultaneously pg_repack on multiple tables

Some important points:

Only superusers can use the utility.
Target table must have a PRIMARY KEY, or at least a UNIQUE total index on a NOT NULL column.
Defaults of pg_repack may not be good for critical systems. use --no-kill-backend or -D option to make it more gentle
No DDLs are allowed against the table which is undergoing pg_repack and any session that attempts to do so might get killed.
pg_repack, by default, will attempt canceling the conflicting statements if it is not able to gain AcessExclusive lock-in wait-time
It may proceed to terminate sessions if the total wait exceeds double the amount of wait time. This could lead to undesirable outcomes and outages
Use (-N, --dry-run) Before to perform the pg_repack to understand what would have been repacked and exit

https://www.youtube.com/watch?v=Ngx4bNqpMcI

Python For Beginner Series|Day-12

RK — Tue, 15 Nov 2022 00:24:04 +0000

What is a Randomization?

It is any sort of programming language really useful to create games or if we want to get the result randomly.
Randomization helps to create computer programs that have a degree of unpredictability, especially in games
In order to access the randomness in our program we can import the random module in the code
By using a random module we can generate pseudo-random numbers for various aspects.

https://medium.com/p/b32cd872090f

Python for beginner series | Day-11

RK — Sun, 13 Nov 2022 01:04:15 +0000

On Day 11, we will understand the “continue” statement and the while loop coding activity.

https://link.medium.com/AN2LNeYVTub

Python for beginner series | Day-10

RK — Fri, 11 Nov 2022 18:20:18 +0000

On these Day 10, we are going to understand a coding exercise using a while loop and break statement

https://link.medium.com/S3dON1LiSub

Python for beginner series | Day-09

RK — Thu, 10 Nov 2022 18:31:23 +0000

On these Day 09, We are going to discuss the loops concept in detail

https://link.medium.com/960PdprEQub

How do i use pg_repack

RK — Wed, 09 Nov 2022 00:20:49 +0000

On these video we are going to understand how to perform pg_repack against the database

https://youtu.be/LAfGCVHL9T4