There will be no singularity

There will be no singularity Photo

• 🤯 9
• 😁 3
• 🔥 1
• 😢 1

There will be no singularity Photo

• 🔥 19
• 💩 1

Forwarded from Oleg Kovalov 🇺🇦

Supabase Supavisor: Scaling Postgres to 1 Million Connections Supavisor is a scalable, cloud-native Postgres connection pooler. We connected a million clients to it to see how it performs.

• 🤔 4
• 🔥 3
• ⚡ 2

• 👍 20
• 👻 5
• 😁 2
• ❤ 1

There will be no singularity Now in snowflake... create table t (a int, b int, c int); create view v as select * exclude (a) rename (b as d, c as e) from t ; ... and in dwh.dev and parsers.dev!

• 🤯 5
• 👍 2
• ❤ 1

• 🔥 11
• 🥴 5

Forwarded from Oleg Kovalov 🇺🇦

GitHub GitHub - supabase-community/postgres-language-server: A Language Server for Postgres A Language Server for Postgres. Contribute to supabase-community/postgres-language-server development by creating an account on GitHub.

• 🔥 16
• 👍 2
• 🤡 2
• 🤩 1

• ❤ 7
• 🔥 5
• ⚡ 1

Forwarded from Oleg Kovalov 🇺🇦

Forwarded from Oleg Kovalov 🇺🇦

Cockroachlabs Performance Benefits of NOT NULL Constraints on Foreign Key Reference Columns NOT NULL constraints are a ubiquitous tool for upholding data integrity. However, their performance benefits are less obvious. In this post we'll examine a few of these optimizations that transform query plans involving foreign key relationships.