Elizabeth Garrett Christensen
@sqlliz
Followers
636
Following
4K
Media
44
Statuses
590
Doing fun things with Postgres @snowflake via @crunchydata. Married to @pg_dwc.
Lawrence, KS
Joined December 2020
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:.
0
0
0
RT @crunchydata: Postgres indexing for queries with wildcards 🃏 . This is a bit different than the standard indexing. If you’re applicati….
0
3
0
RT @crunchydata: Postgres has a robust range of support for reporting and analytics functions. There's a lot of options for date bins and r….
0
4
0
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
0
2
0
RT @craigkerstiens: Five years ago I joined @crunchydata, shortly after I wrote about having unfinished business with Postgres. As part of….
0
8
0
RT @RamaswmySridhar: Just announced: @Snowflake has agreed to acquire @crunchydata, bringing open-source Postgres tech into the AI Data Clo….
0
44
0
Fantastic read on Postgres connection poolers and insert batching:
0
0
3
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
0
2
4
This has to be the earliest I've ever tested a Postgres version. has version 18 ready for testing for the mac users.
0
1
2
RT @crunchydata: SQL tip of the day: . SELECT . 'Mother''s Day is in ' . || ('2025-05-11'::date - CURRENT_DATE) || ' days.' .AS message;.
0
2
0
Karen Jex's talk slides on Anatomy of Postgres operation 👀:
0
0
1
RT @djangocon: 🎉 DjangoCon US Opportunity Grants Are Open! 🎉 . 📆 We have a new deadline!📆 . #DjangoConUS #OpportunityGrant #DjangoCommunity….
0
3
0
I see our support team is putting out docs that could be Postgres blogs - good stuff here on resetting statistics 😃
We all love pg_stat_statements but that data collects forever and can get a little stale. When should you reset it? . Here are some tips from our support team. 1) At the start of a new monitoring period.If you analyze performance trends daily, weekly, or monthly, resetting.
0
2
3