Re: Write-optimized data structures

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: selforganized <selforganized(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Write-optimized data structures
Date: 2017-01-06 15:27:52
Message-ID: CAHyXU0zsY43cPvOe5KNAQwtbk2hibr+rwik1KTyV_kuR-78wqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Dec 29, 2016 at 4:03 PM, selforganized <selforganized(at)gmail(dot)com> wrote:
> Hi,
>
> Does Postgresql have any write-optimized data structure like LSM-tree? if
> not is there any plan to implement that?
>
> I'm building a write-heavy OLTP application. I'm looking at write-optimized
> databases like MyRocks, TokuDB, and Cassandra but I'd prefer to stay within
> Postgresql. Would PG makes sense for such usage?

The database world is unfortunately full of hype. Some of it is real,
but buyer beware. Are you sure the current postgres architecture
can't sustain your application? If so, why?

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Job 2017-01-06 15:56:13 R: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Previous Message Merlin Moncure 2017-01-06 15:00:06 Re: PostgreSQL not reusing free space in table ?