GPOPB: Greenplum Object Processing in Bulk
Python utility to process Greenplum objects in bulk and in parallel.
Greenplum
Getting row count for all the tables in Database
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...
Greenplum Parallel Restore Using Python
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
Python program send email notification if query is running for longer time.
Script: Greenplum environment refresh
Python script to refresh data between two environments and switch the roles
Greenplum Database Query Performance Checklist
Lists basic troubleshooting of performance issues in Greenplum
How do we do Greenplum Database environment refresh
Python program to switch the roles between the environments
Useful SQL scripts for Greenplum DBA
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
Gives a basic idea using S3 bucket as external table in Greenplum Database
Python
Restore multiple MarkLogic Forests simultaneously using Python
Python program to restore multiple MarkLogic Forests simultaneously. This script can be used when you have different number of forests than database forests ...
GPOPB: Greenplum Object Processing in Bulk
Python utility to process Greenplum objects in bulk and in parallel.
Running parallel analyze on PostgreSQL Database
Python program to run analyze on multiple tables in parallel for PostgreSQL Database.
Greenplum Parallel Restore Using Python
Python program to parallel restore greenplum backup in dissimilar number of segment instances. This script has all recommended steps by Pivotal.
Log analyzer using Python Programming Langauge
Give a basic idea for creating a log analyzer using Python Programming
Using pygresql python module with Greenplum
Give a basic idea of using pygresql Python module with Greenplum and PostgreSQL
Postgresql
Getting row count for all the tables in Database
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
Python program to run analyze on multiple tables in parallel for PostgreSQL Database.
Script: Getting email alert for long running queries
Python program send email notification if query is running for longer time.
It’s backend process that authenticates users in PostgreSQL… Not Postmaster Process…
I was confused on how authentication in PostgreSQL works. So, I did some research.
Life
कोडाचाद्री ट्रेक
कोडाचाद्री पश्चिम घाटातील शिखरांपैकी एक आहे आणि शिमोगा जिल्ह्यातील सर्वात उंच की जिथून आपण शिखरापेक्षा खाली ढग अनुभवू शकतो. ढगांचा एक समुद्र आपण नेहमीच डोळ्य...
…And finally I got my first bike
Just sharing my experience of getting my first bike
Marklogic
Restore multiple MarkLogic Forests simultaneously using Python
Python program to restore multiple MarkLogic Forests simultaneously. This script can be used when you have different number of forests than database forests ...
Log Analyzer for MarkLogic Database Server
Python script to analyze MarkLogic Database Server Logs. It shows bar graph per hour.
GitHub
My first GitHub repository for Greenplum DBA
This is my first GitHub Repo created fro Greenplum DBA’s
MarkLogic
Making MarkLogic cluster highly available
Give a basic idea creating highly available MarkLogic cluster
SQL
Moving table data from one table to another
A simple trick to move table data from one table to other table