Scalable Real-time Product Search using Citus
Scalable Real-time Product Search using PostgreSQL with Citus
Product search is a common, yet sometimes challenging use-case for online retailers and marketplaces. It typically involves a combination of full-text search and filtering by attributes ... Read more
Master-less Distributed Queue with Postgres and PG Paxos
Master-less Distributed Queue with PG Paxos
The following post is contributed by 8Kdata.
An introduction to pg_paxos
Pg_paxos is a database level implementation of the widely renowned Paxos protocol, invented by Leslie Lamport. Pg_paxos offers a... Read more
Interactive Analytics on GitHub Data using PostgreSQL with Citus
Interactive Analytics on GitHub Data using PostgreSQL with Citus
With the Citus extension, you can use PostgreSQL to build applications that interactively query large data sets, for example analytical dashboards. At the same time, you can keep... Read more
Real-Time Analytics in PostgreSQL Webinar
I'm pleased to present an abbreviated version of the tutorial we presented at PGConf Silicon Valley on "Real-Time Analytics in PostgreSQL". Please join me on Wednesday, December 9th at 10 am PST for a webinar in which I will demonstrate how to... Read more
pg_paxos: High Availability Data Replication for PostgreSQL
The Paxos algorithm is a powerful building block for building highly available distributed systems. Paxos can be seen as a function paxos(k,v) that returns the same value on all servers in a group for a certain key (k), and the value is one of the... Read more
Questions from Our Recent Webinar "Scaling PostgreSQL on Amazon Web Services"
In our recent webinar on Scaling PostgreSQL on Amazon Web Services using pg_shard and CitusDB, we received a number of interesting questions, particularly about CitusDB, which transparently shards tables and parallelizes queries across a cluster of... Read more
Webinar on Scaling PostgreSQL on Amazon Web Services
Join us on October 14th at 10 am Pacific Time when I will present our latest webinar entitled "Scaling PostgreSQL on Amazon Web Services." PostgreSQL is often used in Amazon Web Services (AWS) deployments as a versatile data store. However,... Read more
Combined row-based and columnar storage in PostgreSQL 9.5
One of the upcoming features in PostgreSQL 9.5 is foreign table inheritance, which offers a suite of new possibilities for users of foreign data wrappers. An exciting possibility is that you will be able to create a single table in which recent data... Read more
Join the PostgreSQL Meetup in Amsterdam on October 8th
On October 8th at 17:30 the second Dutch PostgreSQL meetup will be held in Amsterdam. Please join us for some very interesting talks.
Andres Freund, a PostgreSQL committer and developer working at Citus Data, will speak about major scalability... Read more
Using Docker to run a pg_shard cluster
Docker is quickly becoming one of the most popular ways of deploying distributed applications. By bundling all dependencies of an application in an easily shippable container, software deployment becomes a process that can be performed quickly and... Read more
Questions from Our Recent Webinar: Columnar Store for PostgreSQL Using cstore_fdw
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-... Read more
Webinar on Columnar Store for PostgreSQL using cstore_fdw on September 9th
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... Read more
A futuristic pg_shard demo: a scalable, dynamically changing row and columnar store in PostgreSQL
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... Read more
How to scale PostgreSQL on Amazon RDS using pg_shard
With the latest release of Citus 5.0–now open source, all pg_shard functionality is included directly in Citus. We encourage you to take a look at it instead of pg_shard which is now deprecated. Further, if you're looking to run Citus on AWS we... Read more
Webinar on Parallelizing Analytical Queries in PostgreSQL on June 10th
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... Read more
Parallel data loading for pg_shard
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... Read more
Compressing PostgreSQL JSONB data 6x using cstore_fdw
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.... Read more
Start a CitusDB Cluster on AWS EC2 Using CloudFormation
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... Read more
PGConf.Russia talk on pg_shard
Last month we went to PGConf.Russia and gave a talk on 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 of commodity servers.... Read more
cstore_fdw 1.2 release notes
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... Read more
PostgreSQL and CitusDB on Raspberry Pi 2
One of the nice things about working at Citus Data is that we get time and budget to work on personal growth projects. A few of us are playing with the Raspberry Pi. I recently got two Raspberry Pi 2's and installed the Raspbian distribution on... Read more
PGConf.Russia interesting takeaways
Last week we were at one of the biggest PostgreSQL events ever held. Nope, it wasn't PGCon, it was the inaugural PGConf.Russia in Moscow. The conference included some very interesting talks. We were especially excited to learn more about several... Read more
Making PostgreSQL scale Hadoop-style: Benchmark numbers
PostgreSQL is one of the most popular open-source databases thanks to its reliability and advanced feature set. At Citus Data, we scale out PostgreSQL across many machines to enable queries over large datasets. We are often asked how CitusDB... Read more
Subscribe to Blog