Posts by Tags

• greenplum 14
• postgresql 12
• python 9
• scripts 7
• SQL 4
• github 3
• marklogic 3
• life 2
• programming 2
• backup 2
• restore 2
• bike 1
• NoSQL 1
• High-availability, 1
• aws 1
• ETL 1
• analyze 1
• sql 1
• bulk-processing 1
• parallel-processing 1
• trekking 1
• travel 1
• parallel 1

greenplum

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

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

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

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 ↑

postgresql

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

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

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

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 ↑

python

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 ...

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.

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

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

Back to Top ↑

scripts

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...

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

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

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

Back to Top ↑

SQL

Greenplum Database Query Performance Checklist

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

Lists basic troubleshooting of performance issues in Greenplum

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

Back to Top ↑

github

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

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 ↑

marklogic

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 ...

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.

Making MarkLogic cluster highly available

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

Give a basic idea creating highly available MarkLogic cluster

Back to Top ↑

life

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

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

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

…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

Back to Top ↑

programming

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

Back to Top ↑

backup

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 ...

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.

Back to Top ↑

restore

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 ...

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.

Back to Top ↑

bike

…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

Back to Top ↑

NoSQL

Making MarkLogic cluster highly available

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

Give a basic idea creating highly available MarkLogic cluster

Back to Top ↑

High-availability,

Making MarkLogic cluster highly available

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

Give a basic idea creating highly available MarkLogic cluster

Back to Top ↑

aws

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

Back to Top ↑

ETL

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

Back to Top ↑

analyze

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.

Back to Top ↑

sql

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...

Back to Top ↑

bulk-processing

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.

Back to Top ↑

parallel-processing

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.

Back to Top ↑

trekking

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

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

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

Back to Top ↑

travel

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

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

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

Back to Top ↑

parallel

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 ↑