bloat
Monday, January 25th, 2010a “bloat” view – provides info postgresql tables that need a vacuum
Archive for the 'dba' Category
Priorities – PostgreSQL Wiki
Wednesday, January 20th, 2010some info about managing/prioritizing resources (CPU/IO/RAM) under PostgreSQL from the project’s WIKI
[RUS] Подсчет количества найденных записей в PostgreSQL / Хабрахабр
Friday, January 8th, 2010PostgresSQL: how to count number of rows returned by a query and do it fast
[RUS] Оптимизация AUTOVACUUM 8.3 / PostgreSQL : Форум на SQL.RU / PostgreSQL Autovacuum Optimizations
Monday, December 28th, 2009some notes on how to optimize autovacuum on Postgres
PostgreSQL on Vimeo
Friday, December 18th, 2009collections of videos of PostgreSQL-related presentation from Vimeo.com
[RUS ]MatView с инкрементным обновлением (FAST) без триггера и лога / PostgreSQL : Форум на SQL.RU
Sunday, December 13th, 2009post to russian postgresql forum that describes 2 ways to simulate materialize views on postgres
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.
[RUS] Случайная выборка нескольких строк с минимальным IO / PostgreSQL : Форум на SQL.RU
Wednesday, October 7th, 2009how to get fast random select in postgres
pg51g
Tuesday, September 8th, 2009‘diff’ utility for postgresql databases
[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)