Re: PostgreSQL disk fragmentation causes performance problems on Windows

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: PostgreSQL disk fragmentation causes performance problems on Windows
Дата
Msg-id 555F688B.9030204@agliodbs.com
обсуждение исходный текст
Ответ на PostgreSQL disk fragmentation causes performance problems on Windows  (Jan Gunnar Dyrset <jan.g.dyrset@cybernetica.no>)
Список 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: PostgreSQL disk fragmentation causes performance problems on Windows
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime?