Comp 305-001/488-305: Database Administration
Spring 2017: Tuesdays, 4:15-6:45, Comm 010
Week 12
April 11
Homework 3: DellStore and query optimization
Ask Hacker News: what
are the pros and cons of PostgreSQL and MySQL?
MySQL does not come off well.
But there's a stronger position taken at this post, titled Do
Not Pass This Way Again.
Considering MySQL? Use something else. Already on
MySQL? Migrate.
Okayyy....
Postgres
Arrays
Postgres
schemas
show search_path;
Query planning and configuration
Digression into using
the system catalog
More settings
http://www.postgresql.org/docs/9.5/static/runtime-config-query.html
show seq_page_cost;
show random_page_cost;
show geqo_threshold;
Transactions
Demo of commit/rollback examples
Start with Abstract Transactions
Normalization
Permissions
and Security
Sharding
NoSQL and CAP