PGConf US 2016 is a past conference. For the latest conference, please click here

 

HawkEye On Postgresql

Track: Operations

Adarsh Sharma

April 19, 2016, 11:40AM - 12:30PM

Abstract

InMobi is worlds largest independent mobile advertising network serving 138 billion ads per month. PostgreSQL is one of the data stores behind this scale and this talk is about various issues which we encountered in production and also how did we solve the same. I would like to share in depth knowledge and my experience after solving these issues.

1. Connection limit exceeding issue
2. temporary file limit issue due to a bad joins in query
3. Same queries running multiple times for more than an hour - Missing Index and statement_timeout
4. FATAL: could not send data to WAL stream: server closed the connection unexpectedly -- transient issues NIC and TOR issues
5. Object ownership and Releases
6. Vacuum issue for tables updated frequently
7. OOM error -
8. xlog filling the disk due to failure of archive_command
9. too many partitions and max_locks_per_transaction issue
10. PostgreSQL partitions and INSERT 0 0 issue
11. Idle in transaction
12. FATAL: requested WAL segment 00000002000032A80000002B has already been removed
13. ERROR: could not read block xxx of relation base/xxx/xxx: I/O error
14. ERROR: could not read block xxx in file "base/xxx/xxx": reindex
15. _bt_restore_page: cannot add item to page -- recreate the index
16. Cache lookup failure for index during pg_dump
17. Streaming Replication fails due to tablespace folders on Master/Slave
18. conflict with recovery

About the Speaker

Open Source Database Professional with major expertise in Postgresql/Mysql and Nosql data stores. Love to play cricket and Awesome Chef for Friends Only :)

Blog : http://technology.inmobi.com/blog/24-7-monitoring-and-alerting-of-postgresql

Come Join Us!

Tickets for PGConf US 2016 on April 18-20, 2016 are available through EventBrite.   The first day, April 18, is dedicated to training sessions and the regulated industry summit. Trainings must be purchased as separate tickets and are only for those individual trainings. A "Regular Admission" ticket will give you access to the main conference on April 19th and 20th, the Regulated Industry Summit on April 18th, and the 20th Anniversary Party on April 19th.  We also have tickets provided for attending only certain events, such as the Regulated Industry Summit or the 20th Anniversary Party.

If you are a student and interested in attending PGConf US 2016, we are offering a discount rate of $49 for admission. Please email pgconf@postgresql.us to register. You must be an active student at the time of the conference.

PGConf US 2016 is hosted by the United States PostgreSQL Association, which is a registered 501(c)(3). All ticket sales go directly to the program of PGConf US 2016 and any proceeds are used for the ongoing activities of the United States PostgreSQL Association, which include sponsoring PostgreSQL meetup groups, providing educational materials for PostgreSQL, and sponsoring speakers to discuss PostgreSQL at various events.

If you have any questions, please reach out to us at pgconf@postgresql.us

PGConf US 2016 would not take place without the generous support from our sponsors.

Platinum

Gold

Silver

Bronze

Hosted By

Contact info

If you have any questions, comments, concerns, please feel free to contact us using the information below.