# \#performance **URL:** https://community.cratedb.com/tag/performance/10.md [Latest](https://community.cratedb.com/latest.md) · [Categories](https://community.cratedb.com/categories.md) · [Tags](https://community.cratedb.com/tags.md) --- ## [Performance Question: Any impact of replacing CTEs with VIEWs?](https://community.cratedb.com/t/performance-question-any-impact-of-replacing-ctes-with-views/2025)
**Author:** [@robd003](https://community.cratedb.com/u/robd003)\ **Replies:** 0\ **Last updated:** [April 4, 2025, 11:09pm UTC](https://community.cratedb.com/t/performance-question-any-impact-of-replacing-ctes-with-views/2025 "2025-04-04T23:09:43Z")
I’m using a lot of common CTEs throughout my queries and I was wondering if there would be any performance impact if I just “saved” these as VIEWs. --- ## [It doesn't work after increasing total\_shards\_per\_node](https://community.cratedb.com/t/it-doesnt-work-after-increasing-total-shards-per-node/2012)
**Author:** [@Jun\_Zhou](https://community.cratedb.com/u/Jun_Zhou)\ **Replies:** 2\ **Last updated:** [March 26, 2025, 1:26am UTC](https://community.cratedb.com/t/it-doesnt-work-after-increasing-total-shards-per-node/2012 "2025-03-26T01:26:40Z")
Hi team, I’m using CrateDB 5.10.3 and created more than 150 tables with default value 8 of number\_of\_shards, so that I encounter below error. I try to set "cluster.routing.allocation.total\_shards\_per\_node" = '5000'; and … --- ## [Advanced downsampling with the LTTB algorithm](https://community.cratedb.com/t/advanced-downsampling-with-the-lttb-algorithm/1287)
**Author:** [@hernanc](https://community.cratedb.com/u/hernanc)\ **Replies:** 0\ **Last updated:** [November 10, 2022, 10:48am UTC](https://community.cratedb.com/t/advanced-downsampling-with-the-lttb-algorithm/1287 "2022-11-10T10:48:36Z")
Introduction Downsampling is the process of transforming data, reducing its resolution so that it requires less space, while preserving some of its basic characteristics so that it is still usable. There are a number … --- ## [Scaling CrateDB clusters up and down to cope with peaks in demand](https://community.cratedb.com/t/scaling-cratedb-clusters-up-and-down-to-cope-with-peaks-in-demand/1314)
**Author:** [@hernanc](https://community.cratedb.com/u/hernanc)\ **Replies:** 0\ **Last updated:** [December 20, 2022, 4:35pm UTC](https://community.cratedb.com/t/scaling-cratedb-clusters-up-and-down-to-cope-with-peaks-in-demand/1314 "2022-12-20T16:35:40Z")
This content has been migrated. --- ## [Sharding and partitioning guide for time-series data](https://community.cratedb.com/t/sharding-and-partitioning-guide-for-time-series-data/737)
**Author:** [@jayeff](https://community.cratedb.com/u/jayeff)\ **Replies:** 0\ **Last updated:** [July 2, 2021, 9:07am UTC](https://community.cratedb.com/t/sharding-and-partitioning-guide-for-time-series-data/737 "2021-07-02T09:07:46Z")
The goal of this guide is to support you with building a sharding and partitioning strategy for your time series data. Let’s start with your time series data which you want to store in a table in CrateDB. You need to c… --- ## [Using common table expressions to speed up queries](https://community.cratedb.com/t/using-common-table-expressions-to-speed-up-queries/1719)
**Author:** [@hernanc](https://community.cratedb.com/u/hernanc)\ **Replies:** 0\ **Last updated:** [February 22, 2024, 9:25am UTC](https://community.cratedb.com/t/using-common-table-expressions-to-speed-up-queries/1719 "2024-02-22T09:25:57Z")
Today I want to share with you a pattern you can use to replace JOINs with CTEs in your SQL queries and achieve consistent and faster execution times. Consider a database where we store information about invoices, a sim… --- ## [Reducing disk read operations from statistics collection](https://community.cratedb.com/t/reducing-disk-read-operations-from-statistics-collection/1315)
**Author:** [@hammerhead](https://community.cratedb.com/u/hammerhead)\ **Replies:** 0\ **Last updated:** [December 21, 2022, 9:21am UTC](https://community.cratedb.com/t/reducing-disk-read-operations-from-statistics-collection/1315 "2022-12-21T09:21:02Z")
CrateDB regularly populates the system table pg\_catalog.pg\_stats. It contains approximate statistical information at the column level, such as a column’s number of distinct values or most common values. Client applicatio… --- ## [Optimizing storage for historic time-series data](https://community.cratedb.com/t/optimizing-storage-for-historic-time-series-data/762)
**Author:** [@hammerhead](https://community.cratedb.com/u/hammerhead)\ **Replies:** 10\ **Last updated:** [June 22, 2022, 9:31am UTC](https://community.cratedb.com/t/optimizing-storage-for-historic-time-series-data/762 "2022-06-22T09:31:04Z")
When dealing with time-series data, performance is crucial. Data that gets ingested should be available quickly for querying. To enable fast decision-making, analytical queries often need to return results in a fractio… --- ## [Guide to decrease the number of shards in your cluster](https://community.cratedb.com/t/guide-to-decrease-the-number-of-shards-in-your-cluster/873)
**Author:** [@jayeff](https://community.cratedb.com/u/jayeff)\ **Replies:** 3\ **Last updated:** [June 3, 2022, 3:39pm UTC](https://community.cratedb.com/t/guide-to-decrease-the-number-of-shards-in-your-cluster/873 "2022-06-03T15:39:39Z")
Potentially you created your tables with too many shards and want to rectify this situation. Some indications for too many shards can be: you have many small shards with typical shard sizes being below 5GB, or you ha…