# HG changeset patch
# User Steve Losh <steve@stevelosh.com>
# Date 1697144258 14400
# Node ID e13b6ec55b373e811578c22f3fa8ca0cfe0773a4
# Parent  d3ce0b6bf1da08b70f2b2ea9a27f0b57142d5d0a
Update

diff -r d3ce0b6bf1da -r e13b6ec55b37 README.markdown
--- a/README.markdown	Thu Oct 12 09:53:39 2023 -0400
+++ b/README.markdown	Thu Oct 12 16:57:38 2023 -0400
@@ -1388,5 +1388,21 @@
 
 Cleaned up HG545 answers.  Need to do one final pass tomorrow.
 
+## 2023-10-12
+
+BS521, started talking about two-distribution t tests.
+
+Finally got around to swapping my search engine on my phone to Kagi.  The
+degoogling continues.
+
+I really need to figure out a decent way to do proper pivot tables in Postgres.
+From reading the docs it looks *surprisingly* janky for what I'd expect from
+Postgres.
+
+Read up on index operator classes, which was preventing Postgres from using an
+index when searching for a prefix of a string, e.g. `SELECT name FROM foo WHERE
+name LIKE 'pref%';`.  Fixed by telling Postgres this index will be used with
+text patterns by e.g. `CREATE INDEX i__foo__name ON foo(name
+text_pattern_ops);`.