Re: PG on two nodes with shared disk ocfs2 & drbd

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 <ajs(at)crankycanuck(dot)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
> ajs(at)crankycanuck(dot)ca
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>