5

Is there any possibility of having built-in materialized views in PostgreSQL ?

I don't want Gardner version or somehthing like physical table populated by triggers. I've read that was/is something being deploy...

Stephane Rolland
8,95111 gold badges34 silver badges41 bronze badges
asked Mar 6, 2013 at 8:03
3
  • 2
    It's being developed now,may be will come trun in PostgreSQL 9.3. postgresql.org/docs/devel/static/… Commented Mar 6, 2013 at 9:13
  • There is possibility to delivery a beta version? Commented Mar 6, 2013 at 9:32
  • of course when the beta's start hitting... or you could just build from source... Commented Mar 6, 2013 at 11:00

1 Answer 1

6

A basic version of materialized view are being delivered in 9.3, see depesz's article. However, it's a very limited version as you have to call REFRESH MATERIALIZED VIEW to get the database to update the view. This will hopefully improve to become automatic in later versions soon.

András Váczi
31.8k13 gold badges103 silver badges152 bronze badges
answered Mar 6, 2013 at 9:16
1
  • 1
    It has been improved in 9.4, so you can REFRSH the view concurrently now, if it has any UNIQUE index. See depesz's article: depesz.com/2013/07/22/… Commented May 19, 2015 at 13:43

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.