citusdata / citusdata/cstore_fdw

Support single row inserts with column values

Open
#91 2 comments 8 reactions 0 assignees View on GitHub
enhancement
Dominant language
C
Stars
1.8k
Forks
169
PR merge metrics
No merged PRs in 30d

Description

cstore_fdw should support insert statements in the form of

```
insert into cstore_table values(value1, value2....)
insert into cstore_table(column1, column2...) values(value1, value2....)
insert into cstore_table values(value1, value2....), (othervalue1, othervalue2,...) ...
insert into cstore_table(column1, column2...) values(value1, value2....), (othervalue1, othervalue2,...) ...
```

1 - single row insert with all column values
2 - single row insert with selected column values
3 - multiple row insert with all column values
3 - multiple row insert with selected column values

Creation of a new stripe for each insert statements was the reason preventing single row inserts. Now we need to change that behavior. Solution would probably look like loading the last stripe for the insert, appending to it and saving it back. Concurrent inserts should also be considered.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.