From: | Sushrut Shivaswamy <sushrut(dot)shivaswamy(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Columnar Format Export in Postgres |
Date: | 2024-06-08 14:59:16 |
Message-ID: | CAH5mb98zLdXV2wbizeaW2FgckqciMct4DVRAz+V96ctqXimYZg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2024-06-08 16:23:22 | Re: Question on pg_cron |
Previous Message | veem v | 2024-06-08 13:33:07 | How to create efficient index in this scenario? |