[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()
http://sql.ru/forum/actualthread.aspx?tid=569200 CREATE OR REPLACE FUNCTION makebackup()
http://pugs.postgresql.org/node/396 Postgres Database Administrator, Beverly Hills, CA
http://revsys.com/writings/postgresql-performance.html yet another postgresql tuning guide, contains useful explanation of most omportant config parameters
http://momjian.us/main/writings/pgsql/hw_performance/index.html notes on PostgreSQL tuning from Bruce Momjian (PostgreSQL core team )
http://sql.ru/forum/actualthread.aspx?tid=301825 notes / discussion about optimizing index performance for big tables (“big” means 250M records
http://kaiv.wordpress.com/ Blog of Kristo Kaiv - Skype architect / DBA
http://www.samag.ru/cgi-bin/go.pl?q=articles;n=07.2007;a=02 from Russian SysAdmin magazine
http://www.mysqlperformanceblog.com/2006/07/07/thoughts-on-mysql-replication/ some interesting comments on build-in mysql replication, read comments!!!
http://blog.blackvoltage.org/code-and-projects/postgresql-diff-tool/ Python based tool for diff’ing databases( also see pgdiff)
http://www.databaseanswers.org/data_models/index.htm useful data model samples