Re: PostgreSQL disk fragmentation causes performance problems on Windows - Mailing list pgsql-performance

From Vitalii Tymchyshyn
Subject Re: PostgreSQL disk fragmentation causes performance problems on Windows
Date
Msg-id CABWW-d0Adfnx7qvTLG2eskMnGDqVYNt=hN2cr+ssa_F3d1WjXQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL disk fragmentation causes performance problems on Windows  (Andres Freund <andres@anarazel.de>)
List pgsql-performance

It may be even easier. AFAIR, it's possible just to tell OS expected allocation without doing it. This way nothing changes for general code, it's only needed to specify expected file size on creation.

Please see FILE_ALLOCATION_INFO: https://msdn.microsoft.com/en-us/library/windows/desktop/aa364214(v=vs.85).aspx

Чт, 21 трав. 2015 16:39 Andres Freund <andres@anarazel.de> пише:
On 2015-05-21 11:54:40 -0700, Josh Berkus wrote:
> This has been talked about as a feature, but would require major work on
> PostgreSQL to make it possible.  You'd be looking at several months of
> effort by a really good hacker, and then a whole bunch of performance
> testing.  If you have the budget for this, then please let's talk about
> it because right now nobody is working on it.

I think this is overestimating the required effort quite a bit. While
not trivial, it's also not that complex to make this work.

Greetings,

Andres Freund


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: PostgreSQL disk fragmentation causes performance problems on Windows
Next
From: Josh Berkus
Date:
Subject: Re: PostgreSQL disk fragmentation causes performance problems on Windows