Distributing postgres with postgres-XL for very large astronomical databases
Pilar de Teodoro is physicist and a database expert/database administrator working for the European Space Agency Science Data Centre, located in Madrid, Spain. She has been more that 10 years working at ESA using different database systems. Before that, she was Oracle consultant in Oracle.
When working with databases larger than 10TB that will be heavily read, it is necessary to find different options to improve efficiency, performance and maintainability. In the archives of the European Space Agency, where PostgreSQL is widely used, we have investigated different distributed flavours being postgres-XL the solution that so far is meeting our requirements better. The results of the tests performed will be presented with the conclusions drawn from this research.
- 2018 April 19 10:50 EDT
- 20 min
- PostgresConf US 2018
- Use Cases