Blog: Bruce Momjian

209 blogs updated: 25 min. ago
SSDs and effective_io_concurrency
Effective_io_concurrency controls how many concurrent requests can be made by bitmap heap scans. The default is 1, which means no concurrenc...
19-05-2017 17:36:01 Bruce Momjian PostgreSQL
Reorganized Presentations
I have reorganized my twenty active presentations to be easier to find. I was getting confused, so I assume others were as well. The new cat...
17-05-2017 20:13:05 Bruce Momjian PostgreSQL
RAID Controllers and SSD's
Disk array controllers gained popularity in a world of magnetic disks by providing: Hardware RAID support Large read/write cache Write reord...
15-05-2017 17:37:41 Bruce Momjian PostgreSQL
Postgres Window Magic
Having given the first presentation of my new window function talk, Postgres Window Magic, I have now put the slides online.
12-05-2017 18:21:56 Bruce Momjian PostgreSQL
Postgres 10 Features Presentation
I did my first presentation covering Postgres 10 features, so my slides are now online.
10-05-2017 20:31:44 Bruce Momjian PostgreSQL
Draft of Postgres 10 Release Notes
I have completed the draft version of the Postgres 10 release notes. Consisting of 180 items, I think you will be impressed with the substan...
26-04-2017 14:30:29 Bruce Momjian PostgreSQL
Modern systems offer several storage options and databases are very sensitive to the I/O characteristics of these options. The simplest is d...
24-04-2017 19:17:33 Bruce Momjian PostgreSQL
External Poolers
Connection poolers have two advantages: They reduce the number of active connections, allowing the server to operate more efficiently, witho...
21-04-2017 19:17:18 Bruce Momjian PostgreSQL
Switchover vs. Failover
With streaming replication, Postgres allows sophisticated setups of primary and standby servers. There are two ways to promote a standby to ...
19-04-2017 17:32:12 Bruce Momjian PostgreSQL
Incremental File System Backup
When using continuous archiving, you must restore a file system backup before replaying the WAL. If the file system backup was taken long ag...
17-04-2017 19:22:30 Bruce Momjian PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.