Re: PostgreSQL Columnar Store for Analytic Workloads - Mailing list pgsql-hackers

From Hadi Moshayedi
Subject Re: PostgreSQL Columnar Store for Analytic Workloads
Date
Msg-id CAK=1=Wo7Jj=WtvaSWHcXF0ePC5ob5pOH0wHbUzzxO7sEAMFxQg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Columnar Store for Analytic Workloads  (Stefan Keller <sfkeller@gmail.com>)
List pgsql-hackers
Hi Stefan,

On Tue, Apr 8, 2014 at 9:28 AM, Stefan Keller <sfkeller@gmail.com> wrote:
Hi Hadi

Do you think that cstore_fdw 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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Why is it not sane to pass ExecStoreTuple(shouldFree=true) for tuples point into buffers
Next
From: Robert Haas
Date:
Subject: Re: Fwd: Proposal: variant of regclass