Posts by Year

Browse the blog posts by year

Yogesh Jadhav

Yogesh Jadhav

Big Data Engineer, Python Programmer

2019 1
2018 11
2017 8

2019

Restore multiple MarkLogic Forests simultaneously using Python

11 minute read | 2019-03-25 02:10:00 +0000

Python program to restore multiple MarkLogic Forests simultaneously. This script can be used when you have different number of forests than database forests ...

Back to Top ↑

2018

कोडाचाद्री ट्रेक

4 minute read | 2018-08-30 02:10:00 +0000

कोडाचाद्री पश्चिम घाटातील शिखरांपैकी एक आहे आणि शिमोगा जिल्ह्यातील सर्वात उंच की जिथून आपण शिखरापेक्षा खाली ढग अनुभवू शकतो. ढगांचा एक समुद्र आपण नेहमीच डोळ्य...

GPOPB: Greenplum Object Processing in Bulk

22 minute read | 2018-07-25 02:10:00 +0000

Python utility to process Greenplum objects in bulk and in parallel.

Getting row count for all the tables in Database

4 minute read | 2018-06-20 00:00:00 +0000

As a DBA, Many times we have to collect the row count for all the tables in database. Below are the two steps that can fulfill the requirement of getting the...

Running parallel analyze on PostgreSQL Database

15 minute read | 2018-05-06 02:10:00 +0000

Python program to run analyze on multiple tables in parallel for PostgreSQL Database.

Greenplum Parallel Restore Using Python

31 minute read | 2018-03-20 02:10:00 +0000

Python program to parallel restore greenplum backup in dissimilar number of segment instances. This script has all recommended steps by Pivotal.

Script: Getting email alert for long running queries

8 minute read | 2018-02-09 02:10:10 +0000

Python program send email notification if query is running for longer time.

Script: Greenplum environment refresh

22 minute read | 2018-02-06 02:10:10 +0000

Python script to refresh data between two environments and switch the roles

Log Analyzer for MarkLogic Database Server

12 minute read | 2018-01-23 02:10:10 +0000

Python script to analyze MarkLogic Database Server Logs. It shows bar graph per hour.

Log analyzer using Python Programming Langauge

3 minute read | 2018-01-19 15:10:10 +0000

Give a basic idea for creating a log analyzer using Python Programming

Using pygresql python module with Greenplum

4 minute read | 2018-01-17 17:30:13 +0000

Give a basic idea of using pygresql Python module with Greenplum and PostgreSQL

Greenplum Database Query Performance Checklist

21 minute read | 2018-01-09 17:30:13 +0000

Lists basic troubleshooting of performance issues in Greenplum

Back to Top ↑

2017

How do we do Greenplum Database environment refresh

23 minute read | 2017-12-13 17:30:13 +0000

Python program to switch the roles between the environments

Moving table data from one table to another

3 minute read | 2017-12-05 17:30:13 +0000

A simple trick to move table data from one table to other table

Useful SQL scripts for Greenplum DBA

24 minute read | 2017-12-05 17:30:13 +0000

List of SQL statements which can be used by Database Administrators in day to day life

Guide to create external table in greenplum using Amazon S3 Buckets

6 minute read | 2017-11-18 17:30:13 +0000

Gives a basic idea using S3 bucket as external table in Greenplum Database

Making MarkLogic cluster highly available

7 minute read | 2017-11-03 17:30:13 +0000

Give a basic idea creating highly available MarkLogic cluster

…And finally I got my first bike

4 minute read | 2017-04-27 17:30:13 +0000

Just sharing my experience of getting my first bike

My first GitHub repository for Greenplum DBA

5 minute read | 2017-04-19 17:30:13 +0000

This is my first GitHub Repo created fro Greenplum DBA’s

It’s backend process that authenticates users in PostgreSQL… Not Postmaster Process…

6 minute read | 2017-01-30 17:30:13 +0000

I was confused on how authentication in PostgreSQL works. So, I did some research.

Back to Top ↑