News for hackers. Stuff that matters.
Re:Faster DISTINCT queries on PostgreSQL by jereze on Friday May 07, 2021 @03:18AM (#27073227)
I made first tests with Timescale 10 days ago with logs of a website. First result, I was impressed by the compression: 13GB of compressed CSV files - 1 PostgreSQL table of 63GB - 1 Timescale hypertable of 4GB. Then, I saw improvements on the performance of my queries, between 23% and 92% faster on the hypertable versus the table. This is definitely interesting and I will look into it further. I'm getting from "it's not a good idea to put weblogs on Postgresql" to "why not, if it helps simplify our infra".

There are no comments on this comment yet.