Postgresql

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

http://sql.ru/forum/actualthread.aspx?tid=685680 some notes on how to optimize autovacuum on Postgres

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

http://sql.ru/forum/actualthread.aspx?tid=548788 DSN-less connection for VB/Classic ASP to PostgreSQL/ODBC on windows

PostgreSQL on Vimeo

http://vimeo.com/channels/postgres#7707230 collections of videos of PostgreSQL-related presentation from Vimeo.com

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

http://sql.ru/forum/actualthread.aspx?tid=719815 post to russian postgresql forum that describes 2 ways to simulate materialize views on postgres

MySQL vs PostgreSQL Benchmarks | Random Bugs

http://www.randombugs.com/linux/mysql-postgresql-benchmarks.html 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

http://www.fishpool.org/post/2008/03/31/Optimizing-Linux-I/O-on-hardware-RAID explains use linux IO scheulers with presence of smart RAID controllers.

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

http://sql.ru/forum/actualthread.aspx?tid=701376 how to get fast random select in postgres

pg51g

http://pgdba.net/pg51g/ ‘diff’ utility for postgresql databases

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

http://habrahabr.ru/blogs/perl/67390/#habracut async requests using DBD::pg

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

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