Schedule

 

Registration 8:30 AM 11:00 AM
Opening 9:30 AM 9:40 AM
Robert Haas PostgreSQL Past, Present, and Future PostgreSQL has been a great database for a long time, with an excellent reputation for security, stability, and SQL standards compliance. In recent releases, however, PostgreSQL’s scalability, performance, and feature set have been radically improved, and the next few releases promise to be better still. In this talk, I’ll discuss some of the features that have been added in recent years, those that are new in the current 9.5 release, and those that we can expect to see added in 9.6 and beyond. 9:40 AM 10:30 AM
GE (Predix.io) Sponsor Talk 10:30 AM 10:40 AM
Short Break 10:40 AM 11:10 AM
Abhijit Menon-Sen VACUUM Internals I propose to talk about the internals of VACUUM in Postgres. This will be a 45m talk that discusses the code and underlying data structures in considerable detail, discusses the various phases of the operation, and how they interact with the user-level controls (e.g. cost limits). 11:10 AM 11:55 AM
Amit Khandekar “Logical Decoding : Replicate or do anything you want.” On one hand, there is the low cost physical replication which is well known for its necessity for crash recovery and high availability. On the other hand, systems like Slony exist for cross-version replication, but they come with heavy trigger overhead. Enter Logical replication, which comes with advantages of Slony, that too without the heavy triggers. This is possible because of the feature introduced in PostgreSQL 9.4 : Logical Decoding.
The session introduces the concept of Logical Decoding, and what is the motivation behind introducing it. After briefly explaining internals about logical decoding, its plugin interface, its extensibility, it will focus on the potential range of applications that can make use of the Logical Decoding interface, including Multi-Master Replication, and many different kinds.
11:55 AM 12:40 PM
EnterpriseDB Sponsor Slot 12:40 PM 12:50 PM
Tashee Sponsor Slot 12:50 PM 12:55 PM
Lunch Break 12:55 PM 1:55 PM
Jim Mlodgenski PostgreSQL Foreign Data Wrappers As more and more alternative data stores come into use, the problem of being able to easily use and report on the data scattered across those data stores becomes increasingly difficult. PostgreSQL has a feature called Foreign Data Wrappers that allows external data sources to be queried from PostgreSQL and look like a standard table. Using Foreign Data Wrappers, users can create a report that joins data residing in Oracle, Hadoop and MongoDB all in a single query.
In this talk, Jim will discuss how to set up a Foreign Data Wrapper for various data sources and the pros and cons of using them. We’ll also discuss the growing ecosystem of Foreign Data Wrapper and a little about how to write one.
1:55 PM 2:40 PM
Ramchandran PostgreSQL Deployment Experience in e-Governance Open Technology Group (OTG) , NIC spearheads the adoption of Open Source Tools in various applications developed by NIC. OTG has institutionalized the PostgreSQL RDBMS usage in various e-Governance projects and provides support by using in-house, community and industry experts.
NIC is one of the early adopters of Open Source Tools in India and instrumental for the adoption of these solutions in e-Governance applications. PostgreSQL adoption started with PostgreSQL version 7.x. Since then, PostgreSQL has been deployed for many e-Governance applications. Currently most projects run on PostgreSQL 9.1 and above. The e-Governance data is crucial and hence data recovery strategy is a key design consideration. PostgreSQL’s database features such as Hot-Standby , PITR recovery features and the streaming-replication played a key role for its use in e-Governance.This talk aims at highlighting some of the PostgreSQL data base deployments , usage scenarios and experiences in the e-Governance application space.
2:40 PM 3:05 PM
Himanchali Let’s get into PostgreSQL Performance The talk will include the features and tuning that can be done for performance enhancements of different kind of queries. On the basis of my experience with PostgreSQL, there are some right ways to write a query which can enhance the performance with a big difference in time. I will also discuss things which you should not do while writing a query.
It will include other aspects related to PostgreSQL performance like cache, indexes, DB Server configuration etc.* System and DB Server tuning for better performance
* Right ways to write different kind of queries
* How to make query performance better
* What should be avoided while writing a query
* Understanding cache
* Understanding Indexes
* Role of a DBA for database performance
3:05 PM 3:50 PM
2ndQuadrant Sponsor Slot 3:50 PM 4:00 PM
Ashnik Sponsor Slot 4:00 PM 4:05 PM
Short Break 4:05 PM 4:35 PM
Pavan Deolasee What’s new in Postgres-XL 9.5? As we wind down development of Postgres-XL 9.5 and get the product ready for release, I would like to present several enhancements we have done to Postgres-XL 9.5 to improve performance as well as features added. We will also talk about the challenges faced while maintaining such a large fork of PostgreSQL and techniques to improve maintainability of the software. Finally, I’ll present results from some key performance benchmarks we ran on Postgres-XL. 4:35 PM 5:00 PM
Jeevan/Apoorve Avoiding corruption propogation and important advices to a PostgreSQL DBA Corruptions in the production database are not easy to find them, and it might happen that your application is running fine with that corruption too. However at some point of time it may crash your system badly. For any organization, running databases in the production, the goal should be reliably detect corruption as early as possible, avoid propagating it in backups and have proper recovery plans. If you can’t detect the corruption, it will almost certainly be propagated to backups and if you propagate corruption to backups, its then compromises your recovery plan.This talk gives overview of some utilities which can be used to detect corruption in PostgreSQL like page header check, checksums, pg_dump, pg_catcheck, etc. 5:00 PM 5:45 PM
Closing 5:45 PM 6:00 PM

 

Social:

We are glad to inform you that OpenSCG (http://www.OpenSCG.com), the Silver Sponsors of PGDay February 26th, 2016, have invited all the attendees of the event for an evening of post-PGDay networking over drinks and snacks followed by Dinner at Xtreme Sports Bar.

Address: 16, Hosa Road, Off Sarjapur Main Road, Inside Play Arena, Kaikondrahalli, Bengaluru, Karnataka 560035 Phone:096633 12701

Directions from Marriott
https://goo.gl/maps/9S5FU36r8j92