Re: Refresh Materialized View

[Jayadevan M <maymala.jayadevan@xxxxxxxxx>]

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.jayadevan@xxxxxxxxx> 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