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".
[ Parent
| on HN ]
There are no comments on this comment yet.