Citus Blog

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 master-less (or multi-master, if you prefer) layer that can be enabled directly in the database without the need for external tools or transaction managers.

It may surprise you that pagination, pervasive as it is in web applications, is easy to implement inefficiently. In this article we'll examine several methods of server-side pagination and discuss their tradeoffs when implemented in PostgreSQL. This article will help you identify which technique is appropriate for your situation, including some you may not have seen before which rely on physical clustering and the database stats collector.

When we started working on CitusDB 1.0 four years ago, we envisioned scaling out relational databases. We loved Postgres (and the elephant) and picked it as our underlying database of choice. Our goal was to extend this database to seamlessly shard

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 adding new data at high rates and use PostgreSQL's powerful indexing...

The first annual PGConfSV that took place in November 2015 saw a good level of attendance with 270+ registrants, 31 speakers and 9 sponsors. Of course if you missed it you can check out the collection of videos and slides over on the site from last...

For a game the western world doesn't know much about Go is implausibly harder than Chess. Forget playing it, it's hard to even tell who's winning. Humans have trouble scoring a half-completed game between pros.

On average, there are 250 different...

Citus Data is excited to announce the release of cstore_fdw 1.4. cstore_fdw is an open source columnar store extension for PostgreSQL that compresses your database tables and reduces disk I/O.

cstore_fdw Changes

The changes in this release include...