正在加载视频...

视频加载失败

加载此视频时出现问题。这可能是由于临时网络问题，或视频可能不可用。

The most important database feature you hope to never need: Backups. What Postgres does under the hood is far more interesting than a simple data copy. We're diving deep into the process in our latest article.

PlanetScale

42,361 subscribers

53,741 次观看 • 1 个月前 •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

more important than what you do is the conviction in what you’re doing $TRUST the process🙏

more important than what you do is the conviction in what you’re doing $TRUST the process🙏

Trust The Process. 🙏

13,077 次观看 • 1 年前

What Postgres can’t do alone, it can tackle with DuckDB. The pg_duckdb extension shows how two databases can work hand in hand by querying analytical data with DuckDB and joining it with transactional data in Postgres. The extension embeds DuckDB directly into Postgres. DuckDB literally runs inside a Postgres process. How it works (see diagram): 1. An app sends a query to Postgres joining portfolio data (Postgres) with historical market data (lakehouse) 2. pg_duckdb detects lakehouse access and delegates execution to DuckDB 3. DuckDB pulls required market data from the lakehouse, queries Postgres tables, and performs the join 4. Postgres returns the final result to the app

What Postgres can’t do alone, it can tackle with DuckDB. The pg_duckdb extension shows how two databases can work hand in hand by querying analytical data with DuckDB and joining it with transactional data in Postgres. The extension embeds DuckDB directly into Postgres. DuckDB literally runs inside a Postgres process. How it works (see diagram): 1. An app sends a query to Postgres joining portfolio data (Postgres) with historical market data (lakehouse) 2. pg_duckdb detects lakehouse access and delegates execution to DuckDB 3. DuckDB pulls required market data from the lakehouse, queries Postgres tables, and performs the join 4. Postgres returns the final result to the app

Denis Magda

28,678 次观看 • 7 个月前

Tonight we played with energy, passion and soul. This early in the process, that is the most important thing I can ask. Travelling Potters, we appreciate you more than you know! 🔴⚪️

Tonight we played with energy, passion and soul. This early in the process, that is the most important thing I can ask. Travelling Potters, we appreciate you more than you know! 🔴⚪️

Narcís Pèlach Nadal

75,728 次观看 • 1 年前

Have you ever wanted to take your C.A.M.P. Pet out into the wasteland to travel and fight alongside you? The latest #Fallout76 Public Test Server is live and we're testing our World Pets feature which is planned to release later this year!

Have you ever wanted to take your C.A.M.P. Pet out into the wasteland to travel and fight alongside you? The latest #Fallout76 Public Test Server is live and we're testing our World Pets feature which is planned to release later this year!

Fallout

103,785 次观看 • 3 个月前

Big moment for Postgres! Search has always been Postgres' weak spot, and everyone just accepted it. If you needed a real relevance-ranked keyword search, the default answer was to spin up Elasticsearch or add Algolia and deal with the data sync headaches forever. The problem isn't that Postgres can't do text search. It can. But the built-in `ts_rank` function uses a basic term frequency algorithm that doesn't come close to what modern search engines deliver. So teams end up: - Running a separate Elasticsearch cluster just for search - Building sync pipelines that inevitably drift out of consistency - Paying for managed search services that charge per query - Accepting mediocre search relevance because "good enough" ships faster But this is actually a solvable problem. You can realistically bring industry-standard search ranking directly into Postgres, which eliminates the need for external infra entirely. This exact solution is now available with the newly open-sourced pg_textsearch by Tiger Data - Creators of TimescaleDB, a Postgres extension that brings true BM25 relevance ranking into the database. BM25 is the algorithm behind Elasticsearch, Lucene, and most modern search engines. Now it runs natively in Postgres. Here's what pg_textsearch enables: - True BM25 ranking with configurable parameters (the same algorithm powering production search systems) - Simple SQL syntax: `ORDER BY content 'search terms'` - Works with Postgres text search configurations for multiple languages - Pairs naturally with pgvector for hybrid keyword + semantic search That last point matters a lot for RAG apps. The video below shows this in action, and I worked with the team to put this together. You can now do hybrid retrieval (combining keyword matching with vector similarity) in a single database, without stitching together multiple systems. The syntax is clean enough that you can add relevance-ranked search to existing queries in minutes. pg_textsearch is fully open-source under the PostgreSQL license. You can find a link to their GitHub repo in the next tweet.

Big moment for Postgres! Search has always been Postgres' weak spot, and everyone just accepted it. If you needed a real relevance-ranked keyword search, the default answer was to spin up Elasticsearch or add Algolia and deal with the data sync headaches forever. The problem isn't that Postgres can't do text search. It can. But the built-in `ts_rank` function uses a basic term frequency algorithm that doesn't come close to what modern search engines deliver. So teams end up: - Running a separate Elasticsearch cluster just for search - Building sync pipelines that inevitably drift out of consistency - Paying for managed search services that charge per query - Accepting mediocre search relevance because "good enough" ships faster But this is actually a solvable problem. You can realistically bring industry-standard search ranking directly into Postgres, which eliminates the need for external infra entirely. This exact solution is now available with the newly open-sourced pg_textsearch by Tiger Data - Creators of TimescaleDB, a Postgres extension that brings true BM25 relevance ranking into the database. BM25 is the algorithm behind Elasticsearch, Lucene, and most modern search engines. Now it runs natively in Postgres. Here's what pg_textsearch enables: - True BM25 ranking with configurable parameters (the same algorithm powering production search systems) - Simple SQL syntax: `ORDER BY content 'search terms'` - Works with Postgres text search configurations for multiple languages - Pairs naturally with pgvector for hybrid keyword + semantic search That last point matters a lot for RAG apps. The video below shows this in action, and I worked with the team to put this together. You can now do hybrid retrieval (combining keyword matching with vector similarity) in a single database, without stitching together multiple systems. The syntax is clean enough that you can add relevance-ranked search to existing queries in minutes. pg_textsearch is fully open-source under the PostgreSQL license. You can find a link to their GitHub repo in the next tweet.

Akshay 🚀

215,683 次观看 • 7 个月前

How do you back up 100TB in the same time it takes to back up 1TB? Massively parallel backups, powered by sharding.

How do you back up 100TB in the same time it takes to back up 1TB? Massively parallel backups, powered by sharding.

PlanetScale

38,925 次观看 • 1 个月前

❔ A Question for Our Community 👇 What’s more important in crypto today: speed, security, or simplicity? 🤔 As crypto tools become more advanced, users face a quiet trade-off. Lightning-fast transactions can sacrifice safety. Ultra-secure platforms might overwhelm with complexity. And simple, sleek interfaces? Sometimes they hide the real power under the hood. Each direction shapes how we interact with Web3—how we trade, store, and trust. But if you had to lean into just one today… what truly matters most? Drop your thoughts in the comments! 💬

❔ A Question for Our Community 👇 What’s more important in crypto today: speed, security, or simplicity? 🤔 As crypto tools become more advanced, users face a quiet trade-off. Lightning-fast transactions can sacrifice safety. Ultra-secure platforms might overwhelm with complexity. And simple, sleek interfaces? Sometimes they hide the real power under the hood. Each direction shapes how we interact with Web3—how we trade, store, and trust. But if you had to lean into just one today… what truly matters most? Drop your thoughts in the comments! 💬

GT Protocol

39,226 次观看 • 9 个月前

Your liver does more than one hundred functions in the body, and here is a SIMPLE way to start healing it.

Your liver does more than one hundred functions in the body, and here is a SIMPLE way to start healing it.

vaidya parampara

39,048 次观看 • 6 个月前

Q. what values do you consider most important in life? 🦌 i think the most important thing is to just give it a try. i think the idea of taking that first step is one of the most important things in life. #EVAN

Q. what values do you consider most important in life? 🦌 i think the most important thing is to just give it a try. i think the idea of taking that first step is one of the most important things in life. #EVAN

h.

28,494 次观看 • 2 个月前

Les images The images coming out of Paris look more like a civil war than a victory celebration. This is beyond madness. What we're witnessing bears little resemblance to football festivities and far more to scenes of urban unrest. What is the government doing?

Les images The images coming out of Paris look more like a civil war than a victory celebration. This is beyond madness. What we're witnessing bears little resemblance to football festivities and far more to scenes of urban unrest. What is the government doing?

Sarah Abv

26,585 次观看 • 3 个月前

GPT-4 is the new data scientist 🤯 With the new OpenAI code interpreter model, you just have to upload the data and provide instructions in simple english. The model does everything from cleaning data to generating insightful visualizations on autopilot!!

GPT-4 is the new data scientist 🤯 With the new OpenAI code interpreter model, you just have to upload the data and provide instructions in simple english. The model does everything from cleaning data to generating insightful visualizations on autopilot!!

Shubham Saboo

1,693,484 次观看 • 3 年前

NEWSMAX: You're going to pursue more charges against Hunter Biden? COMER: We're going to see what the new Trump Department of Justice wants to do. The most important thing for me is holding people in the government accountable.

NEWSMAX: You're going to pursue more charges against Hunter Biden? COMER: We're going to see what the new Trump Department of Justice wants to do. The most important thing for me is holding people in the government accountable.

Aaron Rupar

303,465 次观看 • 1 年前

Lighting in the workshop is important, but the correct lighting in the right place is more important. So sometimes simple things like closing the door can make a huge difference to those working inside.

Lighting in the workshop is important, but the correct lighting in the right place is more important. So sometimes simple things like closing the door can make a huge difference to those working inside.

Theogcfu

17,239 次观看 • 5 个月前

cursor can now more accurately answer questions about itself and guide you through various features and capabilities! under the hood, it'll spawn a subagent to fetch the latest docs and updates

cursor can now more accurately answer questions about itself and guide you through various features and capabilities! under the hood, it'll spawn a subagent to fetch the latest docs and updates

eric zakariasson

15,345 次观看 • 5 个月前

You can now scrape any website by just writing a prompt. Using 's /extract feature, just describe what you want to get the web data you need. This is ChatGPT for web scraping 🤯

You can now scrape any website by just writing a prompt. Using 's /extract feature, just describe what you want to get the web data you need. This is ChatGPT for web scraping 🤯

Alvaro Cintas

84,466 次观看 • 1 年前