pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Andres Freund <andres@anarazel.de>
Cc: Jan Gunnar Dyrset <jan.g.dyrset@cybernetica.no>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: PostgreSQL disk fragmentation causes performance problems on Windows
Date: Fri, 22 May 2015 10:34:03 -0700
Message-ID: <555F688B.9030204@agliodbs.com> (raw)
In-Reply-To: <WM!d70b8b741e3f8b972b06b19813e1815b8ae9f1af8810d62f1fb3086f5efcea5d9d27f2a668fe503f372195a0d32b0435!@asav-2.01.com>
References: <AMXPR05MB120CFF5F9A4825A531E2018A1ED0@AMXPR05MB120.eurprd05.prod.outlook.com>
	<WM!5502dc21e8e922384b4fcf3ed42c47734f77e3ab0c80c8c587f6bab63ced852a6603e138aa8f0e70a9bf47ce43f78d81!@asav-2.01.com>
	<555E29F0.5030907@agliodbs.com>
	<20150521203913.GB2028@alap3.anarazel.de>
	<WM!d70b8b741e3f8b972b06b19813e1815b8ae9f1af8810d62f1fb3086f5efcea5d9d27f2a668fe503f372195a0d32b0435!@asav-2.01.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On 05/21/2015 01:39 PM, Andres Freund wrote:
> 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.

Well, then, maybe someone should hack and test it ...

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


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



view thread (10+ messages)

Message-ID: <555F688B.9030204@agliodbs.com>
Permalink:  ../555F688B.9030204@agliodbs.com/
Also on:    postgresql.org/message-id/555F688B.9030204@agliodbs.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: josh@agliodbs.com, andres@anarazel.de, jan.g.dyrset@cybernetica.no
  Subject: Re: PostgreSQL disk fragmentation causes performance problems on Windows
  In-Reply-To: <555F688B.9030204@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox