On Tue, Mar 07, 2006 at 12:39:55PM -0800, Stephan Szabo wrote: > > On Tue, 7 Mar 2006, Jonah H. Harris wrote: > > > On 3/7/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > > > > I'd personally be more interested in what the impact is on people not > > > using synonyms. How free is any search for synonyms if you aren't using > > > the feature? > > > > > > Unless synonym enablement were a configurable parameter (which wouldn't > > really make sense), the cost would be the same whether they're used or not > > during searching. > > Right, but the response was that "using" synonyms incurred a cost and this > should be documented. However, if there's a cost to people not using > synonyms there's a higher barrier to entry for the feature.
Wouldn't the cost only be incurred if you searched for something in pg_class that wasn't there, and therefor had to fall back to pg_synonym? (At least I'd hope it was coded this way, but I didn't look at the patch...) -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match