Forwarded from postgresources (Oleg Kovalov 🇺🇦)
Tembo
Optimizing Postgres's Autovacuum for High-Churn Tables | Tembo
Learn how to optimize Postgres autovacuum settings for high-churn tables to prevent table bloat, improve query performance, and increase transaction throughput. This hands-on guide explores how to tune scale factors, cost limits, and timing parameters with…
A few words about Snowflake's built-in data lineage
https://dwh.dev/blog/the-gaps-in-snowflake-internal-lineage
and give me some likes here plz
https://www.linkedin.com/feed/update/urn:li:activity:7105458338565357569/
https://dwh.dev/blog/the-gaps-in-snowflake-internal-lineage
and give me some likes here plz
https://www.linkedin.com/feed/update/urn:li:activity:7105458338565357569/
😱1
😁23👎7❤2🔥2😢1
JOINs are not an Euler diagrams (if you didn’t know…)
https://x.com/milan_milanovic/status/1710639221893943323
https://x.com/milan_milanovic/status/1710639221893943323
👍17🤔2👎1
It's been a long time since last SQL-WTF SQL-TIL...
This construct doesn't work in Postgresql, Mysql, DuckDB, or Snowflake.
But it does work... in sqlite 🙂
SELECT * FROM (((t as t1) as t2) as t3);
This construct doesn't work in Postgresql, Mysql, DuckDB, or Snowflake.
But it does work... in sqlite 🙂
😱6