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