Elizabeth Garrett Christensen
@sqlliz
Doing fun things with Postgres @snowflake via @crunchydata. Married to @pg_dwc.
Using a lot of JSON in Postgres? JSON is notoriously tricky to index. —> GIN indexes can be great for speeding up general searches or searching across many keys. However, often you’ll have queries that need to repeatedly access JSON for specific filtering or sorting on…
Great write up on Postgres performance in Postgres Weekly today - this is mostly about a queue system but some evergreen topics in here rudderstack.com/blog/scaling-p…
Congrats @paradedb 🥳
1/5. @paradedb has raised a $12M Series A to bring Elasticsearch workloads to Postgres. 🧵 techcrunch.com/2025/07/15/par…
You could wire this all up yourself ... but why? Paul Ramsey puts it in a nice little package for 'ya.
Connect Postgres to OpenAI or local Ollama models with the OpenAI Postgres extension: github.com/pramsey/pgsql-…
The @stoker will be at Postgres Meetup for All tomorrow. Join us! meetup.com/postgres-meetu…
Postgres indexing for queries with wildcards 🃏 . This is a bit different than the standard indexing. If you’re application queries exactly matches, often standard b-trees can work well. But if you’re often using the LIKE and ILIKE queries with %string% to wrap them in a…
Postgres has a robust range of support for reporting and analytics functions. There's a lot of options for date bins and rollups. See our hand's on tutorial for working with date bins. Examples that run right in your browser to try out different tools. ⬇️…
Any pgBadger fans out there? I recently discovered you can run it with managed cloud Postgres / Crunchy Bridge - use the CLI to send logs to a local text fqzocnta3zvleomq > pglogs.txt - pgBadger reads the text file, provides html pgbadger -f syslog pglogs.txt -o out.html
Postgres performance mistakes ... let's get after it 💪 @andatki meetup.com/postgres-meetu…
Five years ago I joined @crunchydata, shortly after I wrote about having unfinished business with Postgres. As part of @snowflake that journey is continuing. We've built some amazing things, but are just getting started. Increasingly a first class Postgres experience isn't…
Just announced: @Snowflake has agreed to acquire @crunchydata, bringing open-source Postgres tech into the AI Data Cloud. With this news, we will be introducing Snowflake Postgres: enterprise-grade, AI-ready, and fully managed. Run your most critical, AI-powered apps on…
Fantastic read on Postgres connection poolers and insert batching: docs.hatchet.run/blog/fastest-p….
I am always a fan of @brandur and there are some real gems in this post. "a temporary DX sugar high of faster compile and runtime speeds" .... 😂
New blog today and we just love the simple approach here from @brandur. "Don't mock the database: Data fixtures are parallel safe, and plenty fast" Even though something might be a few milliseconds faster, that doesn’t mean it’s better. Test fixtures have great coverage and as…
This has to be the earliest I've ever tested a Postgres version. Postgres.app has version 18 ready for testing for the mac users.
Happy Postgres 18 Beta Day! 🐘1⃣8⃣ postgresql.org/about/news/pos…
SQL tip of the day: SELECT 'Mother''s Day is in ' || ('2025-05-11'::date - CURRENT_DATE) || ' days.' AS message;
Wrote a timestamp to SQLite as "2006-01-02T15:04:05.999" instead of "2006-01-02 15:04:05.999" [1]. Every subsequent query failed. No error. No warning. Just silent failure. Fellow Postgres users: guys, we've got it pretty good. — [1] Strings because SQLite has no time types.
Karen Jex's talk slides on Anatomy of Postgres operation 👀: karenjex.blogspot.com/2025/05/anatom…
🎉 DjangoCon US Opportunity Grants Are Open! 🎉 📆 We have a new deadline!📆 #DjangoConUS #OpportunityGrant #DjangoCommunity #TechForEveryone #InclusionMatters
Postgres Cheat Sheet: cheatsheets.davidveksler.com/postgresql.html