| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Jan Gunnar Dyrset <jan(dot)g(dot)dyrset(at)cybernetica(dot)no>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL disk fragmentation causes performance problems on Windows |
| Date: | 2015-05-22 17:34:03 |
| Message-ID: | 555F688B.9030204@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2015-05-22 21:17:44 | Re: How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime? |
| Previous Message | Vitalii Tymchyshyn | 2015-05-21 23:16:07 | Re: PostgreSQL disk fragmentation causes performance problems on Windows |