Re: a couple of newbie question - deferrable, varchar vs text, 2 dbs

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/