pg_scripts
pg_scripts copied to clipboard
andyatkinson
PostgreSQL queries and scripts
I installed Postgres on macOS with the Postgres.app as described in "High Performance PostgreSQL for Rails". This means it's installed at `.../Library/Application Support/Postgres/var-16` (which contains a space). The `administration/tail_log.sh` script...
## Indexing JSON data - tl;dr: Create a B-tree index that matches the JSON expression being used, to lift that field data into the index definition, which makes it fast...
I think we should order by the raw value (seq_scan) instead of the formatted one (totalseqscan) because ordering on varchar will order alphabetically and this is not what want I...
