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

PGConf India 2018, Schedule - To Be Announced

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

PostgreSQL and eGovernance @ National Informatics Centre

Governments both Central and State have vision of reaching Citizen,Business Community at their door steps by reducing the overall cost of each application roll-out. National Informatics Centre is a premier agency involved in consultancy, design,development and deploying applications to both Central Ministries and State Government departments. The services provided to public are mostly free of charge or at nominal cost. The over all cost of application gets reduced with the use of stable open source solutions

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

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

Testing Frameworks in PostgreSQL

Discussion on existing 'Testing Frameworks in PostgreSQL': - Regression Tests Running SQL commands; testing with expected output formats - TAP tests Test Anything Protocol Running SQL and virtually any Linux/shell commands. Testing success of commands. - Test coverage Use gcov & lcov - to find line, branch, and function coverage

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.

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

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

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

Sponsors of PGConf India, 2018


Diamond Sponsors


2ndq_logo_color

 


edb_logo_new_001


Platinum Sponsors


openscg_logo

Become A Sponsor

testimonials / See What People Say About Past Conferences

PGConf India 2018, Speakers - To Be Announced

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

Conference Pass

₹3,000

Conference Pass
Conference Days (22-23rd Feb, 18)
Lunch/Snacks on conference days
20% Early Bird Discount
Use Code: EARLYBIRDNOV
Last Date: 20th Dec, 17

Register now

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

[/vc_column][/vc_row]

Jim Nasby

Chief Data Architect at OpenSCG

Jim Nasby is a data geek who's been using databases in

Sameer Kumar

Consultant at Ashnik

Sameer has been working on Database Solutions for last 8 years.

Dr. Gianni Ciolli

PostgreSQL Consultant/Trainer at 2ndQuadrant

Dr. Gianni Ciolli is Head of Professional Services at 2ndQuadrant. Before

Ashutosh Bapat

Technical Architect, Database Server at EnterpriseDB

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


Call for Papers

Call for papers is now CLOSED.

We currently do not have budget to sponsor speaker 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.