Re: [GENERAL] Write-optimized data structures - Mailing list pgsql-general

From Merlin Moncure
Subject Re: [GENERAL] Write-optimized data structures
Date
Msg-id CAHyXU0zsY43cPvOe5KNAQwtbk2hibr+rwik1KTyV_kuR-78wqQ@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Write-optimized data structures  (selforganized <selforganized@gmail.com>)
List pgsql-general
On Thu, Dec 29, 2016 at 4:03 PM, selforganized <selforganized@gmail.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


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] PostgreSQL not reusing free space in table ?
Next
From: Job
Date:
Subject: R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22