this is a discussion from russian database forum SQL.RU that describes 2 common ways of storing serializable objects in RDBMS.
Posted in database, dba, development, object-relational, orm, postgresql, programming, serialization | Comments Off | permalink
http://sql.ru/forum/actualthread.aspx?tid=665075 Examples how to use PgQ queue in postgres
Posted in database, dba, development, pgq, postgresql, programming, queue, skytools | Comments Off | permalink
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
Posted in database, dba, development, for:collidr, mysql, opensource | Comments Off | permalink
Josh Berkus explaing why hot-standby replication did not make it into postgresql 8.4
Posted in database, db, dba, postgres, postgresql, replication | Comments Off | permalink
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.
Posted in backup, data, database, dba, PITR, postgres, postgresql, python, recovery, replication | Comments Off | permalink
tool for testing database performance, jdbc-based, supports a lot of different DBs
Posted in benchmark, database, dba, java, jdbc, performance, postgresql, testing | Comments Off | permalink
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 benchma…
Posted in benchmark, database, dba, for:charlesnw, for:collidr, mysql, oracle, performance, postgresql, tpc-c | Comments Off | permalink
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
Posted in database, dba, design, sql | Comments Off | permalink
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
Posted in binary, database, dba, development, postgresql, programming | Comments Off | permalink
Dell 2950
Posted in 2950, benchmark, database, dba, dell, for:collidr, hadrware, Linux, performance, postgresql, raid, raid_harware, sysadmin | Comments Off | permalink
You are currently browsing the archives for the dba category.
Konstantin Antselovich (c) 2004-2011
powered by WordPress
Entries (RSS)
and Comments (RSS).