[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.

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

A look at the MySQL forks [LWN.net]

http://lwn.net/Articles/329626/?format=printable describes recent forks, patch-sets and build of mysql. If you looking at this page deciding which fork of mysql will be better suited for your new project – maybe better to use PostgreSQL instead

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

[russian] Юзеры - Друзья. Какая связь? / Проектирование БД : Форум на SQL.RU || User - Friends relationship : Database design, forum SQL.ru

http://sql.ru/forum/actualthread.aspx?bid=36&tid=552763&pg=2 design pattern for friends/users, i.e. how to organize user-friend relationship. patters suggest that you need to make 2 tables, i.e freindship and friendship:user

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

Benchmark: Dell/Perc 6, 8 disk RAID 10 [postgresql-performance mailing list]

http://archives.postgresql.org/message-id/[email protected] Dell 2950