Refresh Materialized View

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Refresh Materialized View
Date: 2014-01-01 13:12:21
Message-ID: CAFS1N4jWELmbJgfsvgZ3zUnbkJoRbmcE7d2vo3tg2yH3sSf9jA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2014-01-01 13:17:47 Re: Refresh Materialized View
Previous Message Erik Darling 2014-01-01 12:41:21 Re: How to delete completely duplicate rows