Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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 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@xxxxxxxxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux