Open Source Database Magazine

http://www.osdbzine.net/ pdf magazine that covers open-source databases, MySQL, PostgreSQL and alike.

[RUS ]Массив? Или как лучше? / PostgreSQL : Форум на SQL.RU | Array? or how to do it better? - A way to deal with serializable objects in PostgreSQL

http://sql.ru/forum/actualthread.aspx?tid=676435 this is a discussion from russian database forum SQL.RU that describes 2 common ways of storing serializable objects in RDBMS.

[RUS] PostgreSQL vs MySQL

http://www.samag.ru/art/07.2007/07.2007_02.html test uses db schema and usage pattern from popular blog-hosting site. Benchmark uses optimized queries

PGQ Tutorial - PostgreSQL Wiki

http://wiki.postgresql.org/wiki/PGQ_Tutorial http://sql.ru/forum/actualthread.aspx?tid=665075 Examples how to use PgQ queue in postgres

What happened to Hot Standby?

http://it.toolbox.com/blogs/database-soup/what-happened-to-hot-standby-30391?rss=1 Josh Berkus explaing why hot-standby replication did not make it into postgresql 8.4

Pitrtools - Trac /set of tools for setting up PITR on PostgreSQL/

https://projects.commandprompt.com/public/pitrtools/ PITRTools is a set of wrapper scripts that provide warm standby functionality to PostgreSQL. The software is essentially two scripts, cmd_archiver.py and cmd_standby.py. The project is under the BSD license.

SourceForge.net: BenchmarkSQL

http://sourceforge.net/projects/benchmarksql tool for testing database performance, jdbc-based, supports a lot of different DBs

Benchmarking Databases I. Volatile Storage. - Pon un sol en tu vida

http://blogs.nologin.es/slopez/archives/17-Benchmarking-Databases-I.-Volatile-Storage..html PostgreSQL, MySQL and Oracle are compared using reasonable hardware setup and TPC-C like test with BenchmarkSQL tool (JDBC ) . This post will probably disappear soon as the author clearly violates oracle license that does not permit publishing benchmark results w/out permissions

Prevent users from seeing SQL inside SP Postgersql ( from flames on sql.ru about MySQL vs PostgreSQL [russian] Выбор СУБД: MySQL или PostgreSQL / Сравнение СУБД : Форум на SQL.RU )

http://sql.ru/forum/actualthread.aspx?tid=606215&pg=3 example: REVOKE SELECT ON pg_catalog.pg_proc, information_schema.routines FROM public

BLOB, iBatis & PostgreSql 8.1 - dBforums [large objects vs bytea]

http://www.dbforums.com/showthread.php?t=1620377 sane notes about storing binary data in Postgres. Basically bytea is ASCII representaion of bynary data wich requires decoding / escaping (read: slow) and large objects a kind of ok, but not trigger-based replication compartable