public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sushrut Shivaswamy <[email protected]>
To: [email protected]
Subject: Columnar Format Export in Postgres
Date: Sat, 8 Jun 2024 20:29:16 +0530
Message-ID: <CAH5mb98zLdXV2wbizeaW2FgckqciMct4DVRAz+V96ctqXimYZg@mail.gmail.com> (raw)

Hey Postgres team,

I have been working on adding support for columnar format export to
Postgres to speed up analytics queries.
I've created an extension that achieves this functionality here
<https://github.com/sushrut141/pg_analytica;.

I"m looking to improve the performance of this extension to enable drop-in
analytics support for Postgres. Some immediate improvements I have in mind
are:
 - Reduce memory consumption when exporting table data to columnar format
 - Create a native planner / execution hook that can read columnar data.

It would be very helpful if you could take a look and suggest improvements
to the extension.
Hopefully, this extension can be shipped by default with postgres at some
point in the future.

Thanks,
Sushrut

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Columnar Format Export in Postgres
  In-Reply-To: <CAH5mb98zLdXV2wbizeaW2FgckqciMct4DVRAz+V96ctqXimYZg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox