Archive for the 'postgres' Category

Valentine’s tech log: [PostgreSQL] Index sizes depending on the type of the field being indexed

Saturday, April 23rd, 2011

empirical data about difference in index sizes depending on the data type

InsideBufferCache.pdf (application/pdf Object)

Monday, March 29th, 2010

“There’s very little information about PostgreSQL buffer cache

Checkpoints and the Background Writer: PostgreSQL 8.3 Improvements and Migration

Wednesday, February 10th, 2010

improvements to PostgreSQL that could be made by tuning wal/background writer processes

Tuning PostgreSQL WAL Synchronization

Tuesday, February 9th, 2010

Notes about PostgreSQL WAL synchronizations methods

WAL Configuration

Tuesday, February 9th, 2010

Notes about Write-Ahead Log, Check points and other IO configuration related to postgresql transaction log settings

MySQL vs PostgreSQL Benchmarks | Random Bugs

Sunday, December 13th, 2009

yet another mysql vs postgresql benchmark using “OSDB”. Small difference between the two, but consider that benchmark was done on 2-way SMP, 3GB ram, 1 SATA DISK and a small dataset.

[RUS] Случайная выборка нескольких строк с минимальным IO / PostgreSQL : Форум на SQL.RU

Wednesday, October 7th, 2009

how to get fast random select in postgres

What happened to Hot Standby?

Saturday, March 21st, 2009

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/

Thursday, February 26th, 2009

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.

[Russian] Stored procedures i n C for PostgreSQL under Win32 (MinGW ) | Сишные хранимки под PostgreSQL 8.1 (Win) / PostgreSQL : Форум на SQL.RU

Saturday, May 10th, 2008

in Russian: how to complie PostgreSQL stored procedures in C with MinGW under windows