Re: Question on IO consideration

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Ghassan Salem <salem.ghassan@xxxxxxxxx>
  • Date: Wed, 22 Sep 2021 17:40:07 -0400

Yes, I know. Cache is columnar and it somewhat speeds things up. However, to fully utilize columnar features, one needs In-Memory option.  And that's expensive.


On 9/22/21 03:51, Ghassan Salem wrote:

The feature Tanel is mentioning is free, not to be confused with in-memory flashcache, which requires the inmemory option.


On Wed, Sep 22, 2021 at 1:59 AM Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:

    On 9/21/21 17:41, Tanel Poder wrote:
    > Exadata storage cells (starting from cellsrv v12. / Jan
    > can use fully columnar flash cache for greatly speeding up reads
    > cache is fully columnar, not hybrid like the datafile storage).

    And all they want in exchange for that capability is your first-born.
    Bargain price, indeed. BTW, MariaDB can also do that, a bit cheaper.

-- Mladen Gogala
    Database Consultant
    Tel: (347) 321-1217


Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Other related posts: