Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux