[Mobilitydb-users] Citus Columnar

[Esteban Zimanyi]

Dear Marc

We are continuously working with Citus, in particular we are exploring with
them how to scale out MobilityDB in a cluster. A first blog on the topic is
https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/analyzing-gps-trajectories-at-scale-with-postgres-mobilitydb-amp/ba-p/1859278

According to my understanding, but this needs to be tested, columnar
storage will not necessarily imply speed up for MobilityDB since a full
trip is encapsulated in a single column, whereas columnar storage is useful
when you access in your queries a small number of columns of the table.
This is illustrated in the example given in the Citus blog about columnar
by Jeff Davis where the test table has 100 columns and the performance was
established with a query that uses 3 out of the 100 columns.

Regards

Esteban

------------------------------------------------------------
Prof. Esteban Zimanyi
Department of Computer & Decision Engineering  (CoDE) CP 165/15
Universite Libre de Bruxelles
Avenue F. D. Roosevelt 50
B-1050 Brussels, Belgium
fax: + 32.2.650.47.13
tel: + 32.2.650.31.85
e-mail: ezimanyi at ulb.ac.be
Internet: http://cs.ulb.ac.be/members/esteban/
------------------------------------------------------------


On Tue, Mar 9, 2021 at 10:21 AM Marc Lebherz <marc-lebherz at t-online.de>
wrote:

> Hi,
>
> the following article came to my attention:
> https://www.citusdata.com/blog/2021/03/06/citus-10-columnar-compression-for-postgres/
> and I was wondering, whether this could bring another performance boost
> for MobilityDB.
>
> Has anyone done some performance test with Citus Columnar and MobilityDB?
>
> Regards,
> Marc
> _______________________________________________
> Mobilitydb-users mailing list
> Mobilitydb-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mobilitydb-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20210309/509ecb5c/attachment.html>