Postgresql

http://pgexperts.com/document.html?id=49 Presentation by Josh Berkus (PostgeSQL developer) at MySQL User Conference 2011

http://pgexperts.com/document.html?id=49 Presentation by Josh Berkus (PostgeSQL developer) at MySQL User Conference 2011

http://www.xaprb.com/blog/2011/01/29/how-innodb-performs-a-checkpoint/

http://www.xaprb.com/blog/2011/01/29/how-innodb-performs-a-checkpoint/ An article about MySQL InnoDB checkpoint-ing mechanism written by Perconna folks. Read comments as well, several PostgreSQL core committers have participated in the discussion. “InnoDB’s checkpoint algorithm is not well documented. It is too complex to explain in even a long blog post, because to understand checkpoints, you need to understand a lot of other things that InnoDB does. I hope that explaining how InnoDB does checkpoints in high-level terms, with simplifications, will be helpful. A lot of the simplifications are because I do not want to explain the complexities of how the simple rules can be tweaked for optimization purposes, while not violating the ACID guarantees they enforce.” ...

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)

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.cisco.com/en/US/prod/collateral/voicesw/ps6788/vcallcon/ps7194/product_data_sheet0900aecd805c3cc1.pdf Cisco Service Node for Linksys One – integrated solution for linksys voip CPE (registration, services, provisioning), consists of cisco network gear (chassis + console server ) , 2 HP DL G380G4 servers + MSA100 storage / FreeBSD, PostgreSQL, OpenSER, NET-SNMP, DIND DNL (Dynamically-Loadable Zone)

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

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

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