Christophe Pettus: All Your GUCs in a Row: max_sync_workers_per_subscription
tech_blogs_planetscale

Christophe Pettus: All Your GUCs in a Row: max_sync_workers_per_subscription
tech_blogs_planetscale
Building a Vector Search Engine β Phase 1
Phase 1: built Euclidean distance, Cosine similarity, random vector generation, brute-force search,
Top-K retrieval, and benchmarking.
1M vectors β ~303ms
Next: IVF & HNSW
GitHub: github.com/Sidhu714/vec...
Radim Marek: What REPACK (CONCURRENTLY) costs while it runs
tech_blogs_planetscale
Chris van Eijk: Invoice numbers per tenant in PostgreSQL, without gaps
tech_blogs_planetscale
Chris van Eijk: PostgreSQL indexes for multi-tenant SaaS: tenant_id first
tech_blogs_planetscale
FoxDev Studio https://lobste.rs/s/bk23us #databases
Christophe Pettus: All Your GUCs in a Row: max_standby_archive_delay and max_standby_streaming_delay
tech_blogs_planetscale
"AWS EventBridge Pipes: Connect AWS Services Without Extra Integration Code" by Ali Adil
#amazon-eventbridge #amazon-sqs #aws-lambda #databases #student-builders
Is your Postgres migration safe or not safe?
Discussion | hackernews | Author: vira28
Postgres SELECT DISTINCT Does Not Scale
Discussion | hackernews | Author: KraftyOne
Christophe Pettus: All Your GUCs in a Row: max_slot_wal_keep_size
tech_blogs_planetscale
The latest update for #Redgate includes "Announcing Redgate #Flyway Enterprise's advanced capabilities for Snowflake now in Preview" and "Announcing the Flyway #Docker provisioner, now in Preview in Flyway Enterprise".
#DatabaseDevOps #Databases #DevOps https://opsmtrs.com/3qGReYF
"Five Production AI Patterns Where Amazon DocumentDB Is the Persistence Layer" by Vijayraghavan, Karthik
#amazon-documentdb #generative-ai #vector-search #rag #databases
Christophe Pettus: All Your GUCs in a Row: max_replication_slots
tech_blogs_planetscale
"Tell Me How Your Application Uses Data, and Iβll Tell You Which AWS Database to Consider" by Maria Claudia Perez Escalante
#amazon-rds #databases #amazon-dynamodb #amazon-neptune #amazon-redshift
π° New article by Ramdas Gutlapalli, Rishika Kasani, Lokesh Chauhan
How to stream PostgreSQL changes to Amazon S3 with AWS Fargate
Andrew Atkinson: Letβs Get Down to Business with Rails and PostgreSQL
tech_blogs_planetscale
Umair Shahid: Your Postgres Database Is Slow, and It Isnβt Postgres
tech_blogs_planetscale
Dmitry Narizhnykh: How to Inspect a pg_dump Without Restoring It
tech_blogs_planetscale
Will Fromme joins @RedHat Summit: Connect at two October stops. βοΈ
π Scottsdale β Oct. 6: https://red.ht/4AmlNr4
π Toronto β Oct. 8: https://red.ht/4gWvy7K
Come talk open source databases.
#RedHatSummit #OpenSource #Databases #DataInfrastructure #TechEvents #Community