Nice! thanks for that one.

On Fri, Sep 4, 2009 at 10:59 PM, Continuation <selforgani...@gmail.com>wrote:

>
> MySQL has better replication support.
>
> MySQL has built-in replication based on log shipping.
>
> Postgresql doesn't have built in replication. You have to use external
> tools. From
> http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL#PostgreSQL_Replication_Weakness
> :
>
> "Slony-I, the most widely used PostgreSQL replication tool, is
> inherently inferior to MySQL's built in replication for a number of
> reasons. First, it uses SQL and triggers to replicate the data across
> servers. This is considerably slower than MySQL's binary log shipping
> and makes the communication costs much higher. Second, Slony-I's
> communication costs grow quadratically in relation to the number of
> servers in the replication pool (Order(n^2)). This makes it inherently
> unusable for larger clusters. If we conservatively figure that Slony-
> I's SQL/trigger method takes twice as much communication as MySQL's
> binary log shipping, we can easily see how poorly this would work for
> larger clusters in the real world.
>
> With two servers: MySQL: 2 = 2 PostgreSQL: 2*2^2 = 8
>
> With 4 servers: MySQL: 4 = 4 PostgreSQL: 2*4^2 = 32
>
> With 12 servers: MySQL: 12 = 12 PostgreSQL: 2*12^2 = 288.
>
>
>
> On Sep 4, 4:29 pm, Joshua Russo <josh.r.ru...@gmail.com> wrote:
> > I personally don't have any experience with PostgreSQL and I'm generally
> > working in a mixed MS and Linux environment. I'm interested to hear
> peoples
> > views on the pluses and minuses of the two different systems. I'm a bit
> of a
> > query geek too. How does that play in? I know in MySQL there are
> limitations
> > on where you can use subqueries. Is that true with PostgreSQL? (Ya I
> could
> > just look that one up but it's just an example.)
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to