Search Postgresql Archives

memcached and PostgreSQL

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

 



http://pugs.postgresql.org/sfpug/archives/000021.html

I noticed that some of you left coasters were talking about memcached
and pgsql. I'm curious to know what was discussed.

In reading about memcached, it seems that many people are using it to
circumvent the scalability problems of MySQL (lack of MVCC). 

from their site: 	

<snip>
Shouldn't the database do this?

Regardless of what database you use (MS-SQL, Oracle, Postgres,
MysQL-InnoDB, etc..), there's a lot of overhead in implementing ACID
properties in a RDBMS, especially when disks are involved, which means
queries are going to block. For databases that aren't ACID-compliant
(like MySQL-MyISAM), that overhead doesn't exist, but reading threads
block on the writing threads. memcached never blocks. 
</snip>

So What does memcached offer pgsql users? It would still seem to offer
the benefit of a multi-machined cache.

-Mike 


[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