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

From: "Sergei Shelukhin" <realgeek(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: a couple of newbie question - deferrable, varchar vs text, 2 dbs
Date: 2007-04-03 22:42:36
Message-ID: 1175640156.346220.167590@o5g2000hsb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ;)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Hallstrom 2007-04-03 23:01:48 Re: Nice, web-based SNMP-Frontend for pgsnmpd?
Previous Message Richard Broersma Jr 2007-04-03 21:29:34 Re: assistance needed for autovacuum on the windows version of 8.2.3