Re: a couple of newbie question - deferrable, varchar vs text, 2 dbs - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: a couple of newbie question - deferrable, varchar vs text, 2 dbs
Date
Msg-id 200704050057.10178.peter_e@gmx.net
Whole thread Raw
In response to a couple of newbie question - deferrable, varchar vs text, 2 dbs  ("Sergei Shelukhin" <realgeek@gmail.com>)
Responses Re: a couple of newbie question - deferrable, varchar vs text, 2 dbs  ("Sergei Shelukhin" <realgeek@gmail.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: dropping role w/dependent objects
Next
From: Alvaro Herrera
Date:
Subject: Re: dropping role w/dependent objects