Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance - Mailing list pgsql-hackers

From Marti Raudsepp
Subject Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance
Date
Msg-id CABRT9RAH=dgCuTP8AphpxMH_gnWbR3oLbFw6=EBL3z_i2-C5Dw@mail.gmail.com
Whole thread Raw
In response to Re: Linux kernel impact on PostgreSQL performance  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Mon, Jan 20, 2014 at 1:51 AM, Dave Chinner <david@fromorbit.com> wrote:
>> Postgres is far from being the only application that wants this; many
>> people resort to tmpfs because of this:
>> https://lwn.net/Articles/499410/
>
> Yes, we covered the possibility of using tmpfs much earlier in the
> thread, and came to the conclusion that temp files can be larger
> than memory so tmpfs isn't the solution here. :)

What I meant is: lots of applications want this behavior. If Linux
filesystems had support for delaying writeback for temporary files,
then there would be no point in mounting tmpfs on /tmp at all and we'd
get the best of both worlds.

Right now people resort to tmpfs because of this missing feature. And
then have their machines end up in swap hell if they overuse it.

Regards,
Marti



pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Deprecations in authentication
Next
From: Simon Riggs
Date:
Subject: Re: ALTER TABLESPACE ... MOVE ALL TO ...