Re: [GENERAL] a couple of newbie question - deferrable, varchar vs text, 2 dbs
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
Re: [GENERAL] 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/ ---(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
[GENERAL] a couple of newbie question - deferrable, varchar vs text, 2 dbs
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 column types. 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? Thanks ;) ---(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