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/ ---------------------------(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
