Sep 9 – 11, 2019
Europe/Lisbon timezone

Improving Buffered I/O

Sep 10, 2019, 10:45 AM
Ametista/room-I (Corinthia Hotel Lisbon)


Corinthia Hotel Lisbon

Birds of a Feather (BoF) Birds of a feather (BoF)


What I'd like to get to is to discuss that buffered IO basically sucks for databases with high throughput, and direct IO sucks for databases that aren't individually well tuned, and is not adaptive to memory pressure at all.

Buffered IO is slow, until recently only synchronous, has double buffering issues and writeback is hard to control.

Direct IO requires that the application's equivalent of the page-cache is well tuned for the workload - but most installations don't have DBAs to do so, and in a lot of environments it's unrealistic to give all databases the peak required memory. In contrast to that the kernel page-cache adapts reasonably to changing workloads, caching data for the applications that need it most.

Input both from the developers of other databases and from the kernel side would be very welcome.

I agree to abide by the anti-harassment policy Yes
I confirm that I am already registered for LPC 2019 Yes

Primary authors

Mr Tomas Vondra (Postgresql) Andres Freund (EnterpriseDB / PostgreSQL)

Presentation materials

There are no materials yet.
Diamond Sponsor

Platinum Sponsors

Gold Sponsors

Silver Sponsors

Evening Event Sponsor

Lunch Sponsor

Catchbox Sponsor

T-Shirt Sponsor

Official Carrier

Location Sponsor