Re: PostgreSQL Columnar Store for Analytic Workloads

From: Hadi Moshayedi <hadi(at)citusdata(dot)com>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL Columnar Store for Analytic Workloads
Date: 2014-04-08 14:20:29
Message-ID: CAK=1=Wo7Jj=WtvaSWHcXF0ePC5ob5pOH0wHbUzzxO7sEAMFxQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Stefan,

On Tue, Apr 8, 2014 at 9:28 AM, Stefan Keller <sfkeller(at)gmail(dot)com> wrote:

> Hi Hadi
>
> Do you think that cstore_fd*w* is also welll suited for storing and
> retrieving linked data (RDF)?
>

I am not very familiar with RDF. Note that cstore_fdw doesn't change the
query language of PostgreSQL, so if your queries are expressible in SQL,
they can be answered using cstore_fdw too. If your data is huge and doesn't
fit in memory, then using cstore_fdw can be beneficial for you.

Can you give some more information about your use case? For example, what
are some of your queries? do you have sample data? how much memory do you
have? how large is the data?

-- Hadi

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-04-08 14:34:04 Re: Fwd: Proposal: variant of regclass
Previous Message Andres Freund 2014-04-08 13:48:57 Re: Why is it not sane to pass ExecStoreTuple(shouldFree=true) for tuples point into buffers