On Wed, 20 Mar 2024 at 21:01, Celia McInnis <celia.mcin...@gmail.com> wrote: > Correct. But the initial CREATE VIEW was done as a SELECT from the database, > so if the create view was quick, I thought that the select from the view > would be equally quick. Is this a faulty assumption?
It is. Create view does not run the query, select from the view does, Create view is like compiling a function, it just checks, select from the view is like running the function. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> s=> \timing Timing is on. s=> create temporary view tstview as select pg_sleep(1)::text; CREATE VIEW Time: 153.129 ms s=> select * from tstview; pg_sleep ---------- (1 row) Time: 1009.195 ms (00:01.009) <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Francisco Olarte.
