we were able to use a brin index for our time-series data and that saved
a lot of space. basically, we used a btree for recent data and, once the
data was "stable", reclustered the data to get high correlation on the
brin index, created a brin index and dropped the btree. it works well.
On 4/1
On Mon, Apr 15, 2019 at 10:43 AM Ray Cheung <
ray.che...@silverpowersystems.com> wrote:
> Hi ,
>
> We are currently contemplating switching from MySQL to PostgreSQL, the main
> attraction being the use of the TimescaleDB extension. Having done much of
> the ground investigation there is one area o
Hi ,
We are currently contemplating switching from MySQL to PostgreSQL, the main
attraction being the use of the TimescaleDB extension. Having done much of
the ground investigation there is one area of significant concern - the
storage requirement of PostgreSQL. Put simply, comparing like for like
