| From: | Sushrut Shivaswamy <sushrut(dot)shivaswamy(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Columnar format export in Postgres |
| Date: | 2024-06-12 16:56:30 |
| Message-ID: | CAH5mb9_YW76_0xBU2T4C7HF33b+b2w3QBtV50_ZZMy8SA8ChjA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
with vectorised operations.
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 | Alexander Lakhin | 2024-06-12 17:00:00 | Re: BF mamba failure |
| Previous Message | Daniele Varrazzo | 2024-06-12 16:46:23 | Re: RFC: adding pytest as a supported test framework |