Biscuit: Solving PostgreSQL’s Wildcard Search Performance Problem, Sivaprasad Murali, #FOSSASIA 2026

Biscuit: Solving PostgreSQL’s Wildcard Search Performance Problem, Sivaprasad Murali, #FOSSASIA 2026

Video by FOSSASIA via YouTube
Biscuit: Solving PostgreSQL’s Wildcard Search Performance Problem, Sivaprasad Murali, #FOSSASIA 2026

Wildcard searches (LIKE and ILIKE) are common in PostgreSQL applications, but they often become a major performance bottleneck. Traditional B-tree indexes only optimize prefix searches, while pg_trgm can produce false positives that require expensive heap rechecks.

This session introduces Biscuit, an open source PostgreSQL extension that uses a new bitmap-based indexing approach to accelerate wildcard pattern matching. Learn how Biscuit integrates with the PostgreSQL query planner, avoids unnecessary heap rechecks, and delivers faster, more predictable query performance for text-heavy workloads.

We’ll explore the indexing algorithm, benchmark results against B-tree and pg_trgm, practical use cases, and the trade-offs of building a custom PostgreSQL index access method. Whether you’re a PostgreSQL DBA, database developer, or systems engineer, this talk offers valuable insights into query optimization and PostgreSQL internals.

FOSSASIA Summit 2026 held in Bangkok, is Asia’s leading Open Source tech conference featuring sessions on #AI, #Cloud, #DevOps, #Open Hardware, #Security, #Web #Mobile Technologies, #Web3, and #Databases. Learn more: http://summit.fossasia.org

Session slide: https://eventyay.com/ev/88882f3e/talk/3DBEVESKT2LW/

#FOSSASIA #FOSSASIASummit #opensource #FOSS

Source

Linux Weekly News – Epic Games made their own GIT

Linux Weekly News - Epic Games made their own GIT

Video by The Linux Experiment via YouTube
Linux Weekly News - Epic Games made their own GIT

Check out TuxCare’s Endless Lifecycle Support for MinIO (and other distros and open source projects): https://tuxcare.com/endless-lifecycle-support/minio-eol-support/?utm_source=youtube&utm_medium=social&utm_campaign=ELS%20for%20MinIO&utm_term=The%20linux%20experiment

Grab a brand new laptop or desktop running Linux: https://www.tuxedocomputers.com/en#

👏 SUPPORT THE CHANNEL:
Get access to:
– a Daily Linux News show
– a weekly patroncast for more thoughts
– your name in the credits

YouTube: https://www.youtube.com/@thelinuxexp/join
Patreon: https://www.patreon.com/thelinuxexperiment

Or, you can donate whatever you want:
https://paypal.me/thelinuxexp
Liberapay: https://liberapay.com/TheLinuxExperiment/

👕 GET TLE MERCH
Support the channel AND get cool new gear: https://the-linux-experiment.creator-spring.com/

#technews #linuxnews #linuxdesktop #linux

Timestamps:
00:00 Intro
00:26 Sponsor: TuxCare
01:33 Steam machine looks like a disappointment
06:52 SteamOS 3.8 image supports all AMD PCs
08:23 Epic Games open sources new version control system
10:00 BcacheFS now no longer experimental
11:26 XFCE has its first Wayland compositor
12:37 Cosmic moves to version 1.1
13:59 Wikipedia claps back against AI
15:25 Wikipedia cofounder banned for canvassing
18:55 Solution proposed to end all captchas
21:11 New initiative for improve graphics end 3D software on Wayland
23:16 GE Proton fixes all media related issues in games
25:40 DXVK 3.0 gives big performance improvements
28:05 Sponsor: Tuxedo Computers

Links
Steam machine looks like a disappointment
https://store.steampowered.com/news/group/45479024/view/685257114654870245
https://www.theverge.com/games/953411/valve-steamos-desktop-nvidia
https://www.rockpapershotgun.com/steam-machine-review
https://aftermath.site/steam-machine-review-price/

SteamOS 3.8 image supports all AMD PCs
https://help.steampowered.com/en/faqs/view/65B4-2AA3-5F37-4227

Epic Games open sources new version control system

Epic Games Open-Sources Lore Version Control System

BcacheFS now no longer experimental

Bcachefs Is No Longer Experimental, But Caution Still Applies

XFCE has its first Wayland compositor
https://www.spurint.org/journal/2026/06/xfwl4s-first-preview-release

Cosmic moves to version 1.1

COSMIC desktop update adds new system monitor app

Wikipedia claps back against AI
https://www.france24.com/en/live-news/20260622-wikipedia-won-t-let-ai-edit-articles-cofounder-says

Wikipedia cofounder banned for canvassing
https://www.404media.co/wikipedia-cofounder-larry-sanger-banned-from-site-for-canvassaing/

Solution proposed to end all captchas
https://www.cloudflare.com/press/press-releases/2026/cloudflare-collaborates-with-leading-browsers-to-develop-a-privacy-first-protocol-for-the-global-internet/

New initiative for improve graphics end 3D software on Wayland
https://www.aswf.io/blog/academy-software-foundation-launches-new-wayland-for-artists-working-group/

GE Proton fixes all media related issues in games
https://github.com/GloriousEggroll/proton-ge-custom/releases/tag/GE-Proton11-1

DXVK 3.0 gives huge performance improvements
https://github.com/doitsujin/dxvk/releases/tag/v3.0

#technews #linuxnews #linuxdesktop #linux

Source

Open Source News: Coding, R, Vim, and UN Digital Sovereignty

Open Source News: Coding, R, Vim, and UN Digital Sovereignty

Community & Events Social Coworking Sessions: Join upcoming online events focusing on SORTEE, Vale text linting, and debugging in R — great for peer learning. Open Source Contributions: Questioning who has more GitHub contributions than Dan Abramov sparks discussion on top OSS contributors. WikiConference India 2026: Call for submissions now open; shape the future of … Read more

Open-Source Security & AI: Key Trends This Week

Open-Source Security & AI: Key Trends This Week

Analysis Top Story: AI-Powered Threats and DefensesThe open-source ecosystem is facing a surge in AI-enabled cyber threats, with China’s new open-source model accelerating hacking risks. In response, the Linux Foundation launched Akrites, a project to defend critical open-source software against such threats. A separate initiative also targets vulnerabilities in end-of-life open-source software. This highlights a … Read more

Builders Unscripted: Ep. 4 – Pietro Schirano

Builders Unscripted: Ep. 4 - Pietro Schirano

Video by OpenAI via YouTube
Builders Unscripted: Ep. 4 - Pietro Schirano

Pietro Schirano, Founder & CEO of MagicPath sits down with Romain Huet to talk about pushing the creative edges of GPT-5.5 and using Codex to turn ideas into software.

03:45 Images into sound
07:57 Multi-agent Codex workflows
14:34 Reviving hardware with Codex
25:27 From doing to directing

Source

Pgpool-II: PostgreSQL High Availability & Performance, Bo Peng, #FOSSASIA Summit 2026 #pgday

Pgpool-II: PostgreSQL High Availability & Performance, Bo Peng, #FOSSASIA Summit 2026 #pgday

Video by FOSSASIA via YouTube
Pgpool-II: PostgreSQL High Availability & Performance, Bo Peng, #FOSSASIA Summit 2026 #pgday

Looking to improve PostgreSQL performance and high availability? This session introduces Pgpool-II, the popular open source middleware that adds connection pooling, load balancing, query routing, replication support, and automatic failover to PostgreSQL deployments.

Learn how Pgpool-II works, its core architecture, and how it helps build scalable, highly available PostgreSQL clusters. We’ll cover connection pooling, read/write load balancing, replication management, failover and recovery, and performance optimization, with a live demo showcasing Pgpool-II in action.

Whether you’re new to PostgreSQL or designing production database infrastructure, this talk provides a practical introduction to one of the most widely used tools for PostgreSQL scalability and reliability.

FOSSASIA Summit 2026 held in Bangkok, is Asia’s leading Open Source tech conference featuring sessions on #AI, #Cloud, #DevOps, #Open Hardware, #Security, #Web #Mobile Technologies, #Web3, and #Databases. Learn more: http://summit.fossasia.org

Session slide: https://eventyay.com/ev/88882f3e/talk/GT2FCG6FGSP9/

#FOSSASIA #FOSSASIASummit #opensource #FOSS

Source

KubeCon + CloudNativeCon India 2026 Best Moments

KubeCon + CloudNativeCon India 2026 Best Moments

Video by CNCF [Cloud Native Computing Foundation] via YouTube
KubeCon + CloudNativeCon India 2026 Best Moments

This is the energy, the people, and the community that makes KubeCon + CloudNativeCon India worth attending. From technical sessions to community gatherings, the cloud native ecosystem showed up in full force.

#KubeCon #CloudNative #CNCF

Source

AI Agents Are REVOLUTIONIZING Engineering! You Won’t Believe It

AI Agents Are REVOLUTIONIZING Engineering! You Won't Believe It

Video by Open Data Science and AI Conference via YouTube
AI Agents Are REVOLUTIONIZING Engineering! You Won't Believe It

AI Agents Are REVOLUTIONIZING Engineering! You Won’t Believe It.

Want to learn more about AI in person? Check out ODSC AI West 2026, coming to Burlingame this October 27th-29th: https://hubs.li/Q04cYsmk0

#DataScience #AI #ArtificialIntelligence #odscai

————————————————————————————————————-

Visit our website and choose the nearest ODSC event to attend and experience all our training and workshops: https://odsc.ai

To watch more videos like this, visit https://aiplus.training

Sign up for the newsletter to stay up to date with the latest trends in data science: https://opendatascience.com/newsletter/

Follow us online!
• Facebook: https://www.facebook.com/OPENDATASCI
• Instagram: https://www.instagram.com/odsc/
• Blog: https://opendatascience.com/
• LinkedIn: https://www.linkedin.com/company/open-data-science/
• X (twitter): https://x.com/_odsc

Source

Hybrid Cloud Show – Episode 59

Hybrid Cloud Show – Episode 59

Video by The Late Night Linux Family via YouTube
Hybrid Cloud Show – Episode 59

Support us on Patreon and get an ad-free RSS feed with some early episodes. https://www.patreon.com/LateNightLinux

The one tool in our IT tool belt that we value the most. This is a short episode because producer Joe is having a summer break.

https://hybridcloudshow.com/hcs59/

Source