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


ESA Sky: New window to the stars using PostgreSQL

Track: Use Cases

Pilar de Teodoro

April 19, 2016, 2:30PM - 3:20PM


ESA Sky is the  science-driven discovery portal  developed by engineers and scientists working at the European Space Agency to allow users to explore the multi-wavelength sky and to seamlessly retrieve science-ready data in all ESA Astronomy mission archives from a web application without prior-knowledge of any of the missions. The first public beta of the service has been released, future releases will enable retrieval of spectra and will have special time-domain exploration features.
PostgreSQL is the database system chosen to store the data connecting with other PostgreSQL databases in a performant way. The use of materialized views created on top of foreign tables has helped to get a fast system facilitating the integration with other archives, as well as the use of pgSphere to filter data using polygons and healpix functions. The possibility to integrate more data from other Astronomy centers is a reality which will lead us for new challenges regarding  integration, performance, replication and scalability.
We would like to show how ESA Sky works and how we have developed an excellent door to the universe using PostgreSQL.
Check here:

About the Speaker

Pilar de Teodoro is physicist and works at the European Space Agency (ESA)/ESAC Science Data Centre (ESDC) in Madrid, Spain.
After many years working in Oracle Corp., she moved to the European Space Agency working first for the Gaia mission being in charge of the databases for the largest survey of objects in the universe dealing with hundreds of Terabytes of data. After Gaia, she joined the ESDC team where all archives from the different ESA missions are kept. PostgreSQL is the database system most used in the science archives helping the the singularity of every space mission and it is the pillar of the ESA Sky project.

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 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 US 2016 would not take place without the generous support from our sponsors.





Hosted By

Contact info

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