Index

Valentine's tech log: [PostgreSQL] Index sizes depending on the type of the field being indexed

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

Google Translate "Again about SQL " -- route costs lookup for telephony operator

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

[Russian] Оптимизация index scan {Optimizing Index Scan} / PostgreSQL : Форум на SQL.RU {forum SQL.RU}

http://sql.ru/forum/actualthread.aspx?tid=301825 notes / discussion about optimizing index performance for big tables (“big” means 250M records

Venu Anuganti Blog » Notes on scaling heavy concurrent writes in real time /InnoDB

http://venublog.com/2008/04/17/notes-on-scaling-heavy-concurrent-writes-in-real-time/ notes about how to scale innodb writes. to summ it up: shard, use int as PKEY (convert hash to int using base-convert, batch lots of write into one trx. / nothing special

domas mituzas: vaporware, inc. » Blog Archive » Where covering indexes rock

http://dammit.lt/2007/01/26/mysql-covering-index-performance/ mysql index performance tech internals (interesting)