[RUS ]MatView с инкрементным обновлением (FAST) без триггера и лога / PostgreSQL : Форум на SQL.RU
Sunday, December 13th, 2009post to russian postgresql forum that describes 2 ways to simulate materialize views on postgres
Archive for the 'database' Category
MySQL vs PostgreSQL Benchmarks | Random Bugs
Sunday, December 13th, 2009yet another mysql vs postgresql benchmark using “OSDB”. Small difference between the two, but consider that benchmark was done on 2-way SMP, 3GB ram, 1 SATA DISK and a small dataset.
Peter Eisentraut’s Blog: Solid-State Drive Benchmarks and the Write Cache
Monday, November 16th, 2009read this before rushing to by some SSDs
www.sdsqlug.org/presentations/May2009/MySpace_DB_Overview.pptx
Thursday, October 15th, 2009myspace architecture presentation, talks about how to myspace solves its database issues
Optimizing Linux for random I/O on hardware RAID – Fishpool
Wednesday, October 7th, 2009explains use linux IO scheulers with presence of smart RAID controllers.
pg51g
Tuesday, September 8th, 2009‘diff’ utility for postgresql databases
Yahoo!’s PNUTS Database: Too Hot, Too Cold or Just Right? | High Scalability
Friday, August 21st, 2009writeup on yahoo PTUNS (distributed database ). Also, see the original paper if you are interested.
Асинхронность в DBD::Pg / Великий Язык PERL! / Хабрахабр
Wednesday, August 19th, 2009async requests using DBD::pg
[2009 Presentation on SkyTools from Skype] Image:Moskva DB Tools.v3.pdf – PostgreSQL Wiki
Tuesday, July 28th, 2009Link to a page with a download for file:Moskva_DB_Tools.v3.pdf (file size: 488 KB, MIME type: application/pdf)
Open Source Database Magazine
Thursday, July 23rd, 2009pdf magazine that covers open-source databases, MySQL, PostgreSQL and alike.