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 <ajs@xxxxxxxxxxxxxxx>
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 smallBy the way, despite my flip comment, it is entirely possible that what
> 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.
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
ajs@xxxxxxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
