Date

Feb 21-23, 2018

Location

Bengaluru

Remaining

300 Tickets

Speakers

20 Professional Speakers

About PGConf India

This conference is part of our efforts to grow the PostgreSQL community by increasing awareness and providing the appropriate training and resources to further PostgreSQL adoption in India.

The conference will cover a wide range of topics, as we expect talks ranging from internals discussions led by leading developers to end-user case-studies from small companies as well as large multinational corporations and government organizations, all who run their businesses on PostgreSQL.

Something for Everyone

Given this wide range of talks, the conference is suitable for many different audiences:

  • DBAs already using PostgreSQL, or considering doing so
  • Developers of any kind of application, from hobbyists to large web- and enterprise applications
  • Decision-makers interested in evaluating the world’s most advanced open source database as an alternative to traditional proprietary products
  • PostgreSQL contributors – code, documentation, support – whatever you help with!
  • Open source enthusiasts in general!
Register Watch video
Alt

Alt

Schedule

Baji Shaik and Jobin Augustine

PostgreSQL Architecture Comparison with other Databases and PostgreSQL Installation/Tuning on different OS platforms

PostgreSQL Conceptual Architecture relating it with Oracle, MySQL and SQL Server. Installation of PostgreSQL on variety of Operating Systems. Important OS Parameters and DB Parameters to be considered before installation of PostgreSQL. Audience and Prerequisites : Beginners, who are looking to learn or migrate to PostgreSQL and Experts who would like to improve their knowledge on PostgreSQL.
Shaikh Mansur

Tools and Techniques: PostgreSQL Database Administration

This training presentation is for PostgreSQL Database Administrators. It covers major topics of PostgreSQL database administration which includes backup and recovery, Point in time recovery, GUI tools and Streaming Replication. New features available in version 10 will be discussed. We will also cover the standard tools and techniques used in Postgres.
Sushant Pawar

Postgres replication techniques

In the training, we will cover various replication techniques that are available in Postgres and we will demonstrate how to setup HA using these techniques.
Nikhil Sontakke

Multi Master Replication

Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status. Developed by 2ndQuadrant, BDR is specifically designed for use in geographically distributed clusters, using highly efficient asynchronous logical replication, supporting anything from 2 to more than 48 nodes in a distributed database. This course introduces the attendee to:* The architecture of the BDR cluster * How to optimally setup
Dilip Kumar

Leveraging intra-query parallelism in PostgreSQL

Intra-query parallelism is a recently introduced feature in PostgreSQL, this requires a comprehensive study to understand it’s utility to extract the best of it for different application environments. Like two sides of any coin, intra-query parallelism may improve performance significantly for some queries and may hurt drastically others. Hence, it is important to carefully tune the system as well as hardware parameters to get most of this complex set of features. In this talk, we will
Satyanarayana Narlapuram

Combine the power of community PostgreSQL and Microsoft Azure to migrate existing or build new apps

Azure Database for PostgreSQL is a fully managed enterprise-ready community PostgreSQL. This service is built for developers and devops using the community PostgreSQL database technology you love without the management and administration burden. In this session, we will walk you through the service capabilities such as high availability, security, and elastic scaling of performance that allows you to optimize your time and save costs. We will also demonstrate how
Ashutosh Kumar Sharma

Monitoring and debugging PostgreSQL

The most common problems users or DBAs face while working on databases is to monitor the health of their databases which includes finding the slow running statements, finding why database systems performance is low during certain intervals or diagnosing the corruption issues. The story for PostgreSQL users is no different. In this talk, we target our PostgreSQL DBAs, users and developers to develop an insight on some of the important monitoring and debugging tools viz, pg_stat_statements,
Ashutosh Bapat

Query optimization techniques for declarative partitioning

Unlike inheritance based partitioning, declarative partitioning introduced in PostgreSQL 10 leaves nothing to infer about how the data is divided into partitions. PostgreSQL 11's query optimizer is gearing up to take advantage of this "no-inference" representation. While basic partition-wise join has been already committed, patches for various techniques like partition pruning, partition-wise aggregate/grouping and partition-wise ordering are proposed on hackers. Partition-wise join, partition-wise aggregates and partition-wise ordering break a large operation into smaller ones enabling
Jim Mlodgenski

Keynote: Postgres: The Evolution of the community

In this presentation, we will discuss the Postgres community and how it has grown beyond ideological boundaries to incorporate all manners of community, technology, and business. Join us in a grand exposition of the evolution of the Postgres community. Where Postgres started, where Postgres is and where Postgres is going!
Ajay Kulkarni

The Inadvertent IoT Platform: PostgreSQL

It’s no secret that the so-called “Internet of Things” isn’t about the Things, but the data. And it is a lot of data. Every day, more of the physical world —manufacturing operations, food production systems, trains we commute on — is connected to the Internet and automated, creating more and more streams of sensor data.Multiply the millions of things by the amount of data per device, and you get an exponentially growing
Priya Ranjan

Postgres as REST API Server without coding

Expose your Postgres schema as REST API enforcing strong securities, roles and permissions within Postgres onto your REST API without any development using Postgrest.
Jobin Augustine, Harikrishna

High Availability for Postgres using Opensource tools

Requirement for High Availability is always growing. Especially for competing with proprietary database systems which offer powerful HA solutions. Information Technology world is expecting Postgres community to achieve 99.999% availability. This is achivable only if we can eleminate single point of failures and maximize redundancy. Thanks to ever growing innovations in OpenSource world, we have excellent solutions emerging like Patroni. which works on the top of etcd which implements
Mrs Mahalakshmi Narayanan, Dr A Mohan

Tamil Nadu State Spatial Data Infrastructure and Spatial Decision Support Systems : A PostgreSQL with PostGIS Implementation

Tamil Nadu Government has initiated setting up of Spatial Data Infrastructure(SDI) for the entire State to host the repository of spatial layers of various State Government Departments, with a suitable framework for its sharing and analysis for decision support through National Informatics Centre-TNSC. NIC-TNSC, a major IT Service provider for State Government of Tamil Nadu and Central Government Departments in the State, has been using PostgreSQL since its 8.1
Rajesh Madiwale

Self Healing PostgreSQL with Predictive Analysis

A DBA's primary responsibility is to maintain the stability of production database systems. We are hearing autonomous databases that require no manual interventions and less DBA efforts with reduced cost. In this talk, i would like to talk about the routine manual maintenance activities on PostgreSQL that can be automated and the solutions that have helped us enable Self Healing for PostgreSQL with reduced DBA efforts. Self Healing is
Amit Sharma

Postgres System Catalogues

A catalog is a grouping of all the information in an organized manner. It facilitates you in understanding the current status and then helps you in making informed decisions.Similarly, Postgres System Catalog is a window to what all is going on with the Database. It contains metadata about all the databases and objects in the cluster. Reading and interpreting the information in the systems catalogs can provide vital insights
Nikhil Sontakke

When and how to use multi-master replication and BDR

Keeping your data in more than one place is vital for business continuity, and databases are no exception. Backups are great, but they won't help you when your normally-connected EU, US and Indian operations all want to continue operating during a major WAN outage. Multi-master replication systems like Bi-Directional Replication (BDR) for PostgreSQL can help solve some users' availability challenges in a globally distributed environment... if it's applied correctly.
Mohamed Tanveer

Debug and Tune a PL/pgSQL Function

Finding performance problems within PL/pgSQL functions and stored procedures can be difficult, especially when the code is nested. This is because PL/pgSQL creates a cloak over whatever is happening inside. The only thing visible in system or extension views, such as pg_stat_activity or pg_stat_statements is the query, sent from the client. In the case of invoking a stored procedure, that is just the outermost stored procedure call.Target Audience:Developers and
Hitul Mistry

PostgreSQL migration from AWS RDS to EC2

PostgreSQL can be self hosted on any server or can be hosted by cloud providers as DAAS(Database As Service). Cloud providers like AWS RDS, Heroku, Google cloud etc provides DAAS for PostgreSQL. When we use hosted database it gives us advantages and disadvantages.In this talk I'll go through our story of why we migrated from AWS RDS and moved to self hosted PostgreSQL, what were challenges, how we migrated,
Shaji Albert

Historical reference and Data integrity – From e-Governance perspective

The Stationery Department, Govt. Kerala uses Postgres as back-end of our e-Governance application. Our application mainly handles stock accounts and file movements. We have faced two specific problems that related with the data storage.1. As it handles stock accounts every change made in the db should be stored for future reference (Historical data reference of each row).2. Notes written in each Government files are very sensitive and should not
Rajesh Kumar

Building GIS/LBS platform using PostgreSQL

This presentation is to demonstrate with examples, how our experience has been in: Setup GIS/LBS(Location Based Service) using PostgreSQL and its extensions, cover various GIS(Geographical Information System) systems, commonly used GIS/Spatial data types(Raster and Vector) and how PostgreSQL supports the same. We will also present how PostgreSQL can be used to prepare spatial database using available FOSS tools(QGIS.,).We will Also talk about the two other main players in this
Viswanatha Shastry Medipalli

One of the Biggest Migrations from Oracle to PostgreSQL that involved 2000 Functions and 1.5 TB of Data

In this talk, I would like to discuss about one of the Major Migrations that ever happened from Oracle to PostgreSQL. This is for one of the largest trading companies in the world. It is a migration that involved over 2000 complex Functions/Procedures and around 300 complex views. I would also discuss the methods used to migrate 1.5 TB of Data from Oracle to PostgreSQL within 4 hours of downtime.Target Audience
Madhav Khakhar

10 Years of Postgres in Production

We have been using postgres from the very start of our company - Directi. The talk will give an overview of how our experience has been so far, alongwith the configuration of postgres and auxilliary components that we have in place. The talk will cover the following topics:* >10 years of Postgres in production . The topic will cover our experience with postgres in production, size of database and it's
Rafia Sabih

Benchmarking PostgreSQL: Lessons learned

In this paper we will analyse some of the popular industrial benchmarks, viz, TPC-B, TPC-C, TPC-H, and TPC-DS. This talk describes the process of creating benchmarks using PostgreSQL, analysis of the results and methodologies for their comparison. We will share the lessons we learned while benchmarking parallelism and partitioning related patches. Additionally, we will highlight the benchmarking best practices for OLTP workloads as well. In short, we intend to convey what to expect from these benchmarks
Abhijit Menon-Sen

Postgres and the Write-Ahead Log

The Write-Ahead Log (WAL) is the mechanism by which Postgres achieves resilience in the face of hardware crashes, and the basis for both physical and logical replication. This talk will discuss the concept of write-ahead logging, its implementation in Postgres, and examine how its operation is affected by the server configuration. Join us for an in-depth illustrated tour of one of the most central subsystems in Postgres, as we
Matvey Arye

Re-engineering PostgreSQL as a time-series database

Time-series data is now everywhere—IoT, user event streams, system monitoring, finance, adtech, industrial control, transportation, and logistics—and increasingly used to power core applications. It also creates a number of technical challenges: to ingest high volumes of structured data; to ask complex, performant queries for both recent and historical time intervals; to perform specialized time-centric analysis and data management. And this data doesn’t exist in isolation, entries must often be
Pavan Deolasee

Power of Indexing

PostgreSQL supports many powerful indexing methods such as BTree, Hash, BRIN, GIN, GiST etc. Each of these indexing methods have its distinct capability. In this talk, we shall look at some of the indexing strategies supported by PostgreSQL, look at their pros and cons and understand when and how to use them. Time permitting, we shall also discuss what it would take to implement a new indexing method in
Pallavi Sontakke

Testing Frameworks in PostgreSQL

Discussion on existing 'Testing Frameworks in PostgreSQL':
  • Regression Tests
    • Running SQL commands; testing with expected output formats
  • Isolation Tests
    • Concurrency tests.
  • TAP tests
    • Test Anything Protocol
    • Running SQL and virtually any Linux/shell commands. Testing success of commands.
  • SQLSmith
    • Crash Recovery tests with random SQL queries.
  • Code Instrumentation
    • Testing recovery code of PostgreSQL - with example.

Sponsors of PGConf India, 2018


Diamond Sponsors


2ndq_logo_color

 


edb_logo_new_001


Platinum Sponsors


openscg_logo


Timescale_Logo_Tiger_Stack_FullColor_Web


MSFT_logo_rgb_C-Gray


Dinner Sponsor



MSFT_logo_rgb_C-Gray


Gold Sponsors



taashee_logo


Media Partner



EFY_logo

Become A Sponsor

testimonials / See What People Say About Past Conferences

PGConf India 2018, Speakers

Ajay Kulkarni

Co-Founder/CEO at TimescaleDB

Ajay Kulkarni is the CEO and Co-founder of TimescaleDB, developers of

Mrs Mahalakshmi Narayanan

Technical Director @ National Informatics Centre

Mrs. Mahalakshmi Narayanan is a Technical Director @ National Informatics Centre,

Sunil Kamath

Principal Program Manager @ Microsoft Database Systems

Sunil Kamath is Principal Program Manager at Microsoft Database Systems Group

Jim Mlodgenski

CTO @ OpenSCG

Jim has more than 20 years of experience developing data intensive

Pavan Deolasee

PostgreSQL Consultant @ 2ndQuadrant

Pavan Deolasee has been associated with PostgreSQL since 2006. He is

Rajesh Madiwale

Database Consultant @ OpenSCG

Rajesh Madiwale has over 4+ years of total IT experience in

Harikrishna Boorgadda

Architect @ OpenSCG

Harikrishna works as an Architect @ OpenSCG. He has a

Jobin Augustine

Architect @ OpenSCG

Jobin is an Architect @ OpenSCG; He is a Database

Dharshan B D

Senior Software Developer @ Latlong

Dharshan works as a Senior Software Developer @ Latlong. He

Rajesh Kumar

GIS Tech Lead @ Latlong

Rajesh works as a GIS Tech Lead @ Latlong; He

Pallavi Sontakke

Developer @ 2ndQuadrant

Pallavi Sontakke works as Developer @ 2ndQuadrant

Shaji Albert

IT Nodal Officer @ Govt. of Kerala

Shaji Albert works as a IT Nodal officer of Stationery

Viswanatha Shastry Medipalli

Architect @ OpenSCG

Viswanatha Shastry has 18+ years Development, Testing, Project Management experience with

Madhav Khakhar

Operations Engineer @ Endurance International Group

Madhav Khakhar is an Operations Engineer in System Architect Team

Hitul Mistry

Sr. Tech Architect @ Coverfox Insurance

Hitul is Sr. Tech Architect at Coverfox Insurance. He is

Ashutosh Kumar Sharma

Software Engineer @ EnterpriseDB

Ashutosh works as a Software Engineer @ EnterpriseDB; he has been

Amit Sharma

Manager Support @ EnterpriseDB

Amit works as Manager Support @ EnterpriseDB and has been working

Abhijit Menon Sen

POSTGRESQL CONSULTANT @ 2NDQUADRANT

Abhijit Menon-Sen is a consultant for 2ndQuadrant and has been contributing to

Priya Ranjan

Architect @ SLB

Priya Ranjan is an Architec with SLB, He has over

Dilip Kumar

Principle Software Engineer @ EnterpriseDB

Dilip Kumar is working as Principal Software Engineer at EnterpriseDB. Dilip

Nikhil Sontakke

PostgreSQL Consultant @ 2ndQuadrant

Nikhil is a Postgresql Consultant at 2ndQuadrant. He has been a

Ashutosh Bapat

Associate Database Architect, at EnterpriseDB

Ashutosh has been working in RDBMS development for more than twelve years

Rafia Sabih

Software Engineer @ EnterpriseDB

Rafis Sabih works as a Software Engineer @ EnterpriseDB

PGConf India 2018, Registration Details

EARLY BIRD ALL INCLUSIVE

₹4,000

All Inclusive Pass
Training Day (21st Feb, 18)
Conference Days (22-23rd Feb, 18)
Lunch/Snacks on all days
Last Date: 31st Oct, 17

Full Pass

₹5,500

All Inclusive Pass
Training Day (21st Feb, 18)
Conference Days (22-23rd Feb, 18)
Lunch/Snacks on all days
10% Early Bird Discount
Use Code: EARLYBIRDJAN
Last Date: 31st Jan, 18

Subscribe to our announcements

registing

PGConf India Event FAQS

Yes, there is! Click: PostgreSQL India Youtube Channel
The registration details are yet to be announced. Please enter your details here to get the latest updates.

PGConf India Location

Hotel Park Plaza

90-4, Outer Ring Rd,

Marathahalli Village, Marathahalli,

Bengaluru, Karnataka 560037

Get Direction

Contact Us

PGConf India 2018, Paper Selection Committee


Call for Papers

Call for papers is now CLOSED.

We currently do not have budget to sponsor international travel/stay, but we would be happy to mention your company as a Travel Sponsor on our website, if your talk is selected.

Last year’s conference was attended by more than 250 people and we expect the count to go upto 300 or more this year. So this gives you a great opportunity to present your work in front of a large audience.

General Guidelines to follow when submitting your paper

 

If you are doing something interesting with PostgreSQL, please submit a proposal. You might be one of the backend hackers or work on a PostgreSQL related project and want to share your know-how with others. You might be developing an interesting system using PostgreSQL as the foundation. Perhaps you migrated from another database to PostgreSQL and would like to share details. These, and other stories are welcome. Both users and developers are encouraged to share their experiences.

 

Here are a few ideas to jump start your proposal process:

 

  • novel ways in which PostgreSQL is used
  • migration of production systems from another database
  • data warehousing
  • tuning PostgreSQL for different work loads
  • replication and clustering
  • hacking the PostgreSQL code
  • PostgreSQL derivatives and forks
  • applications built around PostgreSQL
  • benchmarking and performance engineering
  • case studies
  • location-aware and mapping software with PostGIS
  • PostgreSQL features in development
  • research and teaching with PostgreSQL
  • things the PostgreSQL project could do better
  • integrating PostgreSQL with 3rd-party software
  • Both users and developers are encouraged to share their experiences.
[/vc_column][/vc_row]