Thanks :)
As for pt3, I don't have the database I will use yet so it's hard to
test :(
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
1) Do I understand it correctly that cross database queries are not
possible? Two dbs on the same server are used in this case.
2) What's the difference between unlimited length varchar and text
columns? I am mostly interested in performance, namely = 'blah' and
like '%blah%' queries over these co