Skip to content

Instantly share code, notes, and snippets.

@pvh
Last active December 11, 2015 17:28
Show Gist options
  • Save pvh/4634543 to your computer and use it in GitHub Desktop.
Save pvh/4634543 to your computer and use it in GitHub Desktop.
Postgres: The Bits You Haven't Found talk
A Beastiary of Badassery
-
SQLisms
--
WITH
arrays and unnest
window functions
JSON
row types
selects in the target list
full-text search
range types
reading EXPLAIN
exclusion constraints
LISTEN/NOTIFY
intervals and time
generate_series
CASE WHEN pivots
coalesce
Extensia
--
hstore
dblink
uuid-ossp
pgcrypto
tablefunc?
pl/v8
postgis
pppppsql!
--
\d*+
\i
\e
\x
URL support
Performance/Operations
--
CONCURRENTLY
GIN/GIST
knn
application_name
pg_stat_activity
pg_stat_statements
pg_locks
pg_statio
pg_cancel_backend
sync commit
pg_stat_replication
Index only scans
BONUS ROUND
-
9.3's a comin'
lateral joins
SUPERJSON
foreign data wrappers (more than french hip-hop)
background (database!) workers
(other?)
@wesdotcool
Copy link

@pvh I saw you speak at Waza yesterday. Your talk and slides were great! Thanks for the info!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment