Re: Postgres, fsync, and OSs (specifically linux)

From: Andres Freund <andres(at)anarazel(dot)de>
To: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
Cc: Craig Ringer <craig(at)2ndquadrant(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Postgres, fsync, and OSs (specifically linux)
Date: 2018-05-22 01:08:23
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2018-05-19 18:12:52 +1200, Thomas Munro wrote:
> On Sat, May 19, 2018 at 4:51 PM, Thomas Munro
> <thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> > Next, make check hangs in initdb on both of my pet OSes when md.c
> > raises an error (fseek fails) and we raise and error while raising and
> > error and deadlock against ourselves. Backtrace here:
> >
> Ah, I see now that something similar is happening on Linux too, so I
> guess you already knew this.

I didn't. I cleaned something up and only tested installcheck
after... Singleuser mode was broken.

Attached is a new version.

I've changed my previous attempt at using transient files to using File
type files, but unliked from the LRU so that they're kept open. Not sure
if that's perfect, but seems cleaner.


Andres Freund

Attachment Content-Type Size
v2-0001-freespace-Don-t-constantly-close-files-when-readi.patch text/x-diff 1.6 KB
v2-0002-Add-functions-to-send-receive-data-FD-over-a-unix.patch text/x-diff 3.5 KB
v2-0003-Make-FileGetRawDesc-ensure-there-s-an-associated-.patch text/x-diff 763 bytes
v2-0004-WIP-Add-FileOpenForFd.patch text/x-diff 4.5 KB
v2-0005-WIP-Optimize-register_dirty_segment-to-not-repeat.patch text/x-diff 10.0 KB
v2-0006-Heavily-WIP-Send-file-descriptors-to-checkpointer.patch text/x-diff 45.3 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2018-05-22 01:28:14 Re: Problem while updating a foreign table pointing to a partitioned table on foreign server
Previous Message Mike Blackwell 2018-05-22 01:07:03 [PATCH] Clear up perlcritic 'missing return' warning