Valentine’s tech log: [PostgreSQL] Index sizes depending on the type of the field being indexed
Saturday, April 23rd, 2011empirical data about difference in index sizes depending on the data type
Archive for the 'postgres' Category
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, 2010improvements to PostgreSQL that could be made by tuning wal/background writer processes
Tuning PostgreSQL WAL Synchronization
Tuesday, February 9th, 2010Notes about PostgreSQL WAL synchronizations methods
WAL Configuration
Tuesday, February 9th, 2010Notes 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, 2009yet 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, 2009how to get fast random select in postgres
What happened to Hot Standby?
Saturday, March 21st, 2009Josh 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, 2009PITRTools 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, 2008in Russian: how to complie PostgreSQL stored procedures in C with MinGW under windows