News for hackers. Stuff that matters.
Re:Disaster: MySQL 5.5 Flushing by bretthoerner on Sunday September 18, 2011 @05:21PM (#3011296)
> Are you running an equivalent hardware setup? > there is no proof that PostgreSQL does not have any teething problems on high capacity hardware either

At Disqus we run Postgres on even larger boxes without pauses described here. We would have (had to) migrate off long ago if this were par for the course.

Re:Disaster: MySQL 5.5 Flushing by gleb on Sunday September 18, 2011 @06:58PM (#3011521)
There is similar problem in Postgres as well.

Not nearly as bad in magnitude, and with some shared responsibility with Linux and file system code (since PG relies of filesystem's caching). Greg Smith talked about it in some detail during PGWest 2010. One of his customers had long stalls in production and Greg worked out how to reproduce and explain them.

He had some patches he was planning for Postgres 9.1, not sure if they went in.

Re:Disaster: MySQL 5.5 Flushing by spudlyo on Sunday September 18, 2011 @07:08PM (#3011539)
Is your database extremely write heavy? You don't usually see this problem in a more balanced read/write workload. Postgres has in the past suffered from stalls and lockups that can happen at checkpoint intervals, but it appears they mostly happen for seconds rather than minutes.