[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()
Database
Merlin's stuff: software vs hardware raid | Dell md1000 bonnie++ benchmarks
http://merlinmoncure.blogspot.com/2007/08/following-are-results-of-our-testing-of.html bonnie++ benchmark comparing dell perc 5 (lsi) hw raid controllers connected to Dell md1000 jbod box and linux md raid driver. (test was performed by a notable PostgreSQL developer )
PostgreSQL DBE Position at Etsy.com
http://archives.postgresql.org/pgsql-jobs/2008-05/msg00010.php a lot of silly questions !!! WARNING
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 )
Cookies are for Closers » LinkedIn Architecture
http://cookiesareforclosers.com/blog/2008/06/linkedin-architecture interesing notes about LinkedIn architecture (JAVA + MYSQL + ORACLE)
[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
Problems with PostgreSQL on Multi-core Systems with Multi-Terabyte Data - Jignesh K. Shah's PostgreSQL Blog
http://people.planetpostgresql.org/jkshah/index.php?/archives/3-Problems-with-PostgreSQL-on-Multi-core-Systems-with-Multi-Terabyte-Data.html PostgreSQL: benchmarks and further analisys for OLTP workloads 8-32 cores with ~TB db size from Sun’s potgresql team
[Russian] Stored procedures i n C for PostgreSQL under Win32 (MinGW ) | Сишные хранимки под PostgreSQL 8.1 (Win) / PostgreSQL : Форум на SQL.RU
http://sql.ru/forum/actualthread.aspx?tid=435875 in Russian: how to complie PostgreSQL stored procedures in C with MinGW under windows