About

Yugo Nagata is a software engineer at SRA OSS, in charge of research and development related to PostgreSQL. He is interested in database engineering and now working on the implementation of Incremental View Maintenance.

Before this project, he was engaged in an academic research for extending view updatability. He participated in the development of Pgpool-II, a clustering tool for PostgreSQL, in 2011 when he joined SRA OSS, Inc. Japan. His first contribution to PostgreSQL development was in 2012. He also have experiences of technical support, consulting, education about PostgreSQL internal architecture.


Yugo Nagata has presented the following presentations

    Yugo Nagata The Way for Updating Materialized Views Rapidly at CHINA 2020 And PGConf.Asia 2020

    presented by Yugo Nagata

    Materialized view is a feature to store the results of view definition queries in DB in order to achieve faster query response. However, after base relations are modified, view maintenance is needed to keep the contents up to date. REFRESH MATERIALIZED VIEW command is prepared for the purpose, but this has to recompute the contents from a scratch, so this is not efficient in cases where only a ...

    more

    Fri 20 2020 Everything about Postgres