Archive for the 'postgresql' Category

[RUS] Оптимизация AUTOVACUUM 8.3 / PostgreSQL : Форум на SQL.RU / PostgreSQL Autovacuum Optimizations

Monday, December 28th, 2009

some notes on how to optimize autovacuum on Postgres

[RUS] Доступ к PostgreSQL из ASP. / PostgreSQL : Форум на SQL.RU

Saturday, December 19th, 2009

DSN-less connection for VB/Classic ASP to PostgreSQL/ODBC on windows

PostgreSQL on Vimeo

Friday, December 18th, 2009

collections of videos of PostgreSQL-related presentation from Vimeo.com

[RUS ]MatView с инкрементным обновлением (FAST) без триггера и лога / PostgreSQL : Форум на SQL.RU

Sunday, December 13th, 2009

post to russian postgresql forum that describes 2 ways to simulate materialize views on postgres

MySQL vs PostgreSQL Benchmarks | Random Bugs

Sunday, December 13th, 2009

yet 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.

Optimizing Linux for random I/O on hardware RAID – Fishpool

Wednesday, October 7th, 2009

explains use linux IO scheulers with presence of smart RAID controllers.

[RUS] Случайная выборка нескольких строк с минимальным IO / PostgreSQL : Форум на SQL.RU

Wednesday, October 7th, 2009

how to get fast random select in postgres

pg51g

Tuesday, September 8th, 2009

‘diff’ utility for postgresql databases

Асинхронность в DBD::Pg / Великий Язык PERL! / Хабрахабр

Wednesday, August 19th, 2009

async requests using DBD::pg

[2009 Presentation on SkyTools from Skype] Image:Moskva DB Tools.v3.pdf – PostgreSQL Wiki

Tuesday, July 28th, 2009

Link to a page with a download for file:Moskva_DB_Tools.v3.pdf‎ (file size: 488 KB, MIME type: application/pdf)