Views vs sql srfs (not plpgsql)

Does anyone have any data in terms of speed and general effectiveness for
deciding when to use a view or srf (sql srf as opposed to plpgsql) in
postgres? I have tested on relatively small datasets, with mucho joins and
have yet to see much difference when doing explain analyze. Will get around
to larger sets (millions +), but thought I might see what those of you have
been there with postgres 7.3 might say.

Richard Seiersen
rich67dev(at)hotmail(dot)com

>From: Josh Berkus <josh(at)agliodbs(dot)com>
>Reply-To: josh(at)agliodbs(dot)com
>To: David Fetter <david(at)fetter(dot)org>, SF Postgres <sfpug(at)postgresql(dot)org>
>Subject: Re: [sfpug] Parameterized trigger?
>Date: Wed, 17 Sep 2003 11:54:50 -0700
>
>David,
>
>Did you still want me to take a stab at this in PL/pgSQL?
>
>--
>-Josh Berkus
> Aglio Database Solutions
> San Francisco
>

_________________________________________________________________
Send and receive larger attachments with Hotmail Extra Storage.
http://join.msn.com/?PAGE=features/es