livejournal outage post mortem - Mailing list pgsql-hackers

From Michael Adler
Subject livejournal outage post mortem
Date
Msg-id 20050120205200.GC29922@pobox.com
Whole thread Raw
In response to Re: [pgsql-hackers] Daily digest v1.4918 (23 messages)  ("Serguei A. Mokhov" <mokhov@cs.concordia.ca>)
List pgsql-hackers
(only tangentally on topic)

Interesting tail on the problems of MyISAM tables, disk write-caching,
and sharing space with people who can't resist pushing the big red
button. Only tangentally on topic. 

http://www.livejournal.com/community/lj_dev/670215.html

I wonder what livejournal would look like if they used pg instead
mysql. They had to figure out some ways of working around the
pessimistic locking of the non-MVCC approach, but they've also made
use of the replication features that might not have been available
until recently in pg.

http://www.danga.com/words/2004_mysqlcon/mysql-slides.pdf
-Mike Adler


pgsql-hackers by date:

Previous
From: Matthias Schmidt
Date:
Subject: Re: Some things I like to pick from the TODO list ...
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [GENERAL] Ways to check the status of a long-running transaction