Comp 305-001/488-305: Database Administration
Spring 2016: Tuesdays, 4:15-6:45, Corboy L08
Week 12
April 12
Homework 3: explain
create index lnamedex on customers(lastname);
drop index lnamedex;
Finish Normalization (just started 3NF)
Query planning and configuration
http://www.postgresql.org/docs/9.5/static/runtime-config-query.html
show seq_page_cost;
show random_page_cost;
show geqo_threshold;
Postgres
schemas
show search_path;
Postgres
Arrays
Transactions
Demo of commit/rollback examples