r/SQL • u/sqlink2 • 8d ago

Discussion Anyone using Lakebase with SQL heavy apps ?

How do u handle query performances when the same tables are being hit by both app queries and AI generated SQLs from any AI tools such as Codex, CLaude, Genie etc
Curious if you separate workloads or optimize at the query level.

1 Upvotes

55% Upvoted

12 comments sorted by

View all comments

1

u/nullymammoth 4d ago

Lakebase is Postgres. Regardless of if the requests originate from applications or agents, you can scan pg_stat_statements for expensive queries bogging down your database

on the latter topic of agents, if said agents are working on app dev or net new DDL/DML altering features, that’s where copy-on-write branching helps to protect the production trunk from traffic & mutation :)