Re: postgres gurus.

On Thu, Nov 23, 2000 at 12:26:06AM +0100, Giovanni Tummarello wrote: > > > i have 2 databases on the same postgres installation and need to join the > > > results from a table in each database .. i would expcet something like > > > > why cant the tables be in the same database? > > afaik this isnt possible with pg... > > We wrote a db based web site.. so we had a db.. then all the sudden the > requirements became that we had to handle N identically shaped sites on the > same machine.. the first thing that popped to my mind is virtualizing the DB > name and to have identical tables in different DB names.. works great until you > have to do a search engine which searches in all the sites (DBs at this point) > .. this would require a query that collects data from different databases or to perhaps you can restructure your db ever so slightly and put the sites in one db. this does add an extra join and/or compare pretty much everywhere though, as compared to only having the slowness with the search... > do it all in PHP.. i have done it but ran into other major problems (See the > general PHP leak under the thread "Huge Memory Leak") its a hard problem. j. -- .----------+------------------------------------. |John Slee `-----------. <john@chirp.com.au>| |Chirp Web Design | http://www.chirp.com.au| |Phone: +61 2 62301871 `----. +61 2 62301515 Fax| `---------------------------+-------------------'