To answer my own question, I saw this thread - http://postgresql.1045698.n5.nabble.com/Efficiency-of-materialized-views-refresh-in-9-3-td5762618.html I think that does answer my questions. Nothing has changed? Regards, Jayadevan
On Wed, Jan 1, 2014 at 6:42 PM, Jayadevan M <maymala.jayade...@gmail.com>wrote: > Hello all, > A few questions about materialized views. > When I refresh a materialized view, is it a DELETE/INSERT behind the > scenes? > Do we need to vacuum to reclaim space? > If a query is executed against the view when the refresh is happening, > will the query see the data before the refresh started? > Does the refresh result in exclusive locking? > Regards, > Jayadevan >
