pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Svenne Krap <svenne@krap.dk>
To: pgsql-sql@postgresql.org
Subject: Re: Subselects, the Oracle way - slightly OT
Date: Mon, 18 Jun 2001 22:39:36 +0200
Message-ID: <3B2E8328.9896.A58B9B2@localhost> (raw)
In-Reply-To: <8294.992895326@sss.pgh.pa.us>
References: <3B2E6D28.17314.A02C932@localhost>


> That should work fine in 7.1 ...

Ups.. forgot to tell that I was working on 7.0.3 .. upgrade is not an 
option right now.. but I guess you answered already (not possible 
in 7.0) :)

Btw. any idea when cross-database queries will be implementet 
(you know select x.col1, y.col2 from localtable x, foreigndbtable y 
where x.col1=y.col2) ?

A real needy feature, if you ask me :)

Btw. a litte side question:
having a table with quite an amount of data (all 
telephone/addresses in denmark :) which change only very rarely 
(once every 3 months).

I our first setup it is contained in a database for its own (becase 
PGSQL 7.0 - not sure about 7.1) connects rather slowly, if giant 
tables are present. 

Is there any way to speed it up, or is a split database design the 
only way to go ?

Again TIA

Svenne
--
svenne@krap.dk
http://www.krap.dk
ICQ 5434480
PGP-key http://keys.pgp.dk:11371/pks/lookup?op=get&search=0xDF484022
PGP @ http://www.pgp.com / http://www.phpi.com



Message-ID: <3B2E8328.9896.A58B9B2@localhost>
Permalink:  ../3B2E8328.9896.A58B9B2@localhost/
Also on:    postgresql.org/message-id/3B2E8328.9896.A58B9B2@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: svenne@krap.dk
  Subject: Re: Subselects, the Oracle way - slightly OT
  In-Reply-To: <3B2E8328.9896.A58B9B2@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox