Date

Feb 21-23, 2018

Location

Bengaluru

Remaining

80 Tickets

Speakers

15 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 2017, Schedule

Simon Riggs

Persistence: Key to PostgreSQL’s Success

 Recorded Video
Simon Riggs will talk about the importance of persistence for PostgreSQL’s users, details of our persistence technology and how our community embraces these strengths and values.
Robert Haas

Moving PostgreSQL Forward

Slides   Recorded Video
PostgreSQL has a reputation for developing features in a slow and methodical way, producing very high-quality work, but sometimes taking years before a particular feature reaches full maturity. Why does this happen? What impact does it have on PostgreSQL use and adoption? What would be required for the PostgreSQL development community to move faster?
Rafia Sabih & Dilip Kumar

Query Parallelism in PostgreSQL: Expectations and Opportunities

Slides  Recorded Video
The promising results of parallel sequential scan encouraged us to include parallelism in other operators of PostgreSQL as well. Continuing the fervour, we witnessed several patches proposed for new parallel operators in the last few months. Extending parallelism for the access methods, parallel bitmap heap scan, parallel index, and parallel index-only scans were proposed. Next, to utilise the parallelism at the higher levels of
Ashutosh Bapat

Partition and Conquer Large Data in PostgreSQL 10

Slides   Recorded Video
Starting from v10 PostgreSQL will support declarative partitioning. While the inheritance based partitioning allows us to distribute and maintain the data in smaller tables and apply some query optimizations using constraint exclusion, it requires a lot of maintainance and implementing advanced query optimizations isn't straight forward. Declarative partitioning makes it much easier to maintain partitioned tables and apply query optimization techniques like partition pruning, partition-wise joins, partition-wise aggregation.The talk covers:
  • How
Vinayak Hegde & Ravi Rayapati

Experiences from migrating from Oracle to PostgreSQL

Slides   Recorded Video
We plan to present our experiences from Migrating from Oracle to Postgresql from a datacenter environment to the cloud. The customer was a multi-hundred million dollar company doing marketing automation with lots of large active customers using their service.We plan to present the following 1. The proposed migration strategy 2. Architecture for Postgres instances 3. Challenges in architecture and moving from datacenter to cloud 4. Share benchmarks we
Harisankar PS

Performance Optimizations in PostgreSQL for Web Application

Slides  Recorded Video


Most Ruby on Rails application out there in the world deals with the manipulation and presentation of data. So the speed of our application has a relationship with how fast we work with data. Ruby on Rails, the swiss army knife of web development, is good with presenting data. But when it comes to crunching huge volumes of data, our rails application
Avinash Vallarapu

Online Migration/Upgrade with Seamless Downtime

Slides   Recorded Video
In this proposal, I would like to talk about the methods and tools we implemented to do an Upgrade/Migration of PostgreSQL cluster running on Older version 8.2.13 to a New Version PostgreSQL 9.5.5. There were over 70 Slaves/Cascaded Slaves in replication using Slony 1.2 (Older Version) and all the business logic sits in the database. The most challenging part was, there were 3 Writable Slaves.This
Aniruddha Deshpande & Prajakta Dhote

Postgres Database Performance: Proactive and Reactive Approach

Slides   Recorded Video
Here are a couple of tips to boost the performance of a PostgreSQL database server.Proactive -What to avoid Some general tricks Ugly SQL queries Indexing Vacuum Analyze I/O scheduler stats_temp_directory on a ramdisk Kernel tuningReactive –
  1. Bring up the current pain points
  2. Technical Analysis
    • DISK info
    • CPU/Core info
    • Physical /Swap memory
    • Tools like Splunk
    • CPU and Memory Utilization
    • TPS count
  3. Database Findings
    • DB growth pattern
    • Indexing
    • Dup and Unused
    • Hit ratio
    • Peak
Vijaya Banu

Building National Gram Panchayat Assets Inventory in PostgreSQL

Slides   Recorded Video
Remote Sensing and Geographic Information Systems along with Information & Communications Technology (ICT) and Global Positioning Systems (GPS) play a significant role in the development and growth of the rural areas in India. We live in an era where a well knit network Natural Resources Management System (NNRMS) involving central & state Governments, private sectors, academia and Non-Governmental Organizations is in place for enabling
Sushant Pawar

Tale from Trenches: How Autovacuum, Streaming Replication, Batch Query Took Down Availability And Performance

SlidesRecorded Video
Recently I was caught up in line-of-fire when a production system started behaving abruptly A batch process which would finish in 15minutes started taking 1.5 hours. We started facing OLTP read queries on standby being cancelled. We faced a sudden slowness on the Primary server and we were forced to do a forceful switch to standby.We could figure out that some peculiarities of the application
Akshay Gupta

A Postgres Orchestra

Slides. Recorded Video 
We go over replication strategies, failure scenarios, automatic failovers, clustering and keeping our cluster highly available at a large scale. Instead of describing the failure scenarios theoretically, we will replay them in real-time on our local machines and test the resiliency of the solutions presented. The majority of this talk will attempt to keep the clustering system self-reliant and allow the application code to
Nikhil Sontakke

Cross Regional Business Continuity

Slides   Recorded Video
As PostgreSQL gets deployed in various complex configurations, the need for high availability and disaster recovery within the datacenter and across regions becomes paramount. Recovery Point Objective (RPO) and Recovery Time Objective (RTO) become very important metrics in these scenarios. This talk will discuss failover scenarios and will talk about ways in which HA and DR can be effectively implemented in various deployments to ensure business continuity.
Venkata Gurunadh

10 Useful Tips For Database Optimization

Slides  Recorded Video .  
PostgreSQL is a database management system, used in many different applications throughout the industry. Database optimization refers to a variety of Strategies for reducing database system response time which is an important consideration in any Database World, as databases often are the bottlenecks in the performance of applications their performance becomes crucial. Better performance can either be achieved by using more and faster hardware,
Simon Riggs

PostgreSQL Replication

This training will cover various topics such as:
  • Physical Replication in 9.6 and 10.0
  • Logical Decoding
  • Logical Replication
Ranjeet Dhumal

Postgres Performance Tuning for DBAs and Developers

This training is for DBAs and/or Developers who want to learn some tips and tricks about tuning & troubleshooting PostgreSQL Starting with statement processing this training will cover all aspects of SQL tuning. You will also learn how to benchmark and tune database server parameters for optimal performance.

Gurunath Venkat

PostgreSQL HA and Load Balancing using Pgpool

Deploying PostgreSQL in a high-demand environment requires High-Availability, reliability and scalability. PostgreSQL ecosystem offers the tools you need to build out a robust database system. This training explains a high-level description of tools used to build a high-availability and load balancing solution for PostgreSQL.
Sushant Pawar

PostgreSQL Backup and Recovery

Recoverability and Availability are often confused. Applications often faces longer downtime because of human errors and any level of redundancy will not be enough in such cases. In this training we will help you understand different choices of backup, recovery and planning for backup.
Topics to be covered:
- Why take backups?
- Business SLA - RPO, RTO, Frequency and Retention
- Backup Types
- pg_dump and pg_dumpall
- Restoring dumps - pg_restore
- Partial restore

Sponsors of PGConf India, 2017

Platinum Sponsors

2ndq_logo_color_no_cross

 

taashee_logo


openscg_logo2014_outline

Gold Sponsors


edb_logo_new_001

Ashnik Logo

Video Sponsors


edb_logo_new_001


Media Partner


efygroup-osfy

Become A Sponsor

testimonials / See What People Say About Past Conferences

PGConf India 2017, Speakers

Vijaya Banu

Manager at Bhuvan Technology Incubation & Outreach, ISRO

Vijaya Banu is working as Manager at Bhuvan Technology Incubation &

Ravi Rayapati

Tech Lead at Minjar

Ravi Rayapati has worked on Oracle, MySQL, PostgreSQL, Amazon Aurora &

Dilip Kumar

Principle Software Engineer at EnterpriseDB

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

Prajakta Dhote

Sr. Database Administrator at Mastercard

Prajakta Dhote is working as Senior Database administrator with Mastercard. She

Aniruddha Deshpande

Sr. Database Administrator at Mastercard

Aniruddha Deshpande is working as a senior Postgres database administrator with

Avinash Vallarapu

Sr. Database Consultant at OpenSCG

Avinash Vallarapu is currently working as a Sr. Database Consultant at

Harisankar P S

CEO at Red Panthers Software Solutions

Harisankar P S has been building SaaS application and API's using

Nikhil Sontakke

PostgreSQL Consultant at 2ndQuadrant

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

Vinayak Hegde

Independent Consultant

Vinayak Hegde is an independent consultant with expertise in areas of big

Ashutosh Bapat

Technical Architect, Database Server at EnterpriseDB

Ashutosh has been working in RDBMS development for more than a

Venkata Gurunadh

PostgreSQL Trainer and DBA Consultant at Taashee

Gurunadh Venkata works as a PostgreSQL Trainer and DBA Consultant at

Akshay Gupta

Partner at Nilenso LLP

Akshay Gupta is a partner at Nilenso: an employee-owned software cooperative

Sushant Pawar

Database Consultant at Ashnik

Sushant Pawar is a Database Consultant @ Ashnik Technology Solutions

Rafia Sabih

Software Engineer @ EnterpriseDB

Rafia Sabih is a Software Engineer @ EnterpriseDB

Robert Haas

VP, Chief Architect, Database Server @ EnterpriseDB, PostgreSQL Major Contributor and Committer

Robert Haas is the VP, Chief Architect, Database Server @ EnterpriseDB,

Simon Riggs

Chief Technology Officer, 2ndQuadrant and PostgreSQL Major Developer/Committer

Simon Riggs is the Founder and Chief Technology Officer of 2ndQuadrant.

PGConf India Event FAQS

Yes, there is! Click: PostgreSQL India Youtube Channel
The details about the past meetups can be found on meetup.com: Indian PostgreSQL User Group Meetup Page
The registration details are LIVE now. Please click here to register.

PGConf India Location

Hotel Park Plaza

 

90-4, Outer Ring Rd,

Marathahalli Village, Marathahalli,

Bengaluru, Karnataka 560037

contact@pgconf.in

Get Direction

Contact Us

Call for Papers

Call for papers is out. Please submit your proposals by 13th January 2017 (the earlier deadline was 31st December, 2016).

 

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.

 

Please send in your proposals by email to papers@pgconf.in. Last date is 13th January, 2017.