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/