empirical data about difference in index sizes depending on the data type
Archive for the 'postgres' Category
“There’s very little information about PostgreSQL buffer cache
improvements to PostgreSQL that could be made by tuning wal/background writer processes
Notes about PostgreSQL WAL synchronizations methods
Notes about Write-Ahead Log, Check points and other IO configuration related to postgresql transaction log settings
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.
how to get fast random select in postgres
Josh Berkus explaing why hot-standby replication did not make it into postgresql 8.4
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.RUSaturday, May 10th, 2008
in Russian: how to complie PostgreSQL stored procedures in C with MinGW under windows