Re: Anyone for SSDs? - Mailing list pgsql-hackers

From Daniel Loureiro
Subject Re: Anyone for SSDs?
Date
Msg-id AANLkTinia5uFimyc__CR83s7-58coOvWYY1EzZ8spD=L@mail.gmail.com
Whole thread Raw
In response to Anyone for SSDs?  (Vaibhav Kaushal <vaibhavkaushal123@gmail.com>)
Responses Re: Anyone for SSDs?  (Jeff Janes <jeff.janes@gmail.com>)
Re: Anyone for SSDs?  (Josh Berkus <josh@agliodbs.com>)
Re: Anyone for SSDs?  (Hannu Krosing <hannu@2ndquadrant.com>)
List pgsql-hackers
>> Most of you already know I am new to this list and newer to any OSS
>> development. However, while browsing the source code (of 9.0.1) I find
>> that there is only one way to store relations on disk - the magnetic
>> disk.

>The fact that it's called md.c is a hangover from the '80s.  These days,
>the logic that the Berkeley guys envisioned being at that code level
>is generally in kernel device drivers.  md.c can drive anything that
>behaves as a block device + filesystem, which is pretty much everything
>of interest.

I believe that PostgreSQL was been developed and optimized for
sequential access. To get full advantage of SSDs its necessary to
rewrite almost the whole project - there are so much code written with
the sequential mechanism in mind.

--
Daniel Loureiro


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: ALTER EXTENSION ... UPGRADE; (was: Extensions, patch v16)
Next
From: Josh Berkus
Date:
Subject: Re: ALTER EXTENSION ... UPGRADE;