LWN.net Logo

Slave servers vs. Stored Procedures

Slave servers vs. Stored Procedures

Posted Sep 22, 2010 18:55 UTC (Wed) by smurf (subscriber, #17840)
In reply to: PostgreSQL 9.0 arrives with many new features by captrb
Parent article: PostgreSQL 9.0 arrives with many new features

The operative word here is "queue". If I want to keep the database and the external world in sync, I can't queue my changes.

Of course, it's a trade-off, and has its own pitfalls (what if the stored procedure works on the master but fails on the slave?). But so has every other solution.


(Log in to post comments)

Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds