9-11 September 2019
Europe/Lisbon timezone

Improving Buffered I/O

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

Ametista-room-I

Corinthia Hotel Lisbon

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

Description

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.
Your browser is out of date!

Update your browser to view this website correctly. Update my browser now

×