Re: Compression and on-disk sorting - Mailing list pgsql-hackers

From Zeugswetter Andreas DCP SD
Subject Re: Compression and on-disk sorting
Date
Msg-id E1539E0ED7043848906A8FF995BDA57901054324@m0143.s-mxs.net
Whole thread Raw
In response to Compression and on-disk sorting  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
> > Personally, I believe it would be worth it - but only to a few. And
> > these most of these few are likely using Oracle. So, no gain unless
> > you can convince them to switch back... :-)
>
> We do know that the benefit for commercial databases that use raw and
> file system storage is that raw storage is only a few percentage
> points faster.

Imho it is really not comparable because they all use direct or async IO
that bypasses the OS buffercache even when using filesystem files for
storage.
A substantial speed difference is allocation of space for restore
(no format of fs and no file allocation needed).

I am not saying this to advocate moving in that direction however.
I do however think that there is substantial headroom in reducing the
number
of IO calls and reducing on disk storage requirements.
Especially in concurrent load scenarios.

Andreas


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas DCP SD"
Date:
Subject: Re: Compression and on-disk sorting
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [BUGS] BUG #2429: Explain does not report object's schema