Mandi! Andrew Hammond
In chel di` si favelave...
[why sometimes i don't receive messages from the list?]
> You do understand that slony is an ASYNCHRONOUS replication system,
> right? The data you are selecting against on a subscriber will be
> slightly behind the data on the origin. You need to keep that in mind
> when designing your application or it will cause some very tricky
> problems later.
I Know that. Absolutely.
As i've just write, the database is a backend for a internal webapp, so
we have the total control over it.
> Instead of differentiating based on statements, if you differentiate
> based on a higher level abstraction ("reporting" vs. "oltp") you might
> have better luck with that kind of a design.
I know also that.
I know that this is some sort of 'hack', but our webapp for the
well-known reason have grown too much and have to grown for some month
further before we can 'stop' the developing and do some 'rewriting' of
the code.
We need some month, even if this will implicitly need some
one-second-sleep-on-post-write query. ;)
--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bontà , 7 - 33078 - San Vito al Tagliamento (PN)
marco.gaiarin(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
