Robert Haas: MySQL vs. PostgreSQL, Part 1: Table Organization
Tuesday, November 30th, 2010An article from a well-known PostgreSQL developer comparing MySQL InnoDB and PostgreSQL table structures
Archive for the 'dba' Category
Comparing BenchmarkSQL Performance on Red Hat® Enterprise Linux 5 to Windows Server Enterprise
Wednesday, September 22nd, 2010“This paper compares the performance of an Online Transaction Processing (OLTP) based
PostgreSQL versus Oracle!
Thursday, July 29th, 2010Full 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]
Monday, July 12th, 2010http://www.pgcon.org/2010/schedule/attachments/141_PostgreSQL-and-NoSQL.pdf
[RUS]Проектирование френдленты и рейтингов / Проектирование БД : Форум на SQL.RU | [Forum SQL.ru] Modeling frendlist, ratings
Wednesday, May 5th, 2010Some comments on modeling friendlits user activity, for social media websites (or apps)
[RUS] Dublicates on Unique Indexes / PostgreSQL Forum on SQL.RU | Появились дубли на уникальном индексе / PostgreSQL : Форум на SQL.RU
Thursday, April 1st, 2010horror 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 REINDE…
InsideBufferCache.pdf (application/pdf Object)
Monday, March 29th, 2010“There’s very little information about PostgreSQL buffer cache
Checkpoints and the Background Writer: PostgreSQL 8.3 Improvements and Migration
Wednesday, February 10th, 2010improvements to PostgreSQL that could be made by tuning wal/background writer processes
Tuning PostgreSQL WAL Synchronization
Tuesday, February 9th, 2010Notes about PostgreSQL WAL synchronizations methods
WAL Configuration
Tuesday, February 9th, 2010Notes about Write-Ahead Log, Check points and other IO configuration related to postgresql transaction log settings