Re: Views vs sql srfs (not plpgsql)

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Rich Seiersen" <rich67dev(at)hotmail(dot)com>, sfpug(at)postgresql(dot)org
Subject: Re: Views vs sql srfs (not plpgsql)
Date: 2003-09-17 19:20:15
Message-ID: 200309171220.15524.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

Rich,

> 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.

Not right now, but we will have them by the middle of next month.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse sfpug by date

  From Date Subject
Next Message Elein Mustain 2003-09-18 19:52:15 Network Help?
Previous Message Rich Seiersen 2003-09-17 19:13:20 Views vs sql srfs (not plpgsql)