Postgres Pro
Downloads
Home   >   mailing lists

Re: Refresh Materialized View - Mailing list pgsql-general

From Jayadevan M
Subject Re: Refresh Materialized View
Date
Msg-id CAFS1N4iGnnDwnmNuRVd1rbKecxHVZyADmQr81eyscA+Byo9MDQ@mail.gmail.com
Whole thread Raw
In response to Refresh Materialized View  (Jayadevan M <maymala.jayadevan@gmail.com>)
Responses Re: Refresh Materialized View  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
Tree view
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@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

pgsql-general by date:

Previous
From: Jayadevan M
Date:
Subject: Refresh Materialized View
Next
From: bricklen
Date:
Subject: Re: How to delete completely duplicate rows