Dba

http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html a “bloat” view - provides info postgresql tables that need a vacuum

http://wiki.postgresql.org/wiki/Priorities#Prioritizing_I.2FO some info about managing/prioritizing resources (CPU/IO/RAM) under PostgreSQL from the project’s WIKI

http://m.habrahabr.ru/post/30046/ PostgresSQL: how to count number of rows returned by a query and do it fast

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

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

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

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.

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

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

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)