Re: Multiple logical databases

Mark Woodward wrote:
> Oh come on, "misinformed?" is that really called for?

Claiming that all databases share the same system tables is misinformed, 
with no judgement passed.

> The street database is typically generated and QAed in the lab. It is
> then uploaded to the server. It has many millions of rows and about a
> half dozen indexes. To dump and reload takes almost a day.

There is work happening on speeding up bulk loads.

> Unless you can tell me how to insert live data and indexes to a
> cluster without having to reload the data and recreate the indexes,

I think this sort of thing can be worked on.  VACUUM FREEZE and some 
tool support could make this happen.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/