Feb 21-23, 2018

PGConf India

Feb 21-23, 2018

PGConf India

Feb 21-23, 2018

PGConf India

Date

Location

Remaining

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

SlidesRecorded 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?

SlidesRecorded VideoThe 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

SlidesRecorded VideoStarting 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:

SlidesRecorded 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

SlidesRecorded VideoMost 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

SlidesRecorded VideoIn 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

SlidesRecorded VideoHere 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 –

SlidesRecorded 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

Slides.
Recorded VideoRecently 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

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

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

SlidesRecorded 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,

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.

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.

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.

Sponsors of PGConf India, 2017

Platinum Sponsors

Gold Sponsors

Video Sponsors

Media Partner

testimonials / See What People Say About Past Conferences

Terrific to see the growing Postgres community in India, and the terrific turnout. Hats off to the organizers. I’m definitely planning on attending next year.. Goa please!

by Mehboob Alam

No words to say…It was amazing meetup. I am joined in my job before 4 months. After this meetup i get clarity about PostgreSQL and know importance of PostgreSQL. Thank you so much all Speakers and organizers, everything is good. I am waiting for next event. Thanks you PostgreSQL….

by Ramanna Gunde

Best conference i had atttended till now. Well planned.
We were stick to the plan, credit goes to organizers for informing speakers about their time interval that really helped to cover everything which was panned.

PGConf India Location

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.