Search Postgresql Archives

Re: Constraint exclusion-like behavior for UNION ALL views

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Mar 29, 2017 at 12:19 PM, Tony Cebzanov <tonycpsu@xxxxxxxxx> wrote:
Are either of these things that could be supported in the future?  If not, is there a better way to get this kind of behavior so that materialized views are more useful when the amount of data increases and it's not feasible to update them in their entirety?

​The current implementation of materialized views has limitations​, some of which you've listed.  Materialized Views can be (and previously were) manually implemented using triggers - and you can still do so.  I recall seeing some recent blog articles discussing various schemes for materialized views and their pros and cons.

That said, I'm not sure what using materialized views instead of normal tables buys you in the first place.  I could see possibly using a materialized view as the current month's table but the historical tables usually don't require refreshing.

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux