Re: Compression and on-disk sorting - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: Compression and on-disk sorting
Date
Msg-id 87ac9fuc6s.fsf@mid.deneb.enyo.de
Whole thread Raw
In response to Re: Compression and on-disk sorting  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
* Jim C. Nasby:

> The problem is that it seems like there's never enough ability to clue
> the OS in on what the application is trying to accomplish. For a long
> time we didn't have a background writer, because the OS should be able
> to flush things out on it's own before checkpoint. Now there's talk of a
> background reader, because backends keep stalling on waiting on disk IO.

I've recently seen this on one of our test systems -- neither CPU nor
disk I/O were maxed out.

Have you considered using asynchronous I/O?  Maybe it results in less
complexity and fewer context switches than a background reader.


pgsql-hackers by date:

Previous
From: Florian Weimer
Date:
Subject: Re: [OT] MySQL is bad, but THIS bad?
Next
From: Florian Weimer
Date:
Subject: Re: PL/pgSQL 'i = i + 1' Syntax