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?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
http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html a “bloat” view - provides info postgresql tables that need a vacuum
http://wiki.postgresql.org/wiki/Priorities#Prioritizing_I.2FO some info about managing/prioritizing resources (CPU/IO/RAM) under PostgreSQL from the project’s WIKI
http://m.habrahabr.ru/post/30046/ PostgresSQL: how to count number of rows returned by a query and do it fast