Search Postgresql Archives

Re: Limitations of PostgreSQL

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

 



On Wed, 2005-10-12 at 23:11, Chris Travers wrote:
> Scott Marlowe wrote:

> >Thought I'd comment on this.
> >
> >According to the author of the innodb engine, innodb uses MVCC.
> >OTOH, I consider innodb to be broken in production, due to issues with
> >constant growth and no way to reclaim the lost space.
> >  
> >
> Any sources on that?  I would love to have info on that.

Just do a google search for innodb and mvcc.  Lots of soruces, not sure
how good any one might be.

> >This means that vacuuming, a minor annoyance in PostgreSQL, is a major
> >issue for 24/7 mysql databases running on innodb, where they must be
> >shut down and restarted to clear up the unused space in the innodb
> >tablespace.
> >
> >
> >  
> >
> No kidding.  Would like more info.

Setup a MySQL database with 5.0.13 and insert and delete a lot in an
mvcc table.  The innodb tablespace just grows and grows.

> >>Multimaster async replication w/updates is a pain at the moment and 
> >>mostly a set of kludges.
> >>    
> >>
> >
> >There really are too many use cases for there to be a "simple"
> >resolution to the problems presented by multi-master replication.  It's
> >a complex problem that creates more complex problems as you attempt to
> >solve it.
> >  
> >
> I have come up with some ways of doing this but they are difficult.  And 
> the question is always "How good is good enough"

Right, and the real issue is that what might be a good compromise
between performance and data security in one situation might be an awful
choice in another.  So, multi-master replication isn't likely to become
a plug in module for postgresql any time soon.

> >>Does not have full XA support at the moment (does have TPC).
> >>    
> >>
> >
> >I'd point out here that MySQL's XA support is quite primitive, and only
> >useful for a fairly smaller number of cases.
> >  
> >
> Again, I was comparing with DB2 and Oracle.  One should consider all new 
> features of MySQL to be both overmarketed and primitive for some time.

True.  PostgreSQL IS working on XA support (specifically the jdbc list
is.)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[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