Database

http://vimeo.com/channels/postgres#7707230 collections of videos of PostgreSQL-related presentation from Vimeo.com

http://sql.ru/forum/actualthread.aspx?tid=719815 post to russian postgresql forum that describes 2 ways to simulate materialize views on postgres

http://www.randombugs.com/linux/mysql-postgresql-benchmarks.html yet another mysql vs postgresql benchmark using “OSDB”. Small difference between the two, but consider that benchmark was done on 2-way SMP, 3GB ram, 1 SATA DISK and a small dataset.

http://petereisentraut.blogspot.com/2009/07/solid-state-drive-benchmarks-and-write.html read this before rushing to by some SSDs

http://www.sdsqlug.org/presentations/May2009/MySpace_DB_Overview.pptx myspace architecture presentation, talks about how to myspace solves its database issues

http://www.fishpool.org/post/2008/03/31/Optimizing-Linux-I/O-on-hardware-RAID explains use linux IO scheulers with presence of smart RAID controllers.

http://pgdba.net/pg51g/ ‘diff’ utility for postgresql databases

http://highscalability.com/yahoo-s-pnuts-database-too-hot-too-cold-or-just-right writeup on yahoo PTUNS (distributed database ). Also, see the original paper if you are interested.

http://habrahabr.ru/blogs/perl/67390/#habracut async requests using DBD::pg

http://wiki.postgresql.org/wiki/Image:Moskva_DB_Tools.v3.pdf Link to a page with a download for file:Moskva_DB_Tools.v3.pdf‎ (file size: 488 KB, MIME type: application/pdf)