Postgresql

::Planet PostgreSQL::

http://www.planetpostgresql.org/ blog where postgresql developers post stuff

Pl/Pgsql - Greg's Postgres stuff

http://people.planetpostgresql.org/greg/index.php?/categories/19-PlPgsql some interesting notes on PL/PGSQL programing

PGCon2007: Developing New Zealand's Electoral Roll on PostgreSQL

http://www.pgcon.org/2007/schedule/events/53.en.html http://www.pgcon.org/2007/schedule/attachments/25-Slides (pdf slides)

PostgreSQL replication strategies (slides in pdf)

http://www.pgcon.org/2007/schedule/attachments/19-20070523Cecchet_PGCon2007.pdf This is pfrom PGCon2007 description

PostgreSQL Partitioning (pdf slides)

http://images.omniti.net/omniti.com/talks/partitions-public.pdf How to partition tables in postgresql

вернуть из ХП многомерный массив / PostgreSQL : Форум на SQL.RU

http://sql.ru/forum/actualthread.aspx?tid=210060 how to return an array from pgsql function

PostgreSQL: Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007

http://www.postgresql.org/docs/techdocs.83 some generic info about eternal “MySQL vs PostgreSQL” topic from postgres site

Big Bad PostgreSQL - Esoteric Curio

http://www.lethargy.org/~jesus/archive%20s/66-Big-Bad-PostgreSQL.html http://www.lethargy.org/~jesus/misc/BBPostgres.pdf

Forever For Now - Server-wide Performance Benchmarking

http://www.ffnn.nl/pages/articles/linux/server-wide-performance-benchmarking.php To get a good idea of the relative impact of the chosen filesystem I also tuned the amount of shared buffers used in the PostgreSQL database software, which powers a number of sites on the server. On top of that, I also took a look at the benefit of using

read-write SQL performance

http://lists.freebsd.org/pipermail/freebsd-arch/2007-August/006709.html benchmarking of sysbench in read-write, pgsql vs mysql under FreeBSD