Re: Refer to another database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Kalsch <andreaskalsch(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Refer to another database
Date: 2009-08-04 04:10:37
Message-ID: 14186.1249359037@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas Kalsch <andreaskalsch(at)gmx(dot)de> writes:
> Will it decrease performance to refer to other schemas?

No, not to any noticeable extent. I'm not actually sure whether
parsing would be faster for an explicitly qualified reference or
an unqualified one, but in any case it'd be down in the noise
compared to planning and executing the query.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-08-04 04:10:56 Re: Refer to another database
Previous Message Andreas Kalsch 2009-08-04 03:32:25 Re: Refer to another database