Groups

cstore users

Contact owners and managers

1–30 of 123

A group for discussing the cstore_fdw Postgres extension, to learn more about the extension see http://citusdata.github.io/cstore_fdw/

0 selected

11/7/21

Suggestions for fast retrieval of financial time-series, daily close prices

Hello: Apologies in advanced for the n00b questions. I am looking for general discussion and guidance

unread,

Suggestions for fast retrieval of financial time-series, daily close prices

Hello: Apologies in advanced for the n00b questions. I am looking for general discussion and guidance

11/7/21

Abdullah Hanefi Önaldı

6/25/21

Hi, Columnar storage is now part of the Citus extension, and is recommended to use instead of

unread,

Hi, Columnar storage is now part of the Citus extension, and is recommended to use instead of

6/25/21

Marco Slot, Martin Loetzsch2

3/10/21

Important announcement: Columnar storage is now part of Citus

Thanks Marco, this is really great news. We use cstore_fdw a lot for serving flat fat fact tables to

unread,

Important announcement: Columnar storage is now part of Citus

Thanks Marco, this is really great news. We use cstore_fdw a lot for serving flat fat fact tables to

3/10/21

gabi...@gmail.com, Marco Slot4

3/10/21

The future of cstore_fdw

The Citus and cstore_fdw extensions can co-exist so you can do: INSERT INTO citus_columnar_table

unread,

The future of cstore_fdw

The Citus and cstore_fdw extensions can co-exist so you can do: INSERT INTO citus_columnar_table

3/10/21

ksheersagar Sathish

10/27/20

Team Please let me know how to do FWD Tables data migration from one postgres to other postgres.

unread,

Team Please let me know how to do FWD Tables data migration from one postgres to other postgres.

10/27/20

10/20/20

cstore_fwd about table disk size.

Hi How can i learn table disk size Where can I see the compressed file size thaks.

unread,

cstore_fwd about table disk size.

Hi How can i learn table disk size Where can I see the compressed file size thaks.

10/20/20

Scott Goley, Murat Tuncer2

8/19/20

cstore_fdw and Heroku w Citus OR Postgres

Hi Scott, It mostly depends on heroku to enable cstore_fdw extension in their service. I am not aware

unread,

cstore_fdw and Heroku w Citus OR Postgres

Hi Scott, It mostly depends on heroku to enable cstore_fdw extension in their service. I am not aware

8/19/20

Raja Kt, Murat Tuncer2

8/19/20

Urgent help needed: PostgreSQL columnar + Apache Spark

Hi Raja, You can get cstore_fdw from github https://github.com/citusdata/cstore_fdw and build/install

unread,

Urgent help needed: PostgreSQL columnar + Apache Spark

Hi Raja, You can get cstore_fdw from github https://github.com/citusdata/cstore_fdw and build/install

8/19/20

Moses Mafusire, Murat Tuncer2

8/19/20

NEWBIE... cstore_fdw on windows 10?

cstore_fdw is not supported on windows at this time. You can follow the instructions on github page

unread,

NEWBIE... cstore_fdw on windows 10?

cstore_fdw is not supported on windows at this time. You can follow the instructions on github page

8/19/20

Morten Grøftehauge2

3/2/20

SERIAL for id in cstore

Wait sorry, I think I get it. if the table is instantiated as -- create foreign table CREATE FOREIGN

unread,

SERIAL for id in cstore

Wait sorry, I think I get it. if the table is instantiated as -- create foreign table CREATE FOREIGN

3/2/20

Murat Tuncer, zohaib khan3

2/18/20

cstore_fdw 1.7.0 is now available

It has PG12 support and few bug fixes. It does not add new features. On Tuesday, February 18, 2020 at

unread,

cstore_fdw 1.7.0 is now available

It has PG12 support and few bug fixes. It does not add new features. On Tuesday, February 18, 2020 at

2/18/20

zohaib khan, … Murat Tuncer10

1/17/20

Citus columnar copy command issue in different sessions

please find strace log attached. On Friday, January 17, 2020 at 5:41:36 PM UTC, zohaib khan wrote: Is

unread,

Citus columnar copy command issue in different sessions

please find strace log attached. On Friday, January 17, 2020 at 5:41:36 PM UTC, zohaib khan wrote: Is

1/17/20

Alex, Murat Tuncer2

10/16/19

Can multiple postgres databases use the same cstore_fdw?

Yes it is possible, but I do not recommend it. You might end up corrupting data if both databases

unread,

Can multiple postgres databases use the same cstore_fdw?

Yes it is possible, but I do not recommend it. You might end up corrupting data if both databases

10/16/19

Leonid Khomenko, Murat Tuncer2

9/3/19

cstore_fdw replication

Hello, Unfortunately situation has not changed since that time. streaming replication support

unread,

cstore_fdw replication

Hello, Unfortunately situation has not changed since that time. streaming replication support

9/3/19

Kannan Mookaiah, Hanefi Onaldi2

7/18/19

cstore_fdw along with citus

Hi Kannan, shared_preload_libraries = 'citus,cstore_fdw' does the trick. I hope you already

unread,

cstore_fdw along with citus

Hi Kannan, shared_preload_libraries = 'citus,cstore_fdw' does the trick. I hope you already

7/18/19

Lee Hachadoorian, … Murat Tuncer4

6/7/19

Does cstore_fdw get around Postgres 8kb row size limit?

cstore itself does not enforce a maximum but PG limits column count to 1600. On Fri, Jun 7, 2019, 18:

unread,

Does cstore_fdw get around Postgres 8kb row size limit?

cstore itself does not enforce a maximum but PG limits column count to 1600. On Fri, Jun 7, 2019, 18:

6/7/19

Sanyo Capobiango, Martin Loetzsch2

5/24/19

PostgreSql parent table partitioned in foreign cstore_fdw

Hi Sanyo, I think it's not possible, the partition routing does not work (yet) for cstore_fdw. We

unread,

PostgreSql parent table partitioned in foreign cstore_fdw

Hi Sanyo, I think it's not possible, the partition routing does not work (yet) for cstore_fdw. We

5/24/19

aram harutyunyan

4/19/19

group by many columns

I have an old database and db query, now I am trying to make warehouse but query has a lot of fields

unread,

group by many columns

I have an old database and db query, now I am trying to make warehouse but query has a lot of fields

4/19/19

Kannan Mookaiah, Murat Tuncer2

12/16/18

make: *** No targets specified and no makefile found. Stop

That is odd, you are getting an error as if makefile is not there. please check that you are in the

unread,

make: *** No targets specified and no makefile found. Stop

That is odd, you are getting an error as if makefile is not there. please check that you are in the

12/16/18

Murat Tuncer, … Bibek Dawadi5

10/23/18

cstore_fdw v1.6.1 (silent release)

Hi Anton, Download link is broken. Is it available somewhere else? On Saturday, 23 June 2018 16:31:25

unread,

cstore_fdw v1.6.1 (silent release)

Hi Anton, Download link is broken. Is it available somewhere else? On Saturday, 23 June 2018 16:31:25

10/23/18

Juan Emilio Gabito Decuadra

10/9/18

Hi everyone. I've been reading the roadmap wiki and I see that this are the features planed for

unread,

Hi everyone. I've been reading the roadmap wiki and I see that this are the features planed for

10/9/18

Piyush Katariya

9/9/18

Postgres 11 push down operations

Postgres 11 will come with push down operations to foreign data wrappers. https://www.postgresql.org/

unread,

Postgres 11 push down operations

Postgres 11 will come with push down operations to foreign data wrappers. https://www.postgresql.org/

9/9/18

hemant agrawal, Murat Tuncer5

6/26/18

Alter table with check constraint and inheritance

ya thanks... but I have done poc and I got the same result in both inheritance and partitioning table

unread,

Alter table with check constraint and inheritance

ya thanks... but I have done poc and I got the same result in both inheritance and partitioning table

6/26/18

Juan Emilio Gabito Decuadra, Murat Tuncer2

6/25/18

Dictionary pushdown

Hi Juan Emilio, What you describe can be achieved by adding bloom filter or hash table like structure

unread,

Dictionary pushdown

Hi Juan Emilio, What you describe can be achieved by adding bloom filter or hash table like structure

6/25/18

Juan Emilio Gabito Decuadra, Murat Tuncer4

5/25/18

Performance issues

Glad to hear that you got the performance gain. It was about how postgres plans aggregates. In the

unread,

Performance issues

Glad to hear that you got the performance gain. It was about how postgres plans aggregates. In the

5/25/18

Juan Emilio Gabito Decuadra, Murat Tuncer3

5/9/18

Order of rows in query

Indeed is using the HashAggregate strategy: "HashAggregate (cost=49445.99..49446.00 rows=1 width

unread,

Order of rows in query

Indeed is using the HashAggregate strategy: "HashAggregate (cost=49445.99..49446.00 rows=1 width

5/9/18

Juan Emilio Gabito Decuadra, … Balazs Gunics5

4/10/18

Is the project still alive?

Hello Balázs, Do you use cstore in combination with citus? What about table config? You create the

unread,

Is the project still alive?

Hello Balázs, Do you use cstore in combination with citus? What about table config? You create the

4/10/18

Narendra Pradeep, Murat Tuncer2

10/10/17

Alter Table Options

Hey Pradeep Thanks for reporting the issue. I opened ticket https://github.com/citusdata/cstore_fdw/

unread,

Alter Table Options

Hey Pradeep Thanks for reporting the issue. I opened ticket https://github.com/citusdata/cstore_fdw/

10/10/17

Adam Scott, Murat Tuncer3

10/4/17

Wow, that's a wonderful new feature. We certainly could use that. Thank you Murat! Adam On Mon,

unread,

Wow, that's a wonderful new feature. We certainly could use that. Thank you Murat! Adam On Mon,

10/4/17

Leo Meyerovich, Murat Tuncer4

9/15/17

Columnar data ingest/export

cstore uses 2 layered approach to store data 1 - blocks - a column block contains 10K rows of data

unread,

Columnar data ingest/export

cstore uses 2 layered approach to store data 1 - blocks - a column block contains 10K rows of data

9/15/17

Search

Clear search

Close search

Google apps

Main menu