Month: January 2013
PostgreSQL 9.3: “One line – one standby”
Sometimes it happens that you reach a point where you know that things cannot be any easier than they already are. I think in PostgreSQL 9.3 we will pretty much have reached this point when we fire up a simple replica. Back in the old times you had to call pg_start_backup, rsync the entire stuff, […]
Read more
Better PostgreSQL performance on SSDs
The optimizer uses several parameters to optimize queries. Those parameters have been constant for many years in the past. This was fine for most users. Recently we have seen a couple of systems which were already fully based on SSD disks. SSDs have a nice advantage over traditional disks: Random disk access is not a […]
Read more