How InnoDB handles REDO logging - MySQL Performance Blog [by Ewen Fortune]
http://www.mysqlperformanceblog.com/2011/02/03/how-innodb-handles-redo-logging/
Database
How InnoDB handles REDO logging - MySQL Performance Blog [by Ewen Fortune]
http://www.mysqlperformanceblog.com/2011/02/03/how-innodb-handles-redo-logging/ How MySQL InnoDB implements transaction log, aka REDO (Oracle), aka WAL (PostgreSQL)
OTN Discussion Forums : SQL*Plus 10.2.0.1.0 does not work on ... | times(NULL) = loop
http://forums.oracle.com/forums/thread.jspa?messageID=1108985 It appears to be an interesting bug in some versions of Oracle 10g, on Linux 2.6.x oracle process goes in loop doing times() system call if machine uptime < 199 days. Nice!!! / Oracle refs are bug 4612267 and 5867987 ) . The solution is to reboot.
InnoDB Flushing: Theory and solutions - MySQL Performance Blog
http://www.mysqlperformanceblog.com/2011/04/04/innodb-flushing-theory-and-solutions/ blog posts that describes how MySQL InnoDB flushes data to disk (also see bgwriter, checkpoint_* parameters in PostgreSQL)
Understanding the StackOverflow Database Schema - SQLServerPedia
http://sqlserverpedia.com/wiki/Understanding_the_StackOverflow_Database_Schema Notes about schema used by StackOverflow.com and related websites. It is very simple, only several tables used. (most likely because there are performance problems with joins)
Robert Haas: MySQL vs. PostgreSQL, Part 1: Table Organization
http://rhaas.blogspot.com/2010/11/mysql-vs-postgresql-part-1-table.html An article from a well-known PostgreSQL developer comparing MySQL InnoDB and PostgreSQL table structures
Google Translate "Again about SQL " -- route costs lookup for telephony operator
http://translate.google.com/translate?u=http%3A%2F%2Fplakhov.livejournal.com%2F144249.html%3Fthread%3D2563193%23t2563193&sl=ru&tl=en&hl=&ie=UTF-8 Google translate of 2 posts in Russian section of LJ about route costs look up problem commonly faced by telephony operators
Comparing BenchmarkSQL Performance on Red Hat® Enterprise Linux 5 to Windows Server Enterprise
http://www.redhat.com/pdf/rhel/bmsql-postgres-sqlsrvr-v1.0-1.pdf “This paper compares the performance of an Online Transaction Processing (OLTP) based
PostgreSQL versus Oracle!
http://diznix.com/dizwell/archives/153 Full Text Search benchmark, Oracle vs Postgres, on 2x Quad core Xeon, 8G RAM, 2 SSDs x RAID 1. Pg is being slightly faster when query contains several words, once word count increases, oracle leaps ahead (suggesting a more mature FTS implementation)
PGCon2010: Perspectives on NoSQL [Gavin M. Roy, CTO of MyYearBook.com]
http://www.pgcon.org/2010/schedule/events/219.en.html http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf