Sergei Shelukhin wrote:
> 1) Do I understand it correctly that cross database queries are not
> possible?
Yes.
> 2) What's the difference between unlimited length varchar and text
> columns?
Mostly only the spelling.
> 3) Will adding "deferrable" to FKs that reference very large tables
> speed up insert performance for individual inserts? for multiple
> inserts within a single transaction?
I think you can answer that yourself with a quick test.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/