Dba

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://www.redhat.com/pdf/rhel/bmsql-postgres-sqlsrvr-v1.0-1.pdf “This paper compares the performance of an Online Transaction Processing (OLTP) based

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)

http://www.pgcon.org/2010/schedule/events/219.en.html http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf

http://sql.ru/forum/actualthread.aspx?tid=754989 Some comments on modeling friendlits user activity, for social media websites (or apps)

http://sql.ru/forum/actualthread.aspx?bid=7&tid=747614&pg=1 horror story about duplicate records in a table with UNIQUE index. The guy buid a pg himself (w/out knowing much about it), at some point pg included a patch that changed string sorting order, and that led to duplicate records. / you had to do REINDEX before using the version with that ICU patch, but the guy didn’t know /

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