Date

March 2, 3 2017

Location

Bengaluru

Remaining

120 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

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

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

Query Parallelism in PostgreSQL: Expectations and Opportunities

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 the plan tree came parallel
Ashutosh Bapat

Partition and Conquer Large Data in PostgreSQL 10

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 to set up and maintain
Vinayak Hegde

Experiences from migrating from Oracle to PostgreSQL

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 ran on AWS and
Harisankar PS

Performance Optimizations in PostgreSQL for Web Application

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 starts to slow down. Here

Avinash Vallarapu

Online Migration/Upgrade with Seamless Downtime

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 talk includes :- Replication from
Aniruddha Deshpande

Postgres Database Performance: Proactive and Reactive Approach

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 time hit ratio
    • Top SQL
Vijay Banu

Building National Gram Panchayat Assets Inventory in PostgreSQL

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 the integration of Remote Sensing,
Sushant Pawar

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

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 code and batch process were
Akshay Gupta

A Postgres Orchestra

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 be sufficiently isolated from the
Nikhil Sontakke

Cross Regional Business Continuity

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.

Sponsors of PGConf India, 2017

Platinum Sponsors

2ndq_logo_color_no_cross

 

taashee_logo

Gold Sponsors


edb_logo_new_001


 

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

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.

See all speakers

PGConf India 2017, Registration Details

Early Bird

₹1200

3rd March Conference Day Pass
Training not included
Individual Registration
Last Date: 15-01-2017

Group Booking

₹1200

3rd March Conference Day Pass
Training not included
Group of 5 or more
Last Date: 01-03-2017

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.