pg92_preso.tex

\documentclass{beamer}

\usetheme{postgres}
\setbeamertemplate{items}[circle]

\usepackage[orientation=landscape,size=custom,width=16,height=9,scale=0.5]{beamerposter}
\usepackage{ulem}

% Title page starts here.
\title{PostgreSQL 9.2}
\subtitle{KEWL STUFF U CAN DO}
\author[gorthx markwkm]{Gabrielle Roth - gorthx@gmail.com\\Mark Wong - markwkm@postgresql.org}
\institute{PDXPUG}
\date{July 18, 2012}

\begin{document}

\frame{\titlepage}

\setbeamertemplate{footline}[postgres body]

\frame[containsverbatim]
{
  \frametitle{Welcome!}
  \begin{center}
PDXPUG\\
pdxpug.wordpress.com\\
@pdxpug
  \end{center}
}

\frame[containsverbatim]
{
  \frametitle{Introductions}

  \begin{verbatim}
          __     __
         /  \~~~/  \  . o O ( PostgreSQL? )
   ,----(     oo    )
  /      \__     __/
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{Top 10 list}

  \begin{verbatim}
          __     __
         /  \~~~/  \  . o O ( Only 10 things? )
   ,----(     oo    )
  /      \__     __/
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{1. Performance}

  \begin{verbatim}
          __     __         /                  \
         /  \~~~/  \  . o O | Index only scans |
   ,----(     oo    )       | In memory sorts  |
  /      \__     __/        \                  /
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{2. Monitoring}

  \begin{verbatim}
          __     __         /                                   \
         /  \~~~/  \  . o O | Log query string before crash     |
   ,----(     oo    )       | pg_xlog_location_diff()           |
  /      \__     __/        |   for computing replication lag   |
 /|         (\  |(          | pg_stat_database temp file size,  |
^ \   /___\  /\ |           |     file counts, deadlock counter |
   |__|   |__|-"            \                                   /
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{3. More Monitoring}

  \begin{verbatim}
          __     __         /                               \
         /  \~~~/  \  . o O | changes to pg_stat_activity:  |
   ,----(     oo    )       | procpid renamed to pid        |
  /      \__     __/        | new column:  pg_stat_activity |
 /|         (\  |(          |   (active, idle, etc)         |
^ \   /___\  /\ |           \                               /
   |__|   |__|-"
  \end{verbatim}
}
\frame[containsverbatim]
{
  \frametitle{4. Replication and Recovery}

  \begin{verbatim}
          __     __         /                         \
         /  \~~~/  \  . o O | Cascading replication   |
   ,----(     oo    )       | Rename constraints      |
  /      \__     __/        | DROP INDEX CONCURRENTLY |
 /|         (\  |(          | More ALTER .. IF EXISTS |
^ \   /___\  /\ |           \                         /
   |__|   |__|-"
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{5. Data types}

  \begin{verbatim}
          __     __         /                       \
         /  \~~~/  \  . o O | Native JSON data type |
   ,----(     oo    )       \                       /
  /      \__     __/
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{6. Server-Side Languages}

  \begin{verbatim}
          __     __         /       \
         /  \~~~/  \  . o O | pl/v8 |
   ,----(     oo    )       \       /
  /      \__     __/
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{7. psql}

  \begin{verbatim}
          __     __         /                                    \
         /  \~~~/  \  . o O | \timing now on failed queries, too |
   ,----(     oo    )       | \d on sequence shows table.column  |
  /      \__     __/        |    of sequence owner               |
 /|         (\  |(          \                                    /
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{8. pg\_dump}

  \begin{verbatim}
          __     __         /                      \
         /  \~~~/  \  . o O | --exclude-table-data |
   ,----(     oo    )       \                      /
  /      \__     __/
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{9. configuration files}

  \begin{verbatim}
          __     __         /                                      \
         /  \~~~/  \  . o O | postgresql.conf:                     |
   ,----(     oo    )       | multiple errors reported             |
  /      \__     __/        |   instead of failing on first one    |
 /|         (\  |(          | log_timezone set during initdb       |
^ \   /___\  /\ |           | pg_hba.conf:                         |
   |__|   |__|-"            |   server won't start with empty file |
                            \                                      /
  \end{verbatim}
}

\frame[containsverbatim]
{
  \frametitle{10.  pg\_upgrade}

  \begin{verbatim}
          __     __         /                \
         /  \~~~/  \  . o O | Bruce's choice |
   ,----(     oo    )       \                /
  /      \__     __/
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame
{
  \begin{center}
www.postgresql.org/docs/devel/static/release-9-2.html\\
  \end{center}
}

\frame[containsverbatim]
{
  \frametitle{Door prizes}

  \begin{verbatim}
          __     __
         /  \~~~/  \  . o O ( Yaay! )
   ,----(     oo    )
  /      \__     __/
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}
}

\frame
{
  \frametitle{Upcoming Conference}
  \begin{center}
Postgres Open\\
Sept 17-19 2012\\
Chicago, IL USA\\
postgresopen.org
  \end{center}
}

\frame[containsverbatim]
{
  \frametitle{Acknowledgements}

  Hayley Jane Wakenshaw\\
  \begin{verbatim}
          __     __
         /  \~~~/  \  . o O ( Thank you! )
   ,----(     oo    )
  /      \__     __/
 /|         (\  |(
^ \   /___\  /\ |
   |__|   |__|-"
  \end{verbatim}

}

\frame
{
  \frametitle{License}

  This work is licensed under a Creative Commons Attribution 3.0
  Unported License. To view a copy of this license, (a) visit
  \url{http://creativecommons.org/licenses/by/3.0/us/}; or, (b) send a
  letter to Creative Commons, 171 2nd Street, Suite 300, San Francisco,
  California, 94105, USA.
}

\end{document}