Archive for the 'index' Category

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

Saturday, April 23rd, 2011

empirical data about difference in index sizes depending on the data type

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

Tuesday, November 23rd, 2010

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}

Tuesday, June 3rd, 2008

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

Saturday, April 19th, 2008

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

Thursday, November 15th, 2007

mysql index performance tech internals (interesting)