hehe... andrew, I appriciate pg and it's free open source features - maybe I've chosen a wrong formulation. in my eyes such a feature is getting more important nowadays. Postgresql-R and -XC are interesting ideas.
thanks everybody for the comments regards, jasmin 2011/2/28 Andrew Sullivan <a...@crankycanuck.ca> > On Mon, Feb 28, 2011 at 12:13:32AM +0100, Jasmin Dizdarevic wrote: > > My idea was the one, that john described: DML and DDL are done on the > small > > box and reporting on the "big mama" with streaming replication and hot > > stand-by enabled. the only problem is that we use temp tables for > reporting > > purposes. i hope that the query duration impact with not using temp > tables > > will be equalized through running dml/ddl on the small box. > > By the way, despite my flip comment, it is entirely possible that what > you need would be better handled by one of the other replication > systems. Slony is actually well-suited to this sort of thing, despite > the overhead that it imposes. This is a matter of trade-offs, and you > might want to think about different roles for different boxes -- > especially since hardware is so cheap these days. > > A > > -- > Andrew Sullivan > a...@crankycanuck.ca > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
