[russian] how to make backup via sql request /PostgreSQL forum at sql.ru || Сделать backup через запрос / PostgreSQL : Форум на SQL.RU
http://sql.ru/forum/actualthread.aspx?tid=569200 CREATE OR REPLACE FUNCTION makebackup()
Dba
2008-05-14 Postgres Database Administrator | PostgreSQL User Group Site
http://pugs.postgresql.org/node/396 Postgres Database Administrator, Beverly Hills, CA
Performance Tuning PostgreSQL
http://revsys.com/writings/postgresql-performance.html yet another postgresql tuning guide, contains useful explanation of most omportant config parameters
PostgreSQL Hardware Performance Tuning
http://momjian.us/main/writings/pgsql/hw_performance/index.html notes on PostgreSQL tuning from Bruce Momjian (PostgreSQL core team )
[Russian] Оптимизация index scan {Optimizing Index Scan} / PostgreSQL : Форум на SQL.RU {forum SQL.RU}
http://sql.ru/forum/actualthread.aspx?tid=301825 notes / discussion about optimizing index performance for big tables (“big” means 250M records
<(-_-)> on PostgreSQL
http://kaiv.wordpress.com/ Blog of Kristo Kaiv - Skype architect / DBA
[Russian] PostgreSQL vs MySQL Performance test //Журнал «Системный администратор»
http://www.samag.ru/cgi-bin/go.pl?q=articles;n=07.2007;a=02 from Russian SysAdmin magazine
Thoughts on MySQL Replication | MySQL Performance Blog
http://www.mysqlperformanceblog.com/2006/07/07/thoughts-on-mysql-replication/ some interesting comments on build-in mysql replication, read comments!!!
PostgreSQL Diff Tool : Anoop Menon's Blog
http://blog.blackvoltage.org/code-and-projects/postgresql-diff-tool/ Python based tool for diff’ing databases( also see pgdiff)
Library of Free Data Models from DatabaseAnswers.org
http://www.databaseanswers.org/data_models/index.htm useful data model samples