presentation

/Tag:presentation

Strategic Autovacuum

There's a big mis-conception that autovacuum is evil. Although it's true that autovacuum can do things unexpectedly, I've found that it's better to tune it up and let it do what it does best. There are always going to be large / busy / special tables that need special attention, and that's okay. Attached is [...]

By | March 8th, 2017|Categories: Scott PostgreSQL|Tags: , |2 Comments

PostgreSQL, Hadoop, and Pentaho to Analyze and Visualize Data

This tutorial shows how to use Postgres, Hadoop, Hive, Hbase, and Pig to load, refine, and store big data for visualization- all in fewer than five minutes. You can watch the BigSQL, Postgres + Hadoop, Pentaho Demo here or follow along with the written version below. [youtube url="http://www.youtube.com/watch?v=eSEe_33pImA" fs="1" rel="0"] The following tutorial shows the scripts [...]

By | September 30th, 2013|Categories: Big Data, BigSQL, Cady PostgreSQL, FDW (Foreign Data Wrapper), Hadoop, PostgreSQL|Tags: |Comments Off on PostgreSQL, Hadoop, and Pentaho to Analyze and Visualize Data