Marco Slot

We received a number of interesting questions during this week's webinar entitled "Columnar Store for PostgreSQL Using cstore_fdw". We wanted to elaborate on a few of them.

"Is it possible/practical to move cstore-tables between servers such as on...

Please join me on September 9th at 10 am Pacific Time for my webinar entitled "Columnar Store for PostgreSQL using cstore_fdw". This webinar will give you a comprehensive overview of cstore_fdw, an open source PostgreSQL extension from Citus Data that...

At this year's PGCon, we gave a talk on pg_shard that included a futuristic pg_shard demo: a distributed table with JSONB fields, backed by a dynamically changing row and columnar store. The demo is based on the GitHub archive data, which comprises...

With the release of Citus 5.0 in 2016, all pg_shard functionality is included directly in Citus. We encourage you to take a look at Citus, instead of pg_shard which is now deprecated. Citus is available as open source and in the cloud, as the Azure...

Learn how to parallelize analytical queries in PostgreSQL through sharding. Join Marco Slot from Citus Data at 10:00 AM PDT on Wednesday, June 10, 2015 for a webinar which will discuss how to use parallel query execution to speed up queries for an...

The pg_shard extension helps you scale out PostgreSQL for large data sets by transparently distributing tables across many nodes, storing (replicated) shards of the data as regular PostgreSQL tables on worker nodes. With pg_shard, you can perform INSERT...

In this post I will present my findings that show a 6x compression of PostgreSQL JSONB data using the cstore_fdw extension. Cstore_fdw is an open source PostgreSQL extension for reducing the storage footprint and speeding up analytical queries. Cstore_fdw...

CitusDB scales out PostgreSQL across commodity servers and processes queries in parallel. Many CitusDB users deploy it on Amazon Web Services (AWS) using Elastic Compute Cloud (EC2), which allows them to easily scale out the number of nodes. However...

Last month we went to PGConf.Russia and gave a talk on [pg_shard](/citus-products/pg-shard) which is available for download on GitHub. pg_shard is an open source PostgreSQL extension which allows users to scale out their database by creating a cluster...

Citus Data is excited to announce the release of cstore_fdw 1.2, which is available on GitHub at https://github.com/citusdata/cstore_fdw. Cstore_fdw is Citus Data's open source columnar store extension for PostgreSQL.

The changes in this release include...