views vs pl/pgsql - Mailing list pgsql-performance

From Tomasz Myrta
Subject views vs pl/pgsql
Date
Msg-id 3E196277.5020904@klaster.net
Whole thread Raw
List pgsql-performance
Hi
1. I have plpgsql function having only one query returning 1 value. This
query joins some tables. I read, that plpgsql function saves execution
plan for all queries inside one database connection.

2. Instead of this I can create a view returning one row. How does
postgres work with views? When the plan is being created? What happens
to views which don't have explicit joins? What happens if I create index
on tables after creating a view?

Which one is better and when?

Regards,
Tomasz Myrta


pgsql-performance by date:

Previous
From: yutaka_inada@justsystem.co.jp
Date:
Subject: Re: executing pgsql on Xeon-dual machine
Next
From: Josh Berkus
Date:
Subject: Re: Question on hardware & server capacity