> 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.
Aglio Database Solutions
In response to
sfpug by date
|Next:||From: Elein Mustain||Date: 2003-09-18 19:52:15|
|Subject: Network Help?|
|Previous:||From: Rich Seiersen||Date: 2003-09-17 19:13:20|
|Subject: Views vs sql srfs (not plpgsql)|