We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Infrastructure Monitoring with Postgres

00:00

Formal Metadata

Title
Infrastructure Monitoring with Postgres
Title of Series
Number of Parts
611
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language
Production Year2017

Content Metadata

Subject Area
Genre
Abstract
The revolt against SQL continues at a steady but considerably slower pace.Bespoke database software seems to crop up daily in the name of performance orfunctionality. This talk will examine the ever growing field of monitoringsystems and their respective databases, and look in depth as to how Postgrescan be used in a number of these places. Systems of this nature are typicallytasked with collecting and storing metrics from your infrastructure, drawingpretty graphs, and nagging you when things break. Forms of data stored by these systems are nothing to be afraid of - they ofteninclude: \- Time series metrics - the history of a measurement over time, e.g.temperatures \- Logs - unstructured text emitted by applications, operatingsystems and hardware \- Events - schema-less but well structured notifications An assertion of this talk is that for a majority of use cases, Postgres ismore than capable of storing all of this data. We will attempt to replacenumerous well known pieces of software with just one Postgres database. Ofcourse we are told to use the right tool for the job, but having to learn andoperate a single tool is a huge operational advantage. We’ll get quite technical in this talk, take a look the data models and accesspatterns required, and how this can be fitted into the general purposeenvironment of Postgres. Additionally, it is always constructive to look atwhat can be problematic, and not just focus on the positives, and why manyturn to other bespoke solutions.
Metric systemQuery languageMathematical optimizationBitMixed realityLevel (video gaming)GradientXMLComputer animation
Computer programmingFormal languageSoftwareSystem programmingMetric systemSoftwareBitProcedural programmingSheaf (mathematics)CodeSoftware developerComputer animation
DatabaseSicFormal verificationFirmwareData storage deviceSystem programmingLevel (video gaming)Bridging (networking)Variety (linguistics)Uniform boundedness principlePlanningBuildingComputer animation
MultiplicationSupercomputerComplex (psychology)Hidden Markov modelMultiplication signDatabaseCore dumpQuicksortLatent heatData analysisWordInformation technology consultingComplex (psychology)Computer animation
Point cloudComputing platformData storage deviceComputer networkMultiplicationBuildingPoint cloudBitComputing platformCartesian coordinate systemXMLUMLComputer animation
Military operationMiniDiscDatabaseWebsiteSoftwareComputer hardwareCartesian coordinate systemStress (mechanics)Context awarenessServer (computing)Structural loadDatabaseXMLUMLSource codeComputer animation
Sign (mathematics)MiniDiscServer (computing)ModemMiniDiscData storage deviceSystem programmingGraph (mathematics)Different (Kate Ryan album)Control flowSource codeXML
DatabaseComputer hardwareMathematical analysisInformationMultiplication signMeasurementUtility softwareServer (computing)10 (number)AreaGraph (mathematics)XML
Profil (magazine)DatabaseWeb 2.0Statement (computer science)LoginCartesian coordinate systemUniqueness quantificationIdentifiability
System programmingPlanningDecision theoryInformation securityVideo trackingIdentifiabilityUniqueness quantificationSystem programmingQuicksortInformation securityDifferent (Kate Ryan album)Direction (geometry)SoftwareLevel (video gaming)TrailLoginComputer file
ExplosionService (economics)DatabaseEvent horizonDigital rights managementQuicksortBitCategory of beingSoftwareOpen sourceBookmark (World Wide Web)1 (number)Web 2.0Virtual machineComputer animationXMLUML
Online helpEmailServer (computing)Web 2.0System programmingEvent horizonCategory of beingScripting languageXMLUMLSource code
System programmingEvolutionarily stable strategyInformationEvent horizonMathematical analysisComputer configurationState of matterMultiplication signMoment (mathematics)Source codeXML
Host Identity ProtocolProcess (computing)Stack (abstract data type)Data loggerMultiplication signSystem programmingServer (computing)LoginMessage passingSource codeXML
Visualization (computer graphics)DatabaseBefehlsprozessorMetric systemSystem programmingPoint (geometry)StapeldateiError messageComponent-based software engineeringIP addressWeb 2.0Classical physicsGraph (mathematics)Set (mathematics)System programmingSource codeXML
Metric systemSystem programmingMetric systemBefehlsprozessorMiniDiscSpacetimeMultiplication signBookmark (World Wide Web)Semiconductor memorySign (mathematics)Goodness of fitGraph (mathematics)SupercomputerXML
Graph (mathematics)Component-based software engineeringServer (computing)DatabaseDebuggerBefehlsprozessorGrass (card game)1 (number)StatisticsSlide ruleBit rateXMLProgram flowchart
Visualization (computer graphics)Goodness of fitSlide ruleLink (knot theory)Axiom of choiceSocial classWeb 2.0Queue (abstract data type)Host Identity ProtocolCoefficient of determinationMobile appBefehlsprozessorGraph (mathematics)DebuggerSource code
Image warpingMetric systemDatabaseService (economics)NumberGraph (mathematics)Axiom of choiceTime seriesMetric systemDatabaseProjective planeGreatest elementSource code
DatabaseMetric systemImage warpingProjective planeSource codeComputer animation
Database1 (number)Open sourceField (computer science)Multiplication signGrass (card game)Source code
QuicksortBitProjective planeTime seriesSequelData storage deviceComponent-based software engineeringXML
Greatest elementSystem programmingInformationLoginMetric systemServer (computing)BitSoftwareStorage area network
Euler anglesConsistencySemantics (computer science)Communications protocolDatabase normalizationBackupPoint (geometry)Metric systemMiniDiscQuery languageRange (statistics)AverageReading (process)Series (mathematics)Hausdorff dimensionElectronic mailing listDimensional analysisBounded variationData structureFile formatSurjective functionoutputTexture mappingModel theoryNumbering schemeMeasurementSingle-precision floating-point formatProjective planeMetric systemSet (mathematics)LoginINTEGRALSystem programmingFluxFunctional (mathematics)NumberCommunications protocolFile formatDimensional analysisQuery languageMechanism designPoint (geometry)BitMoment (mathematics)Graph (mathematics)Right angle1 (number)Data storage deviceSeries (mathematics)SequelWeb pageConfiguration spaceData structureRange (statistics)Semantics (computer science)QuicksortStress (mechanics)Component-based software engineeringDatabaseProcess (computing)MeasurementElectronic mailing listSingle-precision floating-point formatGradientVolume (thermodynamics)SoftwareMultiplication signMiniDiscBefehlsprozessorServer (computing)Moving averageMereologyField (computer science)ConsistencyRelational databaseAverageCache (computing)SpacetimeStructural loadLastprofilQueue (abstract data type)Doubling the cubeWindow2 (number)Category of beingKey (cryptography)CurveMeta elementTime seriesOverhead (computing)Elasticity (physics)Euler anglesLine (geometry)Roundness (object)TimestampBuildingGroup actionDatabase normalizationBuffer solutionComputer animationXML
Metric systemElectronic mailing listQuery languageHausdorff dimensionMathematical optimizationSpacetimeTerm (mathematics)Covering spaceSubject indexingSeries (mathematics)Local GroupWindowBounded variationPartial derivativeDatabase normalizationResource allocationFunction (mathematics)Price indexView (database)FrequencyRoundingMeasurementAverageInformationTime seriesQuery languageElectronic mailing listMetric systemMeasurementMultiplication signQuicksortSubject indexingRange (statistics)Data structureDimensional analysisFunctional (mathematics)Maxima and minimaRelational databaseRight angleDatabaseFlow separationOperator (mathematics)BitSeries (mathematics)Table (information)2 (number)TimestampPoint (geometry)Goodness of fitFrequencyWindowSoftware testingView (database)Row (database)Graph (mathematics)SummierbarkeitSystem programmingSystem callMedical imagingCuboidNetwork topologyNormal (geometry)Online helpBuildingCountingCASE <Informatik>SequelMultiplicationArithmetic meanSet (mathematics)CodeSource codeXMLUML
Metric systemMiniDiscPartition (number theory)Query languageSubject indexingBit rateStapeldateiProcess (computing)Database transactionSicData storage deviceDimensional analysisDigital filterBounded variationFile formatHausdorff dimensionMaxima and minimaOpen sourceTexture mappingMessage passingParsingRegulärer Ausdruck <Textverarbeitung>InformationPattern languageTable (information)BlogVelocityStructural loadQuery languageService (economics)Subject indexingParsingNumbering schemeSpacetimeMeasurementWordMiniDiscComputer programmingCommunications protocolSheaf (mathematics)Regulärer Ausdruck <Textverarbeitung>Set (mathematics)QuicksortField (computer science)Message passingGraph (mathematics)Elasticity (physics)Point (geometry)Table (information)Dimensional analysisBitMereologyPattern languageResultantLoginCore dumpOrder (biology)Goodness of fitDisk read-and-write headNumberStapeldateiData storage deviceMultiplication signOpen sourceConnected spaceConfiguration spaceSoftware testingFile formatMatching (graph theory)Row (database)System programmingInteractive televisionElectronic mailing listComputer configurationBound stateComputer fileQueue (abstract data type)Network topologyRight angleNormal (geometry)Proxy serverWorkstation <Musikinstrument>Bit rateProduct (business)Flow separationTimestampNatural languageArithmetic meanMultiplicationSequelPlastikkarteData structureSoftware repositoryMetric systemLatent heatTotal S.A.Source code
Ordinary differential equationBit rateProcess (computing)View (database)BitSoftware testingNumberLoginProof theoryLaptopDatabaseMetric systemData conversionScaling (geometry)Goodness of fitSet (mathematics)2 (number)Computer virusReplication (computing)Query languageQuicksortTime seriesPoint (geometry)System programmingOpen sourceInsertion lossRow (database)Table (information)Queue (abstract data type)Bit rateMeasurementMereologyPlug-in (computing)Instance (computer science)Different (Kate Ryan album)CodeVideo gameCASE <Informatik>Functional (mathematics)Revision controlComputer hardwareType theoryDefault (computer science)TunisBinary codeComponent-based software engineeringComputer clusterReading (process)EmailStructural loadProjective planeSequelContext awarenessGradientGraph (mathematics)SoftwareOperator (mathematics)Product (business)Multiplication signData structureConfiguration spaceUML
UMLComputer animation
Transcript: English(auto-generated)