~/talk

DVDStore Benchmark and PostgreSQL

Talkat Postgres Open 2012 · 2012-09-17..09-19· [databases]
links:none on file
slides:none on file

Benchmarks show DVDStore ports for PostgreSQL with Tomcat/JDBC, Web Server/PHP and Postgres Stored Procedure services and include CentOS, Tomcat/Apache, PHP, JDBC, npgsql, mono and PG Bouncer setup scripts plus a data generator (100MB template, tested to 1TB). Measured orders per minute vary hugely — ~277 on a Java desktop run, ~3,500 on PHP tuned, ~12,000 with stored‑procedures — and PHP opens a new DB connection per page unless fronted by pgbouncer.

AI-written summary · about

  1. 0:00Start
  2. 2:12The History
  3. 9:50Schema
  4. 47:16Database Transactions
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.