Archive for the 'dba' Category

[russian] how to make backup via sql request /PostgreSQL forum at sql.ru || Сделать backup через запрос / PostgreSQL : Форум на SQL.RU

Friday, June 27th, 2008

CREATE OR REPLACE FUNCTION makebackup()

2008-05-14 Postgres Database Administrator | PostgreSQL User Group Site

Sunday, June 15th, 2008

Postgres Database Administrator, Beverly Hills, CA

Performance Tuning PostgreSQL

Thursday, June 12th, 2008

yet another postgresql tuning guide, contains useful explanation of most omportant config parameters

PostgreSQL Hardware Performance Tuning

Thursday, June 12th, 2008

notes on PostgreSQL tuning from Bruce Momjian (PostgreSQL core team )

[Russian] Оптимизация index scan {Optimizing Index Scan} / PostgreSQL : Форум на SQL.RU {forum SQL.RU}

Tuesday, June 3rd, 2008

notes / discussion about optimizing index performance for big tables (“big” means 250M records

<(-_-)> on PostgreSQL

Thursday, April 10th, 2008

Blog of Kristo Kaiv – Skype architect / DBA

[Russian] PostgreSQL vs MySQL Performance test //Журнал «Системный администратор»

Saturday, March 1st, 2008

from Russian SysAdmin magazine

Thoughts on MySQL Replication | MySQL Performance Blog

Wednesday, February 13th, 2008

some interesting comments on build-in mysql replication, read comments!!!

PostgreSQL Diff Tool : Anoop Menon’s Blog

Wednesday, January 23rd, 2008

Python based tool for diff’ing databases( also see pgdiff)

Library of Free Data Models from DatabaseAnswers.org

Friday, June 15th, 2007

useful data model samples