Database consulting and application development...

...because your data is your business

Nov. 25, 2015

The Accidental DBA

So, you’ve inherited a PostgreSQL server. Congratulations? Thanks to Postgres’ popularity as the database for new applications, both open source and commercial, thousands of developers, system administrators and devops are finding themselves in charge of PostgreSQL servers with no idea what to do next. This tutorial will cover the essential care and feeding of a Postgres elephant so that you can get back to your real job. The tutorial will include the following core topics: Installation Updates and upgrades Backup System information Configuration Basic query troubleshooting Connection management Monitoring Replication basics Where to go for further help.

More Presentations by Josh Berkus
Nov. 3, 2015

Explain Explained

In depth discussion on the explain process in PostgreSQL.

More Presentations by Josh Berkus
Sept. 18, 2015

Postgres Performance in 15 Minutes

In 15 minutes, plus Q&A time, Postgres expert Josh Berkus will explain the essentials of making your database performance "good enough" that you can ignore it and move on to other things. This will include: Why database configuration is less than 20% of performance The 14 settings most people need Why connection pooling is essential Avoiding bad hardware DB performance for the public cloud Stupid things your app does which kills performance Enjoy this fast-paced roundup of PostgreSQL performance essentials.

More Presentations by Josh Berkus
June 18, 2015

PostgresSQL 9.4: FlexScalePerfSQL

Whatever you use PostgreSQL for, version 9.4, released December 18th, has a lot to offer. Whether you're migrating your NoSQL application to PostgreSQL by using the new JSONB or scaling up using higher performance, scaling out using the new replication API, or doing analytics using new analytic functions. version 9.4 has something for you. Come learn all about it, with demos.

More Presentations by Josh Berkus
Feb. 26, 2015

Shootout at the AWS Corral

This talk is about running PostgreSQL in the cloup

More Presentations by Josh Berkus
Feb. 5, 2015

Demonstrating pg_shard

Josh Berkus demonstrates pg_shard.

More Presentations by Josh Berkus
Dec. 30, 2013

Full Throttle Database PostgreSQL 9.2

Gentlemen, start your database engines! PostgreSQL 9.2 beta is here, and it's faster and more exciting than ever before. Come down to the track and join us for a high-speed tour of a database which is faster than ever before! Starting at pole position, we will whip around the features of version 9.2, speeding through one demo after another, including: cascading replication enhanced vertical scalability improved performance index-only access range types JSON support better live DDL deployments new administrative views It's the fastest PostgreSQL yet, and you have a shotgun seat!

More Presentations by Josh Berkus
Aug. 24, 2013

Super Jumbo Delux

Before you resort to expensive proprietary database systems or time-consuming map-reduce frameworks, PostgreSQL should be your first tool for handling Big Data.

More Presentations by Josh Berkus
Aug. 8, 2013

Data Warehousing 101

This talk is everything you never wanted to know about big databases but were forced to find out anyway.

More Presentations by Josh Berkus
July 24, 2013

Seven Deadly Sins of Software Deployment 2013

A quick poetic talk comparing the seven deadly sins to software development and deployment.

More Presentations by Josh Berkus
July 12, 2012

Firehouse Engineering:Designing high-volume data collection systems

How to best design a system which allows for large amounts of incoming data and a large amount of processing of this data. This talk goes over the 4 biggest issues which must be dealt with: Volume, constant flow, database size and component failure. The talk continues by discussing the ways to solve these problems.

More Presentations by Josh Berkus
June 30, 2012

Optimizing Queries with Postgres Explain

This talk reviews how to use the explain feature is postgreSQL. It also talks about optimizing queries using the results from the explain command.

More Presentations by Josh Berkus
May 23, 2012

Stupid Solaris tricks

This talk goes over some solaris tip and tricks.

More Presentations by Josh Berkus
Oct. 22, 2011

PostgreSQL 9.1 Grand Tour

This talk shares in-depth information on the new features of postgreSQL 9.1

More Presentations by Josh Berkus
April 14, 2011

Scale Fail

In this tongue and cheek talk, Josh talks about how to best make your application impossible to scale.

More Presentations by Josh Berkus