On Fri, May 1, 2020 at 4:59 PM Thomas Munro wrote:
> On Fri, May 1, 2020 at 12:28 PM Jonah H. Harris
> wrote:
> > Also, this will likely have an issue with O_DIRECT as additional buffer
> manager alignment is needed and I haven't tracked it down in 13 yet. As my
> default development is on a Mac
On Fri, May 1, 2020 at 12:28 PM Jonah H. Harris wrote:
> Also, this will likely have an issue with O_DIRECT as additional buffer
> manager alignment is needed and I haven't tracked it down in 13 yet. As my
> default development is on a Mac, I have POSIX AIO only. As such, I can't
> natively pla
On 30/4/20 6:22, Thomas Munro wrote:
On Thu, Apr 30, 2020 at 12:26 PM Tomas Vondra
wrote:
Yeah, I think the question is what are the expected benefits of using
raw devices. It might be an interesting exercise / experiment, but my
understanding is that most of the benefits can be achieved by usi
On Wed, Apr 29, 2020 at 8:34 PM Jonah H. Harris
wrote:
> On Tue, Apr 28, 2020 at 8:10 AM Andreas Karlsson
> wrote:
>
>> To get the performance benefits from using raw devices I think you would
>> want to add support for asynchronous IO to PostgreSQL rather than
>> implementing your own layer to
On Thu, Apr 30, 2020 at 12:26 PM Tomas Vondra
wrote:
> Yeah, I think the question is what are the expected benefits of using
> raw devices. It might be an interesting exercise / experiment, but my
> understanding is that most of the benefits can be achieved by using file
> systems but with direct
Tomas Vondra writes:
> Yeah, I think the question is what are the expected benefits of using
> raw devices. It might be an interesting exercise / experiment, but my
> understanding is that most of the benefits can be achieved by using file
> systems but with direct I/O and async I/O, which would a
On Tue, Apr 28, 2020 at 8:10 AM Andreas Karlsson wrote:
> It would require quite a bit of work since 1) PostgreSQL stores its data
> in multiple files and 2) PostgreSQL currently supports only synchronous
> buffered IO.
>
> To get the performance benefits from using raw devices I think you would
On Tue, Apr 28, 2020 at 02:10:51PM +0200, Andreas Karlsson wrote:
On 4/28/20 10:43 AM, Benjamin Schaller wrote:
for an university project I'm currently doing some research on
PostgreSQL. I was wondering if hypothetically it would be possible
to implement a raw device system to PostgreSQL. I kno
On 4/28/20 10:43 AM, Benjamin Schaller wrote:
for an university project I'm currently doing some research on
PostgreSQL. I was wondering if hypothetically it would be possible to
implement a raw device system to PostgreSQL. I know that the
disadvantages would probably be higher than the advanta
Greetings,
* Benjamin Schaller (benjamin.schal...@s2018.tu-chemnitz.de) wrote:
> for an university project I'm currently doing some research on PostgreSQL. I
> was wondering if hypothetically it would be possible to implement a raw
> device system to PostgreSQL. I know that the disadvantages would
Hey,
for an university project I'm currently doing some research on
PostgreSQL. I was wondering if hypothetically it would be possible to
implement a raw device system to PostgreSQL. I know that the
disadvantages would probably be higher than the advantages compared to
working with the file s
11 matches
Mail list logo
