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

PostgreSQL partitioning. Work In Progress.

00:00
subtitles
off
playback rate
1
subtitles
off
English (auto-generated)
playback rate
0.25
0.5
0.75
1
1.25
1.5
1.75
2
quality
576p
9
 Cite
 Share
 Related Material
 Download Purchase
Logo of FOSDEM VZWFOSDEM VZW
 Lubennikova, Anastasia

Formal Metadata

Title
PostgreSQL partitioning. Work In Progress.
Title of Series
Number of Parts
637
Author
Contributors
N. N.
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

Content Metadata

Subject Area
Genre
Abstract
Native partitioning was introduced in PostgreSQL 10, and every new release comes with more features and optimizations to this area. Yet, there is still room for improvement. This talk briefly compares the built-in PostgreSQL partitioning with third-party extensions (pgpathman and pgpartman), to understand what we still don't have in the core. This talk also includes an overview of partitioning-related features that are currently being developed and aimed for PostgreSQL 14.
00:00
Software developerPerspective (visual)Incidence algebraScaling (geometry)Presentation of a groupDatabasePartition (number theory)Open sourceCore dumpState of matterOcean currentProjective planeError messageChord (peer-to-peer)Computer animation
00:40
Partition (number theory)Hacker (term)InformationDeclarative programmingData managementComputer configurationVolumeDisintegrationSoftware maintenanceUsabilityReplication (computing)Table (information)WaveQuery languageStrategy gameBound stateRange (statistics)Electronic mailing listHash functionRegulärer Ausdruck <Textverarbeitung>Data storage devicePrice indexSubsetDefault (computer science)Series (mathematics)Library catalogPhysical systemAttribute grammarTupleType theoryUniqueness quantificationConstraint (mathematics)UsabilityQuery languageMereologyDeclarative programmingField (computer science)Key (cryptography)Computer configurationChemical equationSet (mathematics)Partition (number theory)Web pageINTEGRALReplication (computing)Social classHierarchySpecial functionsLevel (video gaming)1 (number)Network topologyElectronic mailing listInformationCASE <Informatik>Theory of relativityHacker (term)Type theoryCodeTerm (mathematics)Revision controlData managementMathematical optimizationSinc functionOperator (mathematics)Limit (category theory)ConcentricVideoconferencingAreaoutputBlogPresentation of a groupBound stateTable (information)Default (computer science)Library catalogPhysical systemStrategy gameSubsetExpressionSubject indexingConstraint (mathematics)Analytic continuationInheritance (object-oriented programming)Exclusive orFlow separationImplementationDifferent (Kate Ryan album)Core dumpQuicksortPerspective (visual)MetreData storage deviceShape (magazine)Group actionMultiplicationGraph coloringExistenceComputer architectureAxiom of choiceRadical (chemistry)Position operatorUniformer RaumError messageSource codeMedical imagingCondition numberProjective planeRegular graphSanitary sewerComputer animation
07:40
Latent heatStrategy gameHash functionPartition (number theory)Default (computer science)Electronic mailing listMaxima and minimaRange (statistics)Inheritance (object-oriented programming)Table (information)Price indexUsabilityBound stateEvent horizonMathematicsSubject indexingSerial portRevision controlExtension (kinesiology)Declarative programmingData managementMechanism designPlanningRun time (program lifecycle phase)Function (mathematics)Extension (kinesiology)Function (mathematics)Projective planeInformationRevision controlPartition (number theory)Serial portHash functionRange (statistics)Table (information)Constraint (mathematics)Declarative programmingUsabilitySubject indexingSoftware maintenanceBound stateEvent horizonArithmetic progressionElectronic mailing listDefault (computer science)Sinc functionMultiplication signNumbering schemeSet (mathematics)Software bugSoftware developerParallel portMultiplicationOperator (mathematics)Heegaard splittingOcean currentSlide ruleOrder (biology)Concurrency (computer science)Limit (category theory)Physical systemWorkloadKey (cryptography)Complete metric spaceStrategy gameInsertion lossStatement (computer science)System callExterior algebra1 (number)Position operatorTouch typingImplementationMathematicsLatent heatFlock (web browser)Maxwell's equationsCore dumpRotationTelecommunicationOnline helpData managementGraph coloringGroup actionAddress spaceDifferent (Kate Ryan album)WordTask (computing)Computer animation
14:41
Data managementPartition (number theory)Range (statistics)Event horizonRun time (program lifecycle phase)Mechanism designPlanningFunction (mathematics)Asynchronous Transfer ModeStapeldateiConcurrency (computer science)Inheritance (object-oriented programming)Table (information)Software maintenanceExtension (kinesiology)Point cloudPrice indexElectronic mailing listHash functionBound stateStatisticsVacuumDrop (liquid)Object (grammar)Limit (category theory)Link (knot theory)WaveWeb pageWikiDeclarative programmingLengthStapeldateiFunction (mathematics)Ocean currentExtension (kinesiology)Arithmetic progressionMathematical optimizationSoftware developerSoftware maintenanceOperator (mathematics)Limit (category theory)Slide ruleTable (information)Patch (Unix)Partition (number theory)Group actionBitInheritance (object-oriented programming)outputConcurrency (computer science)Physical systemElectronic mailing listLink (knot theory)Projective planeElectric generatorEvent horizonObject (grammar)Computer architecturePlanningCore dumpRun time (program lifecycle phase)FeedbackWebsiteUsabilitySubject indexingDatabaseMathematicsSerial portVacuumStatisticsCoroutineMultiplication signData managementRange (statistics)Particle systemMoment (mathematics)Shared memorySystem callHeegaard splittingPoint cloudProcess (computing)QuicksortDataflowFlow separationLocal ringFiber bundleRevision controlMechanism designBuildingCycle (graph theory)TesselationRational numberComputer animation
21:42
Element (mathematics)Partition (number theory)Discrete groupFlow separationExclusive orBitMessage passingTransportation theory (mathematics)Expert systemBit rateMereologyPredicate (grammar)Operator (mathematics)NumberOcean current2 (number)Key (cryptography)Streaming mediaDeadlockShooting methodCausalityPerspective (visual)Grand Unified TheoryOracleRight angleRevision controlLatent heatMechanism designTable (information)InformationConstraint (mathematics)Hacker (term)Point (geometry)Event horizonServer (computing)Instance (computer science)Bound stateNormal (geometry)Concurrency (computer science)Insertion lossRegular graphComputer animationMeeting/Interview
28:54
Element (mathematics)Computer animation
Transcript: English(auto-generated)