Peter Dimitroff (@peter_the_coder) en Piclur: Quick reminder that Materialized Views in Clickhouse create a new physical table that does not inherit the source table’s PRIMARY KEY, PARTITION or ORDER BY.You have to add those to the view definition, otherwise instead of say 20x faster, your queries may end up say 5x slower! / Piclur

Peter Dimitroff

15 feb 2024

Quick reminder that Materialized Views in Clickhouse create a new physical table that does not inherit the source table’s PRIMARY KEY, PARTITION or ORDER BY. You have to add those to the view definition, otherwise instead of say 20x faster, your queries may end up say 5x slower!

United States Tendencias

1. Good Wednesday 27.2K posts
2. #Talus_Labs N/A
3. Hump Day 14.8K posts
4. #wednesdaymotivation 5,001 posts
5. Bwipo 1,339 posts
6. #HeartQuakeMV 226K posts
7. ZEENUNEW CRAZY SINGLE 226K posts
8. #Wednesdayvibe 1,888 posts
9. Happy Hump 9,638 posts
10. Howard University N/A
11. $BYND 127K posts
12. #WednesdayWisdom N/A
13. Keke 5,946 posts
14. Izzo N/A
15. Usha Vance 9,704 posts
16. SEKI HONEYMOON X LINGORM 505K posts
17. Beyond Meat 7,474 posts
18. Froot N/A
19. Meet the President 10.4K posts
20. St. John Paul II 2,650 posts

Something went wrong.