Stack Exchange
log in

Discussion between ypercubeᵀᴹ and Andreas Dietrich

Discussion between ypercubeᵀᴹ and And…

Imported from a comment discussion on https://dba.stackexchange.com/questions/151169/are-views-harmful-for-performance-in-postgresql/194965#194965
2694d ago – Andreas Dietrich
165
5
info

export all events for this room

Starred posts

ypercubeᵀᴹ
Mar 15, 2018 14:16
CTEs were implemented, from the beginning, this way. I think because there can be modifying CTEs (which other DBMS don't have). And it makes sense to put a fence there, when the CTEs are modifying data.
ypercubeᵀᴹ
Mar 15, 2018 12:33
The bolded statement "using views in Postgres is critically by design(!) and may badly decrease your performance" is general and just plain wrong.