Postgres

http://tech.valgog.com/2011/04/index-sizes-depending-on-type-of-field.html empirical data about difference in index sizes depending on the data type

http://www.westnet.com/~gsmith/content/postgresql/InsideBufferCache.pdf “There’s very little information about PostgreSQL buffer cache

http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm improvements to PostgreSQL that could be made by tuning wal/background writer processes

http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm Notes about PostgreSQL WAL synchronizations methods

http://developer.postgresql.org/pgdocs/postgres/wal-configuration.html Notes about Write-Ahead Log, Check points and other IO configuration related to postgresql transaction log settings

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://sql.ru/forum/actualthread.aspx?tid=701376 how to get fast random select in postgres

http://it.toolbox.com/blogs/database-soup/what-happened-to-hot-standby-30391?rss=1 Josh Berkus explaing why hot-standby replication did not make it into postgresql 8.4

https://projects.commandprompt.com/public/pitrtools/ PITRTools is a set of wrapper scripts that provide warm standby functionality to PostgreSQL. The software is essentially two scripts, cmd_archiver.py and cmd_standby.py. The project is under the BSD license.

http://sql.ru/forum/actualthread.aspx?tid=435875 in Russian: how to complie PostgreSQL stored procedures in C with MinGW under windows