Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

sfpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group